Commit | Line | Data |
9bc6db13 |
1 | use strict; |
2 | use Test::More; |
3 | |
4 | BEGIN { |
134ea846 |
5 | eval "use DBIx::Class::CDBICompat;"; |
6 | if ($@) { |
7 | plan (skip_all => 'Class::Trigger and DBIx::ContextualFetch required'); |
8 | next; |
9 | } |
10 | eval "use DBD::SQLite"; |
c73f755d |
11 | plan $@ ? (skip_all => 'needs DBD::SQLite for testing') : (tests => 75); |
9bc6db13 |
12 | } |
13 | |
14 | INIT { |
d4519f23 |
15 | #local $SIG{__WARN__} = |
16 | #sub { like $_[0], qr/clashes with built-in method/, $_[0] }; |
17 | use lib 't/testlib'; |
18 | require Film; |
19 | require Actor; |
48cb8be4 |
20 | require Director; |
21 | |
d4519f23 |
22 | Actor->has_a(film => 'Film'); |
48cb8be4 |
23 | Film->has_a(director => 'Director'); |
24 | |
d4519f23 |
25 | sub Class::DBI::sheep { ok 0; } |
9bc6db13 |
26 | } |
27 | |
28 | sub Film::mutator_name { |
d4519f23 |
29 | my ($class, $col) = @_; |
30 | return "set_sheep" if lc $col eq "numexplodingsheep"; |
31 | return $col; |
9bc6db13 |
32 | } |
33 | |
34 | sub Film::accessor_name { |
d4519f23 |
35 | my ($class, $col) = @_; |
36 | return "sheep" if lc $col eq "numexplodingsheep"; |
37 | return $col; |
9bc6db13 |
38 | } |
39 | |
e60dc79f |
40 | sub Actor::accessor_name_for { |
d4519f23 |
41 | my ($class, $col) = @_; |
42 | return "movie" if lc $col eq "film"; |
43 | return $col; |
9bc6db13 |
44 | } |
45 | |
5e85c671 |
46 | # This is a class with accessor_name_for() but no corresponding mutator_name_for() |
e60dc79f |
47 | sub Director::accessor_name_for { |
48 | my($class, $col) = @_; |
49 | return "nutty_as_a_fruitcake" if lc $col eq "isinsane"; |
50 | return $col; |
51 | } |
52 | |
9bc6db13 |
53 | my $data = { |
d4519f23 |
54 | Title => 'Bad Taste', |
55 | Director => 'Peter Jackson', |
56 | Rating => 'R', |
9bc6db13 |
57 | }; |
58 | |
59 | eval { |
c73f755d |
60 | my $data = { %$data }; |
d4519f23 |
61 | $data->{NumExplodingSheep} = 1; |
62 | ok my $bt = Film->create($data), "Modified accessor - with column name"; |
63 | isa_ok $bt, "Film"; |
c73f755d |
64 | is $bt->sheep, 1, 'sheep bursting violently'; |
9bc6db13 |
65 | }; |
66 | is $@, '', "No errors"; |
67 | |
68 | eval { |
c73f755d |
69 | my $data = { %$data }; |
70 | $data->{sheep} = 2; |
d4519f23 |
71 | ok my $bt = Film->create($data), "Modified accessor - with accessor"; |
72 | isa_ok $bt, "Film"; |
c73f755d |
73 | is $bt->sheep, 2, 'sheep bursting violently'; |
74 | }; |
75 | is $@, '', "No errors"; |
76 | |
77 | eval { |
78 | my $data = { %$data }; |
79 | $data->{NumExplodingSheep} = 1; |
80 | ok my $bt = Film->find_or_create($data), |
81 | "find_or_create Modified accessor - find with column name"; |
82 | isa_ok $bt, "Film"; |
83 | is $bt->sheep, 1, 'sheep bursting violently'; |
84 | }; |
85 | is $@, '', "No errors"; |
86 | |
87 | eval { |
88 | my $data = { %$data }; |
89 | $data->{sheep} = 1; |
90 | ok my $bt = Film->find_or_create($data), |
91 | "find_or_create Modified accessor - find with accessor"; |
92 | isa_ok $bt, "Film"; |
93 | is $bt->sheep, 1, 'sheep bursting violently'; |
94 | }; |
95 | is $@, '', "No errors"; |
96 | |
97 | eval { |
98 | my $data = { %$data }; |
99 | $data->{NumExplodingSheep} = 3; |
100 | ok my $bt = Film->find_or_create($data), |
101 | "find_or_create Modified accessor - create with column name"; |
102 | isa_ok $bt, "Film"; |
103 | is $bt->sheep, 3, 'sheep bursting violently'; |
104 | }; |
105 | is $@, '', "No errors"; |
106 | |
107 | eval { |
108 | my $data = { %$data }; |
109 | $data->{sheep} = 4; |
110 | ok my $bt = Film->find_or_create($data), |
111 | "find_or_create Modified accessor - create with accessor"; |
112 | isa_ok $bt, "Film"; |
113 | is $bt->sheep, 4, 'sheep bursting violently'; |
9bc6db13 |
114 | }; |
115 | is $@, '', "No errors"; |
116 | |
117 | eval { |
d4519f23 |
118 | my @film = Film->search({ sheep => 1 }); |
119 | is @film, 2, "Can search with modified accessor"; |
9bc6db13 |
120 | }; |
c73f755d |
121 | is $@, '', "No errors"; |
9bc6db13 |
122 | |
123 | { |
124 | |
d4519f23 |
125 | eval { |
126 | local $data->{set_sheep} = 1; |
127 | ok my $bt = Film->create($data), "Modified mutator - with mutator"; |
128 | isa_ok $bt, "Film"; |
129 | }; |
130 | is $@, '', "No errors"; |
131 | |
132 | eval { |
133 | local $data->{NumExplodingSheep} = 1; |
134 | ok my $bt = Film->create($data), "Modified mutator - with column name"; |
135 | isa_ok $bt, "Film"; |
136 | }; |
137 | is $@, '', "No errors"; |
138 | |
139 | eval { |
140 | local $data->{sheep} = 1; |
141 | ok my $bt = Film->create($data), "Modified mutator - with accessor"; |
142 | isa_ok $bt, "Film"; |
143 | }; |
144 | is $@, '', "No errors"; |
9bc6db13 |
145 | |
146 | } |
147 | |
148 | { |
d4519f23 |
149 | my $p_data = { |
150 | name => 'Peter Jackson', |
151 | film => 'Bad Taste', |
152 | }; |
153 | my $bt = Film->create($data); |
154 | my $ac = Actor->create($p_data); |
155 | |
48cb8be4 |
156 | ok !eval { my $f = $ac->film; 1 }; |
d4519f23 |
157 | like $@, qr/film/, "no hasa film"; |
158 | |
159 | eval { |
dec1bfe0 |
160 | local $SIG{__WARN__} = sub { |
161 | warn @_ unless $_[0] =~ /Query returned more than one row/; |
162 | }; |
d4519f23 |
163 | ok my $f = $ac->movie, "hasa movie"; |
164 | isa_ok $f, "Film"; |
165 | is $f->id, $bt->id, " - Bad Taste"; |
166 | }; |
167 | is $@, '', "No errors"; |
168 | |
169 | { |
170 | local $data->{Title} = "Another film"; |
171 | my $film = Film->create($data); |
172 | |
173 | eval { $ac->film($film) }; |
174 | ok $@, $@; |
175 | |
176 | eval { $ac->movie($film) }; |
177 | ok $@, $@; |
178 | |
179 | eval { |
180 | ok $ac->set_film($film), "Set movie through hasa"; |
181 | $ac->update; |
182 | ok my $f = $ac->movie, "hasa movie"; |
183 | isa_ok $f, "Film"; |
184 | is $f->id, $film->id, " - Another Film"; |
185 | }; |
186 | is $@, '', "No problem"; |
187 | } |
9bc6db13 |
188 | |
189 | } |
190 | |
e60dc79f |
191 | |
192 | # Make sure a class with an accessor_name() method has a similar mutator. |
193 | { |
194 | my $aki = Director->create({ |
195 | name => "Aki Kaurismaki", |
196 | }); |
197 | |
198 | $aki->nutty_as_a_fruitcake(1); |
199 | is $aki->nutty_as_a_fruitcake, 1, |
200 | "a custom accessor without a custom mutator is setable"; |
201 | $aki->update; |
202 | } |
203 | |
204 | { |
d4519f23 |
205 | Film->columns(TEMP => qw/nonpersistent/); |
206 | ok(Film->find_column('nonpersistent'), "nonpersistent is a column"); |
207 | ok(!Film->has_real_column('nonpersistent'), " - but it's not real"); |
208 | |
209 | { |
210 | my $film = Film->create({ Title => "Veronique", nonpersistent => 42 }); |
211 | is $film->title, "Veronique", "Title set OK"; |
212 | is $film->nonpersistent, 42, "As is non persistent value"; |
213 | $film->remove_from_object_index; |
214 | ok $film = Film->retrieve('Veronique'), "Re-retrieve film"; |
215 | is $film->title, "Veronique", "Title still OK"; |
216 | is $film->nonpersistent, undef, "Non persistent value gone"; |
217 | ok $film->nonpersistent(40), "Can set it"; |
218 | is $film->nonpersistent, 40, "And it's there again"; |
219 | ok $film->update, "Commit the film"; |
220 | is $film->nonpersistent, 40, "And it's still there"; |
221 | } |
9bc6db13 |
222 | } |
223 | |
e60dc79f |
224 | { |
d4519f23 |
225 | is_deeply( |
226 | [Actor->columns('Essential')], |
227 | [Actor->columns('Primary')], |
228 | "Actor has no specific essential columns" |
229 | ); |
230 | ok(Actor->find_column('nonpersistent'), "nonpersistent is a column"); |
231 | ok(!Actor->has_real_column('nonpersistent'), " - but it's not real"); |
232 | my $pj = eval { Actor->search(name => "Peter Jackson")->first }; |
233 | is $@, '', "no problems retrieving actors"; |
234 | isa_ok $pj => "Actor"; |
9bc6db13 |
235 | } |
236 | |
e60dc79f |
237 | { |
d4519f23 |
238 | Film->autoupdate(1); |
239 | my $naked = Film->create({ title => 'Naked' }); |
240 | my $sandl = Film->create({ title => 'Secrets and Lies' }); |
241 | |
242 | my $rating = 1; |
243 | my $update_failure = sub { |
244 | my $obj = shift; |
245 | eval { $obj->rating($rating++) }; |
246 | return $@ =~ /read only/; |
247 | }; |
248 | |
249 | ok !$update_failure->($naked), "Can update Naked"; |
250 | ok $naked->make_read_only, "Make Naked read only"; |
251 | ok $update_failure->($naked), "Can't update Naked any more"; |
252 | ok !$update_failure->($sandl), "But can still update Secrets and Lies"; |
253 | my $july4 = eval { Film->create({ title => "4 Days in July" }) }; |
254 | isa_ok $july4 => "Film", "And can still create new films"; |
255 | |
256 | ok(Film->make_read_only, "Make all Films read only"); |
257 | ok $update_failure->($naked), "Still can't update Naked"; |
258 | ok $update_failure->($sandl), "And can't update S&L any more"; |
259 | eval { $july4->delete }; |
260 | like $@, qr/read only/, "And can't delete 4 Days in July"; |
261 | my $abigail = eval { Film->create({ title => "Abigail's Party" }) }; |
262 | like $@, qr/read only/, "Or create new films"; |
48cb8be4 |
263 | |
264 | $sandl->discard_changes; |
9bc6db13 |
265 | } |