4 # This file is a test script for C4::VirtualShelves.pm
5 # Author : Antoine Farnault, antoine@koha-fr.org
9 use Test::More tests => 82;
12 use C4::Biblio qw( AddBiblio DelBiblio );
15 # Getting some borrowers from database.
16 my $dbh = C4::Context->dbh;
22 my $sth = $dbh->prepare($query);
25 while(my $borrower = $sth->fetchrow){
26 push @borrowers, $borrower;
29 # Creating some biblios
32 my ($biblionumber)= AddBiblio(MARC::Record->new, '');
34 push @biblionumbers, $biblionumber;
37 # FIXME Why are you deleting my shelves? See bug 10386.
38 my $delete_virtualshelf = q{
39 DELETE FROM virtualshelves WHERE 1
41 my $delete_virtualshelfcontent = q{
42 DELETE FROM virtualshelfcontents WHERE 1
45 $sth = $dbh->prepare($delete_virtualshelf);
47 $sth = $dbh->prepare($delete_virtualshelfcontent);
51 #----------------------------------------------------------------------#
55 #----------------------------------------------------------------------#
57 use_ok('C4::VirtualShelves');
59 #-----------------------TEST AddShelf function------------------------#
60 # usage : $shelfnumber = &AddShelf( $shelfname, $owner, $category);
62 # creating 10 good shelves.
64 for(my $i=0; $i<10;$i++){
65 my $ShelfNumber = AddShelf(
66 {shelfname=>"Shelf_".$i, category=>int(rand(2))+1 }, $borrowers[$i] );
67 die "test Not ok, remove some shelves before" if ($ShelfNumber == -1);
68 ok($ShelfNumber > -1, "created shelf"); # Shelf creation successful;
69 push @shelves, $ShelfNumber if $ShelfNumber > -1;
72 ok(10 == scalar @shelves, 'created 10 lists'); # 10 shelves in @shelves;
74 # try to create some shelf which already exists.
75 for(my $i=0;$i<10;$i++){
76 my @shlf=GetShelf($shelves[$i]);
78 # FIXME This test still needs some attention
79 # A shelf name is not per se unique ! See report 10386
80 #temporary hack: Original test only for public list
82 my $badNumShelf= AddShelf(
83 {shelfname=>"Shelf_".$i, category => 2}, $borrowers[$i]);
84 ok(-1==$badNumShelf, 'do not create public lists with duplicate names');
85 #AddShelf returns -1 if name already exist.
88 ok(1==1, "This trivial test cannot fail :)"); #leave count intact
92 #-----------TEST AddToShelf & GetShelfContents & DelFromShelf functions--------------#
93 # usage : &AddToShelf($biblionumber, $shelfnumber);
94 # usage : $biblist = &GetShelfContents($shelfnumber);
95 # usage : $biblist = GetShelfContents($shelfnumber);
98 for(my $i=0; $i<10;$i++){
99 my $bib = $biblionumbers[int(rand(9))];
100 my $shelfnumber = $shelves[int(rand(9))];
102 my $key = "$bib\t$shelfnumber";
103 my $should_fail = exists($used{$key}) ? 1 : 0;
105 my ($biblistBefore,$countbefore) = GetShelfContents($shelfnumber);
106 my $status = AddToShelf($bib,$shelfnumber,$borrowers[$i]);
107 my ($biblistAfter,$countafter) = GetShelfContents($shelfnumber);
110 ok(!defined($status), 'failed to add to list when we should');
112 ok(defined($status), 'added to list when we should');
115 if (defined $status) {
116 ok($countbefore == $countafter - 1, 'added bib to list'); # the bib has been successfuly added.
118 ok($countbefore == $countafter, 'did not add duplicate bib to list'); # the bib has been successfuly added.
125 #-----------------------TEST ModShelf & GetShelf functions------------------------#
126 # usage : ModShelf($shelfnumber, $shelfname, $owner, $category )
127 # usage : (shelfnumber,shelfname,owner,category) = GetShelf($shelfnumber);
129 for(my $i=0; $i<10;$i++){
130 my $rand = int(rand(9));
131 my $numA = $shelves[$rand];
132 my $shelf = { shelfname => "NewName_".$rand,
133 category => int(rand(2))+1 };
135 ModShelf($numA,$shelf);
136 my ($numB,$nameB,$ownerB,$categoryB) = GetShelf($numA);
138 ok($numA == $numB, 'modified shelf');
139 ok($shelf->{shelfname} eq $nameB, '... and name change took');
140 ok($shelf->{category} eq $categoryB, '... and category change took');
143 #-----------------------TEST DelShelf & DelFromShelf functions------------------------#
144 # usage : ($status) = &DelShelf($shelfnumber);
146 for(my $i=0; $i<10;$i++){
147 my $shelfnumber = $shelves[$i];
148 my $status = DelShelf($shelfnumber);
149 ok(1 == $status, "deleted shelf $shelfnumber and its contents");
152 #----------------------- CLEANUP ----------------------------------------------#
153 DelBiblio($_) for @biblionumbers;