|
Line 0
Link Here
|
| 0 |
- |
1 |
use Modern::Perl; |
|
|
2 |
|
| 3 |
#die "Do NOT execute this script on a production server, it could affect your data\n Edit it and remove this line if you really want to use it"; |
| 4 |
|
| 5 |
use Time::HiRes qw(gettimeofday); |
| 6 |
use C4::Context; |
| 7 |
use C4::Biblio qw( AddBiblio ); # We shouldn't use it |
| 8 |
|
| 9 |
use Selenium::Remote::Driver; |
| 10 |
use Test::More tests => 20; |
| 11 |
use MARC::Record; |
| 12 |
use MARC::Field; |
| 13 |
|
| 14 |
my $dbh = C4::Context->dbh; |
| 15 |
my $login = 'koha'; |
| 16 |
my $password = 'koha'; |
| 17 |
my $base_url= 'http://'.C4::Context->preference("staffClientBaseURL")."/cgi-bin/koha/"; |
| 18 |
|
| 19 |
my $number_of_biblios_to_insert = 3; |
| 20 |
our $sample_data = { |
| 21 |
category => { |
| 22 |
categorycode => 'test_cat', |
| 23 |
description => 'test cat description', |
| 24 |
enrolmentperiod => '12', |
| 25 |
category_type => 'A' |
| 26 |
}, |
| 27 |
patron => { |
| 28 |
surname => 'test_patron_surname', |
| 29 |
cardnumber => '4242424242', |
| 30 |
userid => 'test_username', |
| 31 |
password => 'password', |
| 32 |
password2 => 'password' |
| 33 |
}, |
| 34 |
}; |
| 35 |
|
| 36 |
|
| 37 |
#my $form_data; |
| 38 |
#while ( my ($entity_name, $values) = each %$sample_data ) { |
| 39 |
# while ( my ( $field, $value ) = each %$values ) { |
| 40 |
# push @{ $form_data->{$entity_name} }, { field => $field, value => $value }; |
| 41 |
# } |
| 42 |
#} |
| 43 |
|
| 44 |
open our $fh, '>>', '/tmp/output.txt'; |
| 45 |
|
| 46 |
my $driver = Selenium::Remote::Driver->new; |
| 47 |
our $start = gettimeofday; |
| 48 |
our $prev_time = $start; |
| 49 |
$driver->get($base_url."mainpage.pl"); |
| 50 |
like( $driver->get_title(), qr(Log in to Koha), ); |
| 51 |
auth( $driver, $login, $password ); |
| 52 |
time_diff("main"); |
| 53 |
|
| 54 |
$driver->get($base_url.'admin/categorie.pl'); |
| 55 |
like( $driver->get_title(), qr(Patron categories), ); |
| 56 |
$driver->find_element('//a[@id="newcategory"]')->click; |
| 57 |
like( $driver->get_title(), qr(New category), ); |
| 58 |
fill_form( $driver, $sample_data->{category} ); |
| 59 |
$driver->find_element('//input[@type="button"]')->click; |
| 60 |
|
| 61 |
time_diff("add patron category"); |
| 62 |
$driver->get($base_url.'/members/memberentry.pl?op=add&categorycode='.$sample_data->{category}{categorycode}); |
| 63 |
like( $driver->get_title(), qr(Add .*$sample_data->{category}{description}), ); |
| 64 |
fill_form( $driver, $sample_data->{patron} ); |
| 65 |
$driver->find_element('//fieldset[@class="action"]/input[@type="submit"]')->click; |
| 66 |
like( $driver->get_title(), qr(Patron details for $sample_data->{patron}{surname}), ); |
| 67 |
|
| 68 |
####$driver->get($base_url.'/members/members-home.pl'); |
| 69 |
####fill_form( $driver, { searchmember => $sample_data->{patron}{cardnumber} } ); |
| 70 |
####$driver->find_element('//div[@id="header_search"]/div/form/input[@type="submit"]')->click; |
| 71 |
####like( $driver->get_title(), qr(Patron details for), ); |
| 72 |
|
| 73 |
time_diff("add patron"); |
| 74 |
|
| 75 |
our $borrowernumber = $dbh->selectcol_arrayref(q|SELECT borrowernumber FROM borrowers WHERE userid=?|, {}, $sample_data->{patron}{userid} ); |
| 76 |
$borrowernumber = $borrowernumber->[0]; |
| 77 |
|
| 78 |
my @biblionumbers; |
| 79 |
for my $i ( 1 .. $number_of_biblios_to_insert ) { |
| 80 |
my $biblio = MARC::Record->new(); |
| 81 |
my $title = 'test biblio '.$i; |
| 82 |
if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) { |
| 83 |
$biblio->append_fields( |
| 84 |
MARC::Field->new('200', ' ', ' ', a => 'test biblio '.$i), |
| 85 |
MARC::Field->new('200', ' ', ' ', f => 'test author '.$i), |
| 86 |
); |
| 87 |
} else { |
| 88 |
$biblio->append_fields( |
| 89 |
MARC::Field->new('245', ' ', ' ', a => 'test biblio '.$i), |
| 90 |
MARC::Field->new('100', ' ', ' ', a => 'test author '.$i), |
| 91 |
); |
| 92 |
} |
| 93 |
my ($biblionumber, $biblioitemnumber) = AddBiblio($biblio, ''); |
| 94 |
push @biblionumbers, $biblionumber; |
| 95 |
} |
| 96 |
|
| 97 |
time_diff("add biblio"); |
| 98 |
|
| 99 |
my $itemtype = $dbh->selectcol_arrayref(q|SELECT itemtype FROM itemtypes|); |
| 100 |
$itemtype = $itemtype->[0]; |
| 101 |
|
| 102 |
for my $biblionumber ( @biblionumbers ) { |
| 103 |
$driver->get($base_url."/cataloguing/additem.pl?biblionumber=$biblionumber"); |
| 104 |
like( $driver->get_title(), qr(test biblio \d+ by test author), ); |
| 105 |
my $form = $driver->find_element('//form[@name="f"]'); |
| 106 |
my $inputs = $driver->find_child_elements($form, '//input[@type="text"]'); |
| 107 |
for my $input ( @$inputs ) { |
| 108 |
next if $input->is_hidden(); |
| 109 |
$input->send_keys('t_value_bib'.$biblionumber); |
| 110 |
} |
| 111 |
|
| 112 |
$driver->find_element('//input[@name="add_submit"]')->click; |
| 113 |
like( $driver->get_title(), qr($biblionumber.*Items) ); |
| 114 |
|
| 115 |
$dbh->do(q|UPDATE items SET notforloan=0 WHERE biblionumber=?|, {}, $biblionumber ); |
| 116 |
$dbh->do(q|UPDATE biblioitems SET itemtype=? WHERE biblionumber=?|, {}, $itemtype, $biblionumber); |
| 117 |
$dbh->do(q|UPDATE items SET itype=? WHERE biblionumber=?|, {}, $itemtype, $biblionumber); |
| 118 |
} |
| 119 |
|
| 120 |
time_diff("add items"); |
| 121 |
|
| 122 |
my $nb_of_checkouts = 0; |
| 123 |
for my $biblionumber ( @biblionumbers ) { |
| 124 |
$driver->get($base_url."/circ/circulation.pl?borrowernumber=".$borrowernumber); |
| 125 |
$driver->find_element('//input[@id="barcode"]')->send_keys('t_value_bib'.$biblionumber); |
| 126 |
$driver->find_element('//fieldset[@id="circ_circulation_issue"]/button[@type="submit"]')->click; |
| 127 |
$nb_of_checkouts++; |
| 128 |
like( $driver->get_title(), qr(Checking out to $sample_data->{patron}{surname}) ); |
| 129 |
is( $driver->find_element('//a[@href="#checkouts"]')->get_attribute('text'), $nb_of_checkouts.' Checkout(s)', ); |
| 130 |
} |
| 131 |
|
| 132 |
time_diff("checkout"); |
| 133 |
|
| 134 |
for my $biblionumber ( @biblionumbers ) { |
| 135 |
$driver->get($base_url."/circ/returns.pl"); |
| 136 |
$driver->find_element('//input[@id="barcode"]')->send_keys('t_value_bib'.$biblionumber); |
| 137 |
$driver->find_element('//form[@id="checkin-form"]/div/fieldset/input[@type="submit"]')->click; |
| 138 |
like( $driver->get_title(), qr(Check in test biblio \d+) ); |
| 139 |
} |
| 140 |
|
| 141 |
time_diff("checkin"); |
| 142 |
|
| 143 |
close $fh; |
| 144 |
$driver->quit(); |
| 145 |
|
| 146 |
END { |
| 147 |
cleanup(); |
| 148 |
}; |
| 149 |
|
| 150 |
sub auth { |
| 151 |
my ( $driver, $login, $password) = @_; |
| 152 |
fill_form( $driver, { userid => 'koha', password => 'koha' } ); |
| 153 |
my $login_button = $driver->find_element('//input[@id="submit"]'); |
| 154 |
$login_button->submit(); |
| 155 |
} |
| 156 |
|
| 157 |
sub fill_form { |
| 158 |
my ( $driver, $values ) = @_; |
| 159 |
while ( my ( $id, $value ) = each %$values ) { |
| 160 |
my $element = $driver->find_element('//*[@id="'.$id.'"]'); |
| 161 |
my $tag = $element->get_tag_name(); |
| 162 |
if ( $tag eq 'input' ) { |
| 163 |
$driver->find_element('//input[@id="'.$id.'"]')->send_keys($value); |
| 164 |
} elsif ( $tag eq 'select' ) { |
| 165 |
$driver->find_element('//select[@id="'.$id.'"]/option[@value="'.$value.'"]')->click; |
| 166 |
} |
| 167 |
} |
| 168 |
} |
| 169 |
|
| 170 |
sub cleanup { |
| 171 |
my $dbh = C4::Context->dbh; |
| 172 |
$dbh->do(q|DELETE FROM categories WHERE categorycode = ?|, {}, $sample_data->{category}{categorycode}); |
| 173 |
$dbh->do(q|DELETE FROM borrowers WHERE userid = ?|, {}, $sample_data->{patron}{userid}); |
| 174 |
for my $i ( 1 .. $number_of_biblios_to_insert ) { |
| 175 |
$dbh->do(qq|DELETE FROM biblio WHERE title = "test biblio $i"|); |
| 176 |
}; |
| 177 |
|
| 178 |
$dbh->do(q|DELETE FROM issues where borrowernumber=?|, {}, $borrowernumber); |
| 179 |
$dbh->do(q|DELETE FROM old_issues where borrowernumber=?|, {}, $borrowernumber); |
| 180 |
for my $i ( 1 .. $number_of_biblios_to_insert ) { |
| 181 |
$dbh->do(qq|DELETE items, biblio FROM biblio INNER JOIN items ON biblio.biblionumber = items.biblionumber WHERE biblio.title = "test biblio$i"|); |
| 182 |
}; |
| 183 |
} |
| 184 |
|
| 185 |
sub time_diff { |
| 186 |
my $lib = shift; |
| 187 |
my $now = gettimeofday; |
| 188 |
warn "CP $lib = " . sprintf("%.2f", $now - $prev_time ) . "\n"; |
| 189 |
$prev_time = $now; |
| 190 |
} |