3 # This file is part of Koha.
5 # Koha is free software; you can redistribute it and/or modify it
6 # under the terms of the GNU General Public License as published by
7 # the Free Software Foundation; either version 3 of the License, or
8 # (at your option) any later version.
10 # Koha is distributed in the hope that it will be useful, but
11 # WITHOUT ANY WARRANTY; without even the implied warranty of
12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 # GNU General Public License for more details.
15 # You should have received a copy of the GNU General Public License
16 # along with Koha; if not, see <http://www.gnu.org/licenses>.
20 use Test::More tests => 17;
28 use_ok('Koha::Objects');
29 use_ok('Koha::Patrons');
33 my $dbh = C4::Context->dbh;
34 $dbh->{AutoCommit} = 0;
35 $dbh->{RaiseError} = 1;
36 $dbh->do("DELETE FROM issues");
37 $dbh->do("DELETE FROM borrowers");
40 Koha::Database->new()->schema()->resultset('Category')->first()
43 Koha::Database->new()->schema()->resultset('Branch')->first()->branchcode();
45 my $b1 = Koha::Patron->new(
48 branchcode => $branchcode,
49 categorycode => $categorycode
53 my $b2 = Koha::Patron->new(
56 branchcode => $branchcode,
57 categorycode => $categorycode
61 my $three_days_ago = dt_from_string->add( days => -3 );
62 my $b3 = Koha::Patron->new(
65 branchcode => $branchcode,
66 categorycode => $categorycode,
67 updated_on => $three_days_ago,
72 my $b1_new = Koha::Patrons->find( $b1->borrowernumber() );
73 is( $b1->surname(), $b1_new->surname(), "Found matching patron" );
74 isnt( $b1_new->updated_on, undef, "borrowers.updated_on should be set" );
75 is( dt_from_string($b1_new->updated_on), dt_from_string, "borrowers.updated_on should have been set to now on creating" );
77 my $b3_new = Koha::Patrons->find( $b3->borrowernumber() );
78 is( dt_from_string($b3_new->updated_on), $three_days_ago, "borrowers.updated_on should have been kept to what we set on creating" );
79 $b3_new->set({ surname => 'another surname for Test 3' });
80 $b3_new = Koha::Patrons->find( $b3->borrowernumber() );
81 is( dt_from_string($b1_new->updated_on), dt_from_string, "borrowers.updated_on should have been set to now on updating" );
83 my @patrons = Koha::Patrons->search( { branchcode => $branchcode } );
84 is( @patrons, 3, "Found 3 patrons with Search" );
86 my $unexistent = Koha::Patrons->find( '1234567890' );
87 is( $unexistent, undef, 'Koha::Objects->Find should return undef if the record does not exist' );
89 my $patrons = Koha::Patrons->search( { branchcode => $branchcode } );
90 is( $patrons->count( { branchcode => $branchcode } ), 3, "Counted 3 patrons with Count" );
92 my $b = $patrons->next();
93 is( $b->surname(), 'Test 1', "Next returns first patron" );
94 $b = $patrons->next();
95 is( $b->surname(), 'Test 2', "Next returns second patron" );
96 $b = $patrons->next();
97 is( $b->surname(), 'Test 3', "Next returns third patron" );
98 $b = $patrons->next();
99 is( $b, undef, "Next returns undef" );
101 # Test Reset and iteration in concert
103 foreach my $b ( $patrons->as_list() ) {
104 is( $b->categorycode(), $categorycode, "Iteration returns a patron object" );