3 # Copyright 2015 Koha Development team
5 # This file is part of Koha
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use Test
::More tests
=> 20;
26 use Koha
::Authority
::Types
;
28 use Koha
::Patron
::Category
;
29 use Koha
::Patron
::Categories
;
33 use t
::lib
::TestBuilder
;
37 my $schema = Koha
::Database
->new->schema;
38 $schema->storage->txn_begin;
39 my $builder = t
::lib
::TestBuilder
->new;
41 is
( ref(Koha
::Authority
::Types
->find('')), 'Koha::Authority::Type', 'Koha::Objects->find should work if the primary key is an empty string' );
43 my @columns = Koha
::Patrons
->columns;
44 my $borrowernumber_exists = grep { /^borrowernumber$/ } @columns;
45 is
( $borrowernumber_exists, 1, 'Koha::Objects->columns should return the table columns' );
47 subtest
'find' => sub {
49 my $patron = $builder->build({source
=> 'Borrower'});
50 my $patron_object = Koha
::Patrons
->find( $patron->{borrowernumber
} );
51 is
( $patron_object->borrowernumber, $patron->{borrowernumber
}, '->find should return the correct object' );
53 my @patrons = Koha
::Patrons
->find( $patron->{borrowernumber
} );
54 is
(scalar @patrons, 1, '->find in list context returns a value');
55 is
($patrons[0]->borrowernumber, $patron->{borrowernumber
}, '->find in list context returns the same value as in scalar context');
58 foo
=> Koha
::Patrons
->find('foo'),
61 is
($patrons->{foo
}, undef, '->find in list context returns undef when no record is found');
63 # Test sending undef to find; should not generate a warning
64 warning_is
{ $patron = Koha
::Patrons
->find( undef ); }
65 "", "Sending undef does not trigger a DBIx warning";
66 warning_is
{ $patron = Koha
::Patrons
->find( undef, undef ); }
67 "", "Sending two undefs does not trigger a DBIx warning too";
70 subtest
'update' => sub {
73 $builder->build( { source
=> 'City', value
=> { city_country
=> 'UK' } } );
74 $builder->build( { source
=> 'City', value
=> { city_country
=> 'UK' } } );
75 $builder->build( { source
=> 'City', value
=> { city_country
=> 'UK' } } );
76 $builder->build( { source
=> 'City', value
=> { city_country
=> 'France' } } );
77 $builder->build( { source
=> 'City', value
=> { city_country
=> 'France' } } );
78 $builder->build( { source
=> 'City', value
=> { city_country
=> 'Germany' } } );
79 Koha
::Cities
->search( { city_country
=> 'UK' } )->update( { city_country
=> 'EU' } );
80 is
( Koha
::Cities
->search( { city_country
=> 'EU' } )->count, 3, 'Koha::Objects->update should have updated the 3 rows' );
81 is
( Koha
::Cities
->search( { city_country
=> 'UK' } )->count, 0, 'Koha::Objects->update should have updated the 3 rows' );
84 subtest
'reset' => sub {
87 my $patrons = Koha
::Patrons
->search;
88 my $first_borrowernumber = $patrons->next->borrowernumber;
89 my $second_borrowernumber = $patrons->next->borrowernumber;
90 is
( ref( $patrons->reset ), 'Koha::Patrons', 'Koha::Objects->reset should allow chaining' );
91 is
( ref( $patrons->reset->next ), 'Koha::Patron', 'Koha::Objects->reset should allow chaining' );
92 is
( $patrons->reset->next->borrowernumber, $first_borrowernumber, 'Koha::Objects->reset should work as expected');
95 subtest
'delete' => sub {
98 my $patron_1 = $builder->build({source
=> 'Borrower'});
99 my $patron_2 = $builder->build({source
=> 'Borrower'});
100 is
( Koha
::Patrons
->search({ -or => { borrowernumber
=> [ $patron_1->{borrowernumber
}, $patron_2->{borrowernumber
}]}})->delete, 2, '');
101 is
( Koha
::Patrons
->search({ -or => { borrowernumber
=> [ $patron_1->{borrowernumber
}, $patron_2->{borrowernumber
}]}})->count, 0, '');
104 subtest
'new' => sub {
106 my $a_cat_code = 'A_CAT_CODE';
107 my $patron_category = Koha
::Patron
::Category
->new( { categorycode
=> $a_cat_code } )->store;
108 is
( Koha
::Patron
::Categories
->find($a_cat_code)->category_type, 'A', 'Koha::Object->new should set the default value' );
109 Koha
::Patron
::Categories
->find($a_cat_code)->delete;
110 $patron_category = Koha
::Patron
::Category
->new( { categorycode
=> $a_cat_code, category_type
=> undef } )->store;
111 is
( Koha
::Patron
::Categories
->find($a_cat_code)->category_type, 'A', 'Koha::Object->new should set the default value even if the argument exists but is not defined' );
112 Koha
::Patron
::Categories
->find($a_cat_code)->delete;
115 subtest
'find' => sub {
118 # check find on a single PK
119 my $patron = $builder->build({ source
=> 'Borrower' });
120 is
( Koha
::Patrons
->find($patron->{borrowernumber
})->surname,
121 $patron->{surname
}, "Checking an arbitrary patron column after find"
123 # check find with unique column
124 my $obj = Koha
::Patrons
->find($patron->{cardnumber
}, { key
=> 'cardnumber' });
125 is
( $obj->borrowernumber, $patron->{borrowernumber
},
126 'Find with unique column and key specified' );
127 # check find with an additional where clause in the attrs hash
128 # we do not expect to find something now
129 is
( Koha
::Patrons
->find(
130 $patron->{borrowernumber
},
131 { where
=> { surname
=> { '!=', $patron->{surname
} }}},
132 ), undef, 'Additional where clause in find call' );
134 is
( Koha
::Patrons
->find(), undef, 'Find returns undef if no params passed' );
137 subtest
'search_related' => sub {
139 my $builder = t
::lib
::TestBuilder
->new;
140 my $patron_1 = $builder->build( { source
=> 'Borrower' } );
141 my $patron_2 = $builder->build( { source
=> 'Borrower' } );
142 my $libraries = Koha
::Patrons
->search( { -or => { borrowernumber
=> [ $patron_1->{borrowernumber
}, $patron_2->{borrowernumber
} ] } } )->search_related('branchcode');
143 is
( ref( $libraries ), 'Koha::Libraries', 'Koha::Objects->search_related should return an instanciated Koha::Objects-based object' );
144 is
( $libraries->count, 2, 'Koha::Objects->search_related should work as expected' );
145 is
( $libraries->next->branchcode, $patron_1->{branchcode
}, 'Koha::Objects->search_related should work as expected' );
146 is
( $libraries->next->branchcode, $patron_2->{branchcode
}, 'Koha::Objects->search_related should work as expected' );
148 my @libraries = Koha
::Patrons
->search( { -or => { borrowernumber
=> [ $patron_1->{borrowernumber
}, $patron_2->{borrowernumber
} ] } } )->search_related('branchcode');
149 is
( ref( $libraries[0] ), 'Koha::Library', 'Koha::Objects->search_related should return a list of Koha::Object-based objects' );
150 is
( scalar(@libraries), 2, 'Koha::Objects->search_related should work as expected' );
151 is
( $libraries[0]->branchcode, $patron_1->{branchcode
}, 'Koha::Objects->search_related should work as expected' );
152 is
( $libraries[1]->branchcode, $patron_2->{branchcode
}, 'Koha::Objects->search_related should work as expected' );
155 subtest
'single' => sub {
157 my $builder = t
::lib
::TestBuilder
->new;
158 my $patron_1 = $builder->build( { source
=> 'Borrower' } );
159 my $patron_2 = $builder->build( { source
=> 'Borrower' } );
160 my $patron = Koha
::Patrons
->search({}, { rows
=> 1 })->single;
161 is
(ref($patron), 'Koha::Patron', 'Koha::Objects->single returns a single Koha::Patron object.');
162 warning_like
{ Koha
::Patrons
->search->single } qr/SQL that returns multiple rows/,
163 "Warning is presented if single is used for a result with multiple rows.";
166 subtest
'last' => sub {
168 my $builder = t
::lib
::TestBuilder
->new;
169 my $patron_1 = $builder->build( { source
=> 'Borrower' } );
170 my $patron_2 = $builder->build( { source
=> 'Borrower' } );
171 my $last_patron = Koha
::Patrons
->search->last;
172 is
( $last_patron->borrowernumber, $patron_2->{borrowernumber
}, '->last should return the last inserted patron' );
173 $last_patron = Koha
::Patrons
->search({ borrowernumber
=> $patron_1->{borrowernumber
} })->last;
174 is
( $last_patron->borrowernumber, $patron_1->{borrowernumber
}, '->last should work even if there is only 1 result' );
175 $last_patron = Koha
::Patrons
->search({ surname
=> 'should_not_exist' })->last;
176 is
( $last_patron, undef, '->last should return undef if search does not return any results' );
179 subtest
'get_column' => sub {
181 my @cities = Koha
::Cities
->search;
182 my @city_names = map { $_->city_name } @cities;
183 is_deeply
( [ Koha
::Cities
->search->get_column('city_name') ], \
@city_names, 'Koha::Objects->get_column should be allowed' );
186 subtest
'Exceptions' => sub {
189 my $patron_borrowernumber = $builder->build({ source
=> 'Borrower' })->{ borrowernumber
};
190 my $patron = Koha
::Patrons
->find( $patron_borrowernumber );
194 $patron->blah('blah');
196 ok
( $_->isa('Koha::Exceptions::Object::MethodNotCoveredByTests'),
197 'Calling a non-covered method should raise a Koha::Exceptions::Object::MethodNotCoveredByTests exception' );
198 is
( $_->message, 'The method Koha::Patron->blah is not covered by tests!', 'The message raised should contain the package and the method' );
202 $patron->set({ blah
=> 'blah' });
204 ok
( $_->isa('Koha::Exceptions::Object::PropertyNotFound'),
205 'Setting a non-existent property should raise a Koha::Exceptions::Object::PropertyNotFound exception' );
210 Koha
::Patrons
->search->not_covered_yet;
212 ok
( $_->isa('Koha::Exceptions::Object::MethodNotCoveredByTests'),
213 'Calling a non-covered method should raise a Koha::Exceptions::Object::MethodNotCoveredByTests exception' );
214 is
( $_->message, 'The method Koha::Patrons->not_covered_yet is not covered by tests!', 'The message raised should contain the package and the method' );
218 Koha
::Patrons
->not_covered_yet;
220 ok
( $_->isa('Koha::Exceptions::Object::MethodNotCoveredByTests'),
221 'Calling a non-covered method should raise a Koha::Exceptions::Object::MethodNotCoveredByTests exception' );
222 is
( $_->message, 'The method Koha::Patrons->not_covered_yet is not covered by tests!', 'The message raised should contain the package and the method' );
226 $schema->storage->txn_rollback;
228 subtest
'->is_paged and ->pager tests' => sub {
232 $schema->storage->txn_begin;
234 # Delete existing patrons
235 Koha
::Checkouts
->delete;
236 Koha
::Patrons
->delete;
239 $builder->build_object({ class => 'Koha::Patrons' });
242 # Non-paginated search
243 my $patrons = Koha
::Patrons
->search();
244 is
( $patrons->count, 10, 'Search returns all patrons' );
245 ok
( !$patrons->is_paged, 'Search is not paged' );
248 $patrons = Koha
::Patrons
->search( undef, { 'page' => 1, 'rows' => 3 } );
249 is
( $patrons->count, 3, 'Search returns only one page, 3 patrons' );
250 ok
( $patrons->is_paged, 'Search is paged' );
251 my $pager = $patrons->pager;
252 is
( ref($patrons->pager), 'DBIx::Class::ResultSet::Pager',
253 'Koha::Objects->pager returns a valid DBIx::Class object' );
255 $schema->storage->txn_rollback;
258 subtest
'->search() tests' => sub {
262 $schema->storage->txn_begin;
264 my $count = Koha
::Patrons
->search->count;
268 $builder->build_object({ class => 'Koha::Patrons' });
271 my $patrons = Koha
::Patrons
->search();
272 is
( ref($patrons), 'Koha::Patrons', 'search in scalar context returns the Koha::Object-based type' );
273 my @patrons = Koha
::Patrons
->search();
274 is
( scalar @patrons, $count + 10, 'search in list context returns a list of objects' );
277 is
( ref($patrons[$i]), 'Koha::Patron', 'Objects in the list have the singular type' );
281 $schema->storage->txn_rollback;
284 subtest
"to_api() tests" => sub {
288 $schema->storage->txn_begin;
290 my $city_1 = $builder->build_object( { class => 'Koha::Cities' } );
291 my $city_2 = $builder->build_object( { class => 'Koha::Cities' } );
293 my $cities = Koha
::Cities
->search(
295 cityid
=> [ $city_1->cityid, $city_2->cityid ]
297 { -orderby
=> { -desc
=> 'cityid' } }
300 is
( $cities->count, 2, 'Count is correct' );
301 my $cities_api = $cities->to_api;
302 is
( ref( $cities_api ), 'ARRAY', 'to_api returns an array' );
303 is_deeply
( $cities_api->[0], $city_1->to_api, 'to_api returns the individual objects with ->to_api' );
304 is_deeply
( $cities_api->[1], $city_2->to_api, 'to_api returns the individual objects with ->to_api' );
306 my $biblio_1 = $builder->build_sample_biblio();
307 my $item_1 = $builder->build_sample_item({ biblionumber
=> $biblio_1->biblionumber });
308 my $hold_1 = $builder->build_object(
310 class => 'Koha::Holds',
311 value
=> { itemnumber
=> $item_1->itemnumber }
315 my $biblio_2 = $builder->build_sample_biblio();
316 my $item_2 = $builder->build_sample_item({ biblionumber
=> $biblio_2->biblionumber });
317 my $hold_2 = $builder->build_object(
319 class => 'Koha::Holds',
320 value
=> { itemnumber
=> $item_2->itemnumber }
324 my $embed = { 'items' => {} };
327 my @items = ( $item_1, $item_2 );
328 my @holds = ( $hold_1, $hold_2 );
330 my $biblios_api = Koha
::Biblios
->search(
332 biblionumber
=> [ $biblio_1->biblionumber, $biblio_2->biblionumber ]
334 )->to_api( { embed
=> $embed } );
336 foreach my $biblio_api ( @
{ $biblios_api } ) {
337 ok
(exists $biblio_api->{items
}, 'Items where embedded in biblio results');
338 is
($biblio_api->{items
}->[0]->{item_id
}, $items[$i]->itemnumber, 'Item matches');
339 ok
(!exists $biblio_api->{items
}->[0]->{holds
}, 'No holds info should be embedded yet');
347 children
=> { 'holds' => {} }
353 $biblios_api = Koha
::Biblios
->search(
355 biblionumber
=> [ $biblio_1->biblionumber, $biblio_2->biblionumber ]
357 )->to_api( { embed
=> $embed } );
359 foreach my $biblio_api ( @
{ $biblios_api } ) {
361 ok
(exists $biblio_api->{items
}, 'Items where embedded in biblio results');
362 is
($biblio_api->{items
}->[0]->{item_id
}, $items[$i]->itemnumber, 'Item still matches');
363 ok
(exists $biblio_api->{items
}->[0]->{holds
}, 'Holds info should be embedded');
364 is
($biblio_api->{items
}->[0]->{holds
}->[0]->{hold_id
}, $holds[$i]->reserve_id, 'Hold matches');
369 $schema->storage->txn_rollback;
372 subtest
"TO_JSON() tests" => sub {
376 $schema->storage->txn_begin;
378 my $city_1 = $builder->build_object( { class => 'Koha::Cities' } );
379 my $city_2 = $builder->build_object( { class => 'Koha::Cities' } );
381 my $cities = Koha
::Cities
->search(
383 cityid
=> [ $city_1->cityid, $city_2->cityid ]
385 { -orderby
=> { -desc
=> 'cityid' } }
388 is
( $cities->count, 2, 'Count is correct' );
389 my $cities_json = $cities->TO_JSON;
390 is
( ref($cities_json), 'ARRAY', 'to_api returns an array' );
391 is_deeply
( $cities_json->[0], $city_1->TO_JSON, 'TO_JSON returns the individual objects with ->TO_JSON' );
392 is_deeply
( $cities_json->[1], $city_2->TO_JSON,'TO_JSON returns the individual objects with ->TO_JSON' );
394 $schema->storage->txn_rollback;
397 # Koha::Object[s] must behave the same as DBIx::Class
398 subtest
'Return same values as DBIx::Class' => sub {
401 subtest
'Delete' => sub {
404 $schema->storage->txn_begin;
406 subtest
'Simple Koha::Objects - Koha::Cities' => sub {
409 subtest
'Koha::Object->delete' => sub {
413 my ( $r_us, $e_us, $r_them, $e_them );
415 # CASE 1 - Delete an existing object
416 my $c = Koha
::City
->new( { city_name
=> 'city4test' } )->store;
417 try
{ $r_us = $c->delete; } catch
{ $e_us = $_ };
418 $c = $schema->resultset('City')->new( { city_name
=> 'city4test_2' } )->update_or_insert;
419 try
{ $r_them = $c->delete; } catch
{ $e_them = $_ };
420 ok
( ref($r_us) && ref($r_them),
421 'Successful delete should return the object ' );
422 ok
( !defined $e_us && !defined $e_them,
423 'Successful delete should not raise an exception' );
424 is
( ref($r_us), 'Koha::City', 'Successful delete should return our Koha::Obect based object' );
426 # CASE 2 - Delete an object that is not in storage
427 try
{ $r_us = $r_us->delete; } catch
{ $e_us = $_ };
428 try
{ $r_them = $r_them->delete; } catch
{ $e_them = $_ };
430 defined $e_us && defined $e_them,
431 'Delete an object that is not in storage should raise an exception'
433 is
( ref($e_us), 'DBIx::Class::Exception' )
434 ; # FIXME This needs adjustement, we want to throw a Koha::Exception
438 subtest
'Koha::Objects->delete' => sub {
442 my ( $r_us, $e_us, $r_them, $e_them );
444 # CASE 1 - Delete existing objects
445 my $city_1 = $builder->build_object({ class => 'Koha::Cities' });
446 my $city_2 = $builder->build_object({ class => 'Koha::Cities' });
447 my $city_3 = $builder->build_object({ class => 'Koha::Cities' });
448 my $cities = Koha
::Cities
->search(
460 try
{ $r_us = $cities->delete; } catch
{ $e_us = $_ };
462 $city_1 = $builder->build_object({ class => 'Koha::Cities' });
463 $city_2 = $builder->build_object({ class => 'Koha::Cities' });
464 $city_3 = $builder->build_object({ class => 'Koha::Cities' });
465 $cities = $schema->resultset('City')->search(
477 try
{ $r_them = $cities->delete; } catch
{ $e_them = $_ };
479 ok
( $r_us == 3 && $r_them == 3 );
480 ok
(!defined($e_us) && !defined($e_them));
482 # CASE 2 - One of the object is not in storage
483 $city_1 = $builder->build_object({ class => 'Koha::Cities' });
484 $city_2 = $builder->build_object({ class => 'Koha::Cities' });
485 $city_3 = $builder->build_object({ class => 'Koha::Cities' });
486 $cities = Koha
::Cities
->search(
498 $city_2->delete; # We delete one of the object
499 try
{ $r_us = $cities->delete; } catch
{ $e_us = $_ };
501 $city_1 = $builder->build_object({ class => 'Koha::Cities' });
502 $city_2 = $builder->build_object({ class => 'Koha::Cities' });
503 $city_3 = $builder->build_object({ class => 'Koha::Cities' });
504 $cities = $schema->resultset('City')->search(
516 $city_2->delete; # We delete one of the object
517 try
{ $r_them = $cities->delete; } catch
{ $e_them = $_ };
519 ok
( $r_us == 2 && $r_them == 2 );
520 ok
(!defined($e_us) && !defined($e_them));
524 subtest
'Overwritten Koha::Objects->delete - Koha::Patrons' => sub {
528 subtest
'Koha::Object->delete' => sub {
532 my ( $r_us, $e_us, $r_them, $e_them );
534 # CASE 1 - Delete an existing patron
535 my $patron = $builder->build_object({ class => 'Koha::Patrons' });
536 my $patron_data = $patron->unblessed;
539 $patron = Koha
::Patron
->new( $patron_data )->store;
540 try
{$r_us = $patron->delete;} catch
{ $e_us = $_ };
541 $patron = $schema->resultset('Borrower')->new( $patron_data )->update_or_insert;
542 try
{$r_them = $patron->delete;} catch
{ $e_them = $_ };
543 ok
( ref($r_us) && ref($r_them),
544 'Successful delete should return the patron object' );
545 ok
( !defined $e_us && !defined $e_them,
546 'Successful delete should not raise an exception' );
547 is
( ref($r_us), 'Koha::Patron',
548 'Successful delete should return our Koha::Obect based object' );
550 # CASE 2 - Delete a patron that is not in storage
551 try
{ $r_us = $r_us->delete; } catch
{ $e_us = $_ };
552 try
{ $r_them = $r_them->delete; } catch
{ $e_them = $_ };
554 defined $e_us && defined $e_them,
555 'Delete a patron that is not in storage should raise an exception'
557 is
( ref($e_us), 'DBIx::Class::Exception' )
558 ; # FIXME This needs adjustement, we want to throw a Koha::Exception
560 # CASE 3 - Delete a patron that cannot be deleted (as a checkout)
561 $patron = Koha
::Patron
->new($patron_data)->store;
562 $builder->build_object(
564 class => 'Koha::Checkouts',
565 value
=> { borrowernumber
=> $patron->borrowernumber }
568 try
{ $r_us = $r_us->delete; } catch
{ $e_us = $_ };
569 $patron = $schema->resultset('Borrower')->find( $patron->borrowernumber );
570 try
{ $r_them = $r_them->delete; } catch
{ $e_them = $_ };
572 defined $e_us && defined $e_them,
573 'Delete a patron that cannot be deleted should raise an exception'
575 is
( ref($e_us), 'DBIx::Class::Exception' )
576 ; # FIXME This needs adjustement, we want to throw a Koha::Exception
579 subtest
'Koha::Objects->delete' => sub {
583 my ( $r_us, $e_us, $r_them, $e_them );
585 # CASE 1 - Delete existing objects
586 my $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
587 my $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
588 my $patron_3 = $builder->build_object({ class => 'Koha::Patrons' });
589 my $patrons = Koha
::Patrons
->search(
593 $patron_1->borrowernumber,
594 $patron_2->borrowernumber,
595 $patron_3->borrowernumber
601 try
{ $r_us = $patrons->delete; } catch
{ $e_us = $_ };
603 $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
604 $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
605 $patron_3 = $builder->build_object({ class => 'Koha::Patrons' });
606 $patrons = $schema->resultset('Borrower')->search(
610 $patron_1->borrowernumber,
611 $patron_2->borrowernumber,
612 $patron_3->borrowernumber
618 try
{ $r_them = $patrons->delete; } catch
{ $e_them = $_ };
620 ok
( $r_us == 3 && $r_them == 3, '->delete should return the number of deleted patrons' );
621 ok
(!defined($e_us) && !defined($e_them), '->delete should not raise exception if everything went well');
623 # CASE 2 - One of the patrons is not in storage
624 undef $_ for $r_us, $e_us, $r_them, $e_them;
625 $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
626 $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
627 $patron_3 = $builder->build_object({ class => 'Koha::Patrons' });
628 $patrons = Koha
::Patrons
->search(
632 $patron_1->borrowernumber,
633 $patron_2->borrowernumber,
634 $patron_3->borrowernumber
640 $patron_2->delete; # We delete one of the patron
641 try
{ $r_us = $patrons->delete; } catch
{ $e_us = $_ };
643 $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
644 $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
645 $patron_3 = $builder->build_object({ class => 'Koha::Patrons' });
646 $patrons = $schema->resultset('Borrower')->search(
650 $patron_1->borrowernumber,
651 $patron_2->borrowernumber,
652 $patron_3->borrowernumber
658 $patron_2->delete; # We delete one of the patron
659 try
{ $r_them = $patrons->delete; } catch
{ $e_them = $_ };
661 ok
( $r_us == 2 && $r_them == 2, 'Delete patrons with one that was not in storage should delete the patrons' );
662 ok
(!defined($e_us) && !defined($e_them), 'no exception should be raised if at least one patron was not in storage');
664 # CASE 3 - Delete a set of patrons with one that that cannot be deleted (as a checkout)
665 undef $_ for $r_us, $e_us, $r_them, $e_them;
666 $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
667 $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
668 $patron_3 = $builder->build_object({ class => 'Koha::Patrons' });
669 $patrons = Koha
::Patrons
->search(
673 $patron_1->borrowernumber,
674 $patron_2->borrowernumber,
675 $patron_3->borrowernumber
681 # Adding a checkout to patron_2
682 $builder->build_object(
684 class => 'Koha::Checkouts',
685 value
=> { borrowernumber
=> $patron_2->borrowernumber }
690 try
{ $r_us = $patrons->delete; } catch
{ $e_us = $_ };
692 qr{DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails},
693 "Foreign key constraint DBI error should be logged";
694 my $not_deleted_us = $patron_1->in_storage + $patron_2->in_storage + $patron_3->in_storage;
696 $patron_1 = $builder->build_object({ class => 'Koha::Patrons' });
697 $patron_2 = $builder->build_object({ class => 'Koha::Patrons' });
698 $patron_3 = $builder->build_object({ class => 'Koha::Patrons' });
699 $patrons = $schema->resultset('Borrower')->search(
703 $patron_1->borrowernumber,
704 $patron_2->borrowernumber,
705 $patron_3->borrowernumber
711 # Adding a checkout to patron_2
712 $builder->build_object(
714 class => 'Koha::Checkouts',
715 value
=> { borrowernumber
=> $patron_2->borrowernumber }
720 try
{ $r_them = $patrons->delete; } catch
{ $e_them = $_ };
722 qr{DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails},
723 "Foreign key constraint DBI error should be logged";
725 my $not_deleted_them = $patron_1->in_storage + $patron_2->in_storage + $patron_3->in_storage;
727 defined $e_us && defined $e_them,
728 'Delete patrons with one that cannot be deleted should raise an exception'
730 is
( ref($e_us), 'DBIx::Class::Exception' )
731 ; # FIXME This needs adjustement, we want to throw a Koha::Exception
733 ok
($not_deleted_us == 3 && $not_deleted_them == 3, 'If one patron cannot be deleted, none should have been deleted');
737 $schema->storage->txn_rollback;
742 subtest
"attributes_from_api() tests" => sub {
746 $schema->storage->txn_begin;
748 my $cities_rs = Koha
::Cities
->new;
749 my $city = Koha
::City
->new;
751 my $api_attributes = {
757 $cities_rs->attributes_from_api($api_attributes),
758 $city->attributes_from_api($api_attributes)
761 $schema->storage->txn_rollback;
764 subtest
"from_api_mapping() tests" => sub {
768 $schema->storage->txn_begin;
770 my $cities_rs = Koha
::Cities
->new;
771 my $city = Koha
::City
->new;
774 $cities_rs->from_api_mapping,
775 $city->from_api_mapping
778 $schema->storage->txn_rollback;