Commit | Line | Data |
70350518 |
1 | use strict; |
794b796f |
2 | use warnings; |
70350518 |
3 | |
4 | use Test::More; |
794b796f |
5 | use Test::Exception; |
70350518 |
6 | use lib qw(t/lib); |
7 | use DBICTest; |
8 | |
a47e1233 |
9 | my $schema = DBICTest->init_schema(); |
0567538f |
10 | |
11 | eval { require DateTime }; |
12 | plan skip_all => "Need DateTime for inflation tests" if $@; |
13 | |
c6e0ee83 |
14 | $schema->class('CD') ->inflate_column( 'year', |
0567538f |
15 | { inflate => sub { DateTime->new( year => shift ) }, |
16 | deflate => sub { shift->year } } |
17 | ); |
18 | |
f92b166e |
19 | my $rs = $schema->resultset('CD'); |
20 | |
0567538f |
21 | # inflation test |
f92b166e |
22 | my $cd = $rs->find(3); |
0567538f |
23 | |
24 | is( ref($cd->year), 'DateTime', 'year is a DateTime, ok' ); |
25 | |
89279e9d |
26 | is( $cd->year->year, 1997, 'inflated year ok' ); |
27 | |
0567538f |
28 | is( $cd->year->month, 1, 'inflated month ok' ); |
29 | |
e81a6241 |
30 | eval { $cd->year(\'year +1'); }; |
31 | ok(!$@, 'updated year using a scalarref'); |
32 | $cd->update(); |
33 | $cd->discard_changes(); |
34 | |
35 | is( ref($cd->year), 'DateTime', 'year is still a DateTime, ok' ); |
36 | |
37 | is( $cd->year->year, 1998, 'updated year, bypassing inflation' ); |
38 | |
39 | is( $cd->year->month, 1, 'month is still 1' ); |
40 | |
41 | # get_inflated_column test |
42 | |
43 | is( ref($cd->get_inflated_column('year')), 'DateTime', 'get_inflated_column produces a DateTime'); |
44 | |
0567538f |
45 | # deflate test |
46 | my $now = DateTime->now; |
47 | $cd->year( $now ); |
48 | $cd->update; |
49 | |
f92b166e |
50 | $cd = $rs->find(3); |
0567538f |
51 | is( $cd->year->year, $now->year, 'deflate ok' ); |
52 | |
e81a6241 |
53 | # set_inflated_column test |
54 | eval { $cd->set_inflated_column('year', $now) }; |
55 | ok(!$@, 'set_inflated_column with DateTime object'); |
56 | $cd->update; |
57 | |
f92b166e |
58 | $cd = $rs->find(3); |
e81a6241 |
59 | is( $cd->year->year, $now->year, 'deflate ok' ); |
60 | |
f92b166e |
61 | $cd = $rs->find(3); |
ad5d0ee9 |
62 | my $before_year = $cd->year->year; |
e81a6241 |
63 | eval { $cd->set_inflated_column('year', \'year + 1') }; |
e81a6241 |
64 | ok(!$@, 'set_inflated_column to "year + 1"'); |
65 | $cd->update; |
e81a6241 |
66 | |
7d409be1 |
67 | $cd->store_inflated_column('year', \'year + 1'); |
68 | is_deeply( $cd->year, \'year + 1', 'scalarref deflate passthrough ok' ); |
c6e0ee83 |
69 | |
f92b166e |
70 | $cd = $rs->find(3); |
ad5d0ee9 |
71 | is( $cd->year->year, $before_year+1, 'deflate ok' ); |
e81a6241 |
72 | |
73 | # store_inflated_column test |
f92b166e |
74 | $cd = $rs->find(3); |
e81a6241 |
75 | eval { $cd->store_inflated_column('year', $now) }; |
76 | ok(!$@, 'store_inflated_column with DateTime object'); |
77 | $cd->update; |
78 | |
79 | is( $cd->year->year, $now->year, 'deflate ok' ); |
80 | |
ad5d0ee9 |
81 | # update tests |
f92b166e |
82 | $cd = $rs->find(3); |
ad5d0ee9 |
83 | eval { $cd->update({'year' => $now}) }; |
84 | ok(!$@, 'update using DateTime object ok'); |
85 | is($cd->year->year, $now->year, 'deflate ok'); |
86 | |
f92b166e |
87 | $cd = $rs->find(3); |
ad5d0ee9 |
88 | $before_year = $cd->year->year; |
89 | eval { $cd->update({'year' => \'year + 1'}) }; |
90 | ok(!$@, 'update using scalarref ok'); |
91 | |
f92b166e |
92 | $cd = $rs->find(3); |
ad5d0ee9 |
93 | is($cd->year->year, $before_year + 1, 'deflate ok'); |
94 | |
95 | # discard_changes test |
f92b166e |
96 | $cd = $rs->find(3); |
ad5d0ee9 |
97 | # inflate the year |
98 | $before_year = $cd->year->year; |
99 | $cd->update({ year => \'year + 1'}); |
100 | $cd->discard_changes; |
101 | |
102 | is($cd->year->year, $before_year + 1, 'discard_changes clears the inflated value'); |
07d4fb20 |
103 | |
104 | my $copy = $cd->copy({ year => $now, title => "zemoose" }); |
105 | |
f92b166e |
106 | is( $copy->year->year, $now->year, "copy" ); |
107 | |
108 | |
109 | |
110 | my $artist = $cd->artist; |
111 | my $sval = \ '2012'; |
112 | |
113 | $cd = $rs->create ({ |
114 | artist => $artist, |
115 | year => $sval, |
116 | title => 'create with scalarref', |
117 | }); |
118 | |
119 | is ($cd->year, $sval, 'scalar value retained'); |
120 | my $cd2 = $cd->copy ({ title => 'copy with scalar in coldata' }); |
121 | is ($cd2->year, $sval, 'copied scalar value retained'); |
122 | |
123 | $cd->discard_changes; |
124 | is ($cd->year->year, 2012, 'infation upon reload'); |
125 | |
126 | $cd2->discard_changes; |
127 | is ($cd2->year->year, 2012, 'infation upon reload of copy'); |
128 | |
129 | |
130 | my $precount = $rs->count; |
131 | $cd = $rs->update_or_create ({artist => $artist, title => 'nonexisting update/create test row', year => $sval }); |
132 | is ($rs->count, $precount + 1, 'Row created'); |
133 | |
134 | is ($cd->year, $sval, 'scalar value retained on creating update_or_create'); |
135 | $cd->discard_changes; |
136 | is ($cd->year->year, 2012, 'infation upon reload'); |
137 | |
138 | my $sval2 = \ '2013'; |
139 | |
140 | $cd = $rs->update_or_create ({artist => $artist, title => 'nonexisting update/create test row', year => $sval2 }); |
141 | is ($rs->count, $precount + 1, 'No more rows created'); |
142 | |
143 | is ($cd->year, $sval2, 'scalar value retained on updating update_or_create'); |
144 | $cd->discard_changes; |
145 | is ($cd->year->year, 2013, 'infation upon reload'); |
794b796f |
146 | |
147 | done_testing; |