t/db_dependent/selenium/basic_workflow.t

   1 #!/usr/bin/perl
   2
   3 # This file is part of Koha.
   4 #
   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.
   9 #
  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.
  14 #
  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>.
  17
  18
  19
  20 # wget https://selenium-release.storage.googleapis.com/2.53/selenium-server-standalone-2.53.1.jar # Does not work with 3.4, did not test the ones between
  21 # sudo apt-get install xvfb firefox-esr
  22 # SELENIUM_PATH=/home/vagrant/selenium-server-standalone-2.53.1.jar
  23 # Xvfb :1 -screen 0 1024x768x24 2>&1 >/dev/null &
  24 # DISPLAY=:1 java -jar $SELENIUM_PATH
  25 #
  26 # Then you can execute the test file.
  27 #
  28 # If you get:
  29 # Wide character in print at /usr/local/share/perl/5.20.2/Test2/Formatter/TAP.pm line 105.
  30 # #                   'Koha › Patrons › Add patron test_patron_surname (Adult)'
  31 # #     doesn't match '(?^u:Patron details for test_patron_surname)'
  32 #
  33 # Ignore and retry (FIXME LATER...)
  34
  35 use Modern::Perl;
  36
  37 use Time::HiRes qw(gettimeofday);
  38 use C4::Context;
  39 use C4::Biblio qw( AddBiblio ); # We shouldn't use it
  40
  41 use Koha::CirculationRules;
  42
  43 use Test::More tests => 20;
  44 use MARC::Record;
  45 use MARC::Field;
  46
  47 use t::lib::Selenium;
  48
  49 my $dbh      = C4::Context->dbh;
  50
  51 my $number_of_biblios_to_insert = 3;
  52 our $sample_data = {
  53     category => {
  54         categorycode    => 'TEST_CAT',
  55         description     => 'test cat description',
  56         enrolmentperiod => '12',
  57         category_type   => 'A'
  58     },
  59     patron => {
  60         surname    => 'test_patron_surname',
  61         cardnumber => '4242424242',
  62         userid     => 'test_username',
  63         password   => '1BetterPassword',
  64         password2  => '1BetterPassword'
  65     },
  66     itemtype => {
  67         itemtype     => 'IT4TEST',
  68         description  => 'Just an itemtype for tests',
  69         rentalcharge => 0,
  70         notforloan   => 0,
  71     },
  72     issuingrule => {
  73         categorycode  => 'test_cat',
  74         itemtype      => 'IT4test',
  75         branchcode    => '*',
  76         maxissueqty   => '5',
  77         issuelength   => '5',
  78         lengthunit    => 'days',
  79         renewalperiod => '5',
  80       },
  81 };
  82 our ( $borrowernumber, $start, $prev_time, $cleanup_needed );
  83
  84 SKIP: {
  85     eval { require Selenium::Remote::Driver; };
  86     skip "Selenium::Remote::Driver is needed for selenium tests.", 20 if $@;
  87
  88     $cleanup_needed = 1;
  89
  90     open my $fh, '>>', '/tmp/output.txt';
  91
  92     my $s = t::lib::Selenium->new;
  93
  94     my $driver = $s->driver;
  95     my $base_url = $s->base_url;
  96
  97     $start = gettimeofday;
  98     $prev_time = $start;
  99     $driver->get($base_url."mainpage.pl");
 100     like( $driver->get_title(), qr(Log in to Koha), );
 101     $s->auth;
 102     time_diff("main");
 103
 104     $driver->get($base_url.'admin/categories.pl');
 105     like( $driver->get_title(), qr(Patron categories), );
 106     $driver->find_element('//a[@id="newcategory"]')->click;
 107     like( $driver->get_title(), qr(New category), );
 108     $s->fill_form( $sample_data->{category} );
 109     $driver->find_element('//fieldset[@class="action"]/input[@type="submit"]')->click;
 110
 111     time_diff("add patron category");
 112     $driver->get($base_url.'/members/memberentry.pl?op=add&amp;categorycode='.$sample_data->{category}{categorycode});
 113     like( $driver->get_title(), qr(Add .*$sample_data->{category}{description}), );
 114     $s->fill_form( $sample_data->{patron} );
 115     $driver->find_element('//button[@id="saverecord"]')->click;
 116     like( $driver->get_title(), qr(Patron details for $sample_data->{patron}{surname}), );
 117
 118     ####$driver->get($base_url.'/members/members-home.pl');
 119     ####fill_form( $driver, { searchmember => $sample_data->{patron}{cardnumber} } );
 120     ####$driver->find_element('//div[@id="header_search"]/div/form/input[@type="submit"]')->click;
 121     ####like( $driver->get_title(), qr(Patron details for), );
 122
 123     time_diff("add patron");
 124
 125     $borrowernumber = $dbh->selectcol_arrayref(q|SELECT borrowernumber FROM borrowers WHERE userid=?|, {}, $sample_data->{patron}{userid} )->[0];
 126
 127     my @biblionumbers;
 128     for my $i ( 1 .. $number_of_biblios_to_insert ) {
 129         my $biblio = MARC::Record->new();
 130         my $title = 'test biblio '.$i;
 131         if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) {
 132             $biblio->append_fields(
 133                 MARC::Field->new('200', ' ', ' ', a => 'test biblio '.$i),
 134                 MARC::Field->new('200', ' ', ' ', f => 'test author '.$i),
 135             );
 136         } else {
 137             $biblio->append_fields(
 138                 MARC::Field->new('245', ' ', ' ', a => 'test biblio '.$i),
 139                 MARC::Field->new('100', ' ', ' ', a => 'test author '.$i),
 140             );
 141         }
 142         my ($biblionumber, $biblioitemnumber) = AddBiblio($biblio, '');
 143         push @biblionumbers, $biblionumber;
 144     }
 145
 146     time_diff("add biblio");
 147
 148     my $itemtype = $sample_data->{itemtype};
 149     $dbh->do(q|INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan) VALUES (?, ?, ?, ?)|, undef, $itemtype->{itemtype}, $itemtype->{description}, $itemtype->{rentalcharge}, $itemtype->{notforloan});
 150
 151     my $issuing_rules = $sample_data->{issuingrule};
 152     $dbh->do(q|INSERT INTO issuingrules (categorycode, itemtype, branchcode, issuelength, lengthunit, renewalperiod) VALUES (?, ?, ?, ?, ?, ?)|, undef, $issuing_rules->{categorycode}, $issuing_rules->{itemtype}, $issuing_rules->{branchcode}, $issuing_rules->{issuelength}, $issuing_rules->{lengthunit}, $issuing_rules->{renewalperiod});
 153     Koha::CirculationRules->set_rules(
 154         {
 155             categorycode => $issuing_rules->{categorycode},
 156             itemtype     => $issuing_rules->{itemtype},
 157             branchcode   => $issuing_rules->{branchcode},
 158             rules        => {
 159                 maxissueqty => $issuing_rules->{maxissueqty}
 160             }
 161         }
 162     );
 163
 164
 165     for my $biblionumber ( @biblionumbers ) {
 166         $driver->get($base_url."/cataloguing/additem.pl?biblionumber=$biblionumber");
 167         like( $driver->get_title(), qr(test biblio \d+ by test author), );
 168         my $form = $driver->find_element('//form[@name="f"]');
 169         my $inputs = $driver->find_child_elements($form, '//input[@type="text"]');
 170         for my $input ( @$inputs ) {
 171             next if $input->is_hidden();
 172
 173             my $id = $input->get_attribute('id');
 174             next unless $id =~ m|^tag_952_subfield|;
 175
 176             my $v;
 177
 178             # FIXME This is based on default values
 179             if (   $id =~ m|^tag_952_subfield_g|   # price
 180                 or $id =~ m|^tag_952_subfield_v| ) # replacementprice
 181             {
 182                 $v = '42';    # It's a price
 183             }
 184             elsif (
 185                 $id =~ m|^tag_952_subfield_f| #tag_952_subfield_g
 186             ) {
 187                 # It's a varchar(10)
 188                 $v = 't_value_x';
 189             }
 190             else {
 191                 $v = 't_value_bib' . $biblionumber;
 192             }
 193             $input->send_keys( $v );
 194         }
 195
 196         $driver->find_element('//input[@name="add_submit"]')->click;
 197         like( $driver->get_title(), qr($biblionumber.*Items) );
 198
 199         $dbh->do(q|UPDATE items SET notforloan=0 WHERE biblionumber=?|, {}, $biblionumber );
 200         $dbh->do(q|UPDATE biblioitems SET itemtype=? WHERE biblionumber=?|, {}, $itemtype->{itemtype}, $biblionumber);
 201         $dbh->do(q|UPDATE items SET itype=? WHERE biblionumber=?|, {}, $itemtype->{itemtype}, $biblionumber);
 202     }
 203
 204     time_diff("add items");
 205
 206     my $nb_of_checkouts = 0;
 207     for my $biblionumber ( @biblionumbers ) {
 208         $driver->get($base_url."/circ/circulation.pl?borrowernumber=".$borrowernumber);
 209         $driver->find_element('//input[@id="barcode"]')->send_keys('t_value_bib'.$biblionumber);
 210         $driver->find_element('//fieldset[@id="circ_circulation_issue"]/button[@type="submit"]')->click;
 211         $nb_of_checkouts++;
 212         like( $driver->get_title(), qr(Checking out to $sample_data->{patron}{surname}) );
 213         is( $driver->find_element('//a[@href="#checkouts"]')->get_attribute('text'), $nb_of_checkouts.' Checkout(s)', );
 214     }
 215
 216     time_diff("checkout");
 217
 218     for my $biblionumber ( @biblionumbers ) {
 219         $driver->get($base_url."/circ/returns.pl");
 220         $driver->find_element('//input[@id="barcode"]')->send_keys('t_value_bib'.$biblionumber);
 221         $driver->find_element('//form[@id="checkin-form"]/div/fieldset/input[@type="submit"]')->click;
 222         like( $driver->get_title(), qr(Check in test biblio \d+) );
 223     }
 224
 225     time_diff("checkin");
 226
 227     close $fh;
 228     $driver->quit();
 229 };
 230
 231 END {
 232     cleanup() if $cleanup_needed;
 233 };
 234
 235 sub cleanup {
 236     my $dbh = C4::Context->dbh;
 237     $dbh->do(q|DELETE FROM issues where borrowernumber=?|, {}, $borrowernumber);
 238     $dbh->do(q|DELETE FROM old_issues where borrowernumber=?|, {}, $borrowernumber);
 239     for my $i ( 1 .. $number_of_biblios_to_insert ) {
 240         $dbh->do(qq|DELETE items, biblio FROM biblio INNER JOIN items ON biblio.biblionumber = items.biblionumber WHERE biblio.title = "test biblio$i"|);
 241     };
 242     $dbh->do(q|DELETE FROM borrowers WHERE userid = ?|, {}, $sample_data->{patron}{userid});
 243     $dbh->do(q|DELETE FROM categories WHERE categorycode = ?|, {}, $sample_data->{category}{categorycode});
 244     for my $i ( 1 .. $number_of_biblios_to_insert ) {
 245         $dbh->do(qq|DELETE FROM biblio WHERE title = "test biblio $i"|);
 246     };
 247     $dbh->do(q|DELETE FROM itemtypes WHERE itemtype=?|, undef, $sample_data->{itemtype}{itemtype});
 248     $dbh->do(q|DELETE FROM issuingrules WHERE categorycode=? AND itemtype=? AND branchcode=?|, undef, $sample_data->{issuingrule}{categorycode}, $sample_data->{issuingrule}{itemtype}, $sample_data->{issuingrule}{branchcode});
 249 }
 250
 251 sub time_diff {
 252     my $lib = shift;
 253     my $now = gettimeofday;
 254     warn "CP $lib = " . sprintf("%.2f", $now - $prev_time ) . "\n";
 255     $prev_time = $now;
 256 }