Bugzilla – Attachment 67342 Details for
Bug 19359
Reporting module selenium test
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 19359 - Reporting module selenium test
Bug-19359---Reporting-module-selenium-test.patch (text/plain), 11.79 KB, created by
Alex Buckley
on 2017-09-23 05:34:09 UTC
(
hide
)
Description:
Bug 19359 - Reporting module selenium test
Filename:
MIME Type:
Creator:
Alex Buckley
Created:
2017-09-23 05:34:09 UTC
Size:
11.79 KB
patch
obsolete
>From f1c3b229fab1540cca2245a4565e307872aedc50 Mon Sep 17 00:00:00 2001 >From: Alex Buckley <alexbuckley@catalyst.net.nz> >Date: Mon, 18 Sep 2017 05:47:24 +0000 >Subject: [PATCH] Bug 19359 - Reporting module selenium test > >This Selenium test tests the reporting module creating and running a custom report. > >Test plan (this test plan includes how to install Selenium as well as how to run this test, for the benefit of people who have not got >Selenium installed on their machines): > >1. wget >https://selenium-release.storage.googleapis.com/2.53/selenium-server-standalone-2.53.0.jar > >2. vim /etc/apt/sources.list.d/firefox.list > >3. Paste into the file: >deb http://packages.linuxmint.com debian import > >4. sudo apt-get update > >5. sudo apt-get install firefox > >6. sudo apt-get install xvfb > >7. Set the SELENIUM_PATH vartiable: >SELENIUM_PATH=/home/vagrant/kohaclone/selenium-server-standalone-2.53.0.jar > >8. Xvfb :1 -screen 0 1024x768x24 2>&1 >/dev/null & > >9. DISPLAY=:1 java -jar $SELENIUM_PATH > >Note: This will start up the selenium server. Everytime you want to >shutdown this terminal window and want to restart Selenium just run >the step 9 command to restart the Selenium server > >10. Open a new terminal window and write in: >git clone https://github.com/gempesaw/Selenium-Remote-Driver >--branch build/master --single-branch --depth 1 > >11. cd Selenium-Remote-Driver > >12. perl Makefile.PL > >13. make > >14. make test > >15. sudo make install > >16. Now everything is installed and you can set up for running the >selenium test > >17. Drop and recreate you Koha database and restart memcached > >18. Go through the web installer (installing sample z39.50 targets) >and the onboarding tool > >19. Create a superlibrarian user with the username koha and password koha > >20. If your usual port configuration for the intranet and OPAC is >8081 and 8080 respectively then set the staffClientBaseURL and >OPACBaseURL system preferences to localhost:8080 and localhost:80 >respectively > >21. sudo koha-shell <instancename> > >22. perl t/db_dependent/selenium/reporting_workflow.t > >23. The test should pass. >Note: The time_diff comments in the test output showing what the >test is doing > >Note: If you have issues with installing Selenium and >Selenium::Remote::Driver please write a comment on the bug report >and I will be more than happy to create a screencapture video >showing all the steps > >Sponsored-By: Catalyst IT >--- > t/db_dependent/selenium/reporting_workflow.t | 212 +++++++++++++++++++++++++++ > 1 file changed, 212 insertions(+) > create mode 100644 t/db_dependent/selenium/reporting_workflow.t > >diff --git a/t/db_dependent/selenium/reporting_workflow.t b/t/db_dependent/selenium/reporting_workflow.t >new file mode 100644 >index 0000000..28a5ca9 >--- /dev/null >+++ b/t/db_dependent/selenium/reporting_workflow.t >@@ -0,0 +1,212 @@ >+#!/usr/bin/perl >+ >+# This file is part of Koha. >+# >+# Copyright (C) 2017 Catalyst IT >+# >+# Koha is free software; you can redistribute it and/or modify it >+# under the terms of the GNU General Public License as published by >+# the Free Software Foundation; either version 3 of the License, or >+# (at your option) any later version. >+# >+# Koha is distributed in the hope that it will be useful, but >+# WITHOUT ANY WARRANTY; without even the implied warranty of >+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the >+# GNU General Public License for more details. >+# >+# You should have received a copy of the GNU General Public License >+# along with Koha; if not, see <http://www.gnu.org/licenses>. >+ >+#This selenium test tests the functionality to create and save a report. >+ >+#Note: If you are testing this on kohadevbox with selenium installed in kohadevbox then you need to set the staffClientBaseURL to localhost:8080 and the OPACBaseURL to http://localhost:80 >+ >+use Modern::Perl; >+ >+use Time::HiRes qw(gettimeofday); >+use C4::Context; >+use C4::Biblio qw( AddBiblio ); # We shouldn't use it >+ >+use Test::More tests => 7; >+use MARC::Record; >+use MARC::Field; >+use Selenium::Remote::Driver::Firefox::Profile; >+ >+my $dbh = C4::Context->dbh; >+my $login = 'koha'; >+my $password = 'koha'; >+my $base_url= 'http://'.C4::Context->preference("staffClientBaseURL")."/cgi-bin/koha/"; >+my $opac_url= C4::Context->preference("OPACBaseURL"); >+ >+my $number_of_biblios_to_insert = 3; >+our $sample_data = { >+ category => { >+ categorycode => 'test_cat', >+ description => 'test cat description', >+ enrolmentperiod => '12', >+ category_type => 'A' >+ }, >+ patron => { >+ surname => 'test_patron_surname', >+ cardnumber => '4242424242', >+ userid => 'test_username', >+ password => 'password', >+ password2 => 'password' >+ }, >+}; >+ >+my $patronusername="test_username"; >+my $patronpassword="password"; >+ >+our ( $borrowernumber, $start, $prev_time, $cleanup_needed ); >+ >+SKIP: { >+ eval { require Selenium::Remote::Driver; }; >+ skip "Selenium::Remote::Driver is needed for selenium tests.", 20 if $@; >+ >+ $cleanup_needed = 1; >+ >+ open my $fh, '>>', '/tmp/output.txt'; >+ >+ my $driver = Selenium::Remote::Driver->new; >+ my $browser_profile = Selenium::Remote::Driver::Firefox::Profile->new(); >+ $start = gettimeofday; >+ $prev_time = $start; >+ $driver->get($base_url."mainpage.pl"); >+ like( $driver->get_title(), qr(Log in to Koha), ); >+ auth( $driver, $login, $password ); >+ time_diff("main"); >+ >+ #Add biblio >+ $borrowernumber = $dbh->selectcol_arrayref(q|SELECT borrowernumber FROM borrowers WHERE userid=?|, {}, $sample_data->{patron}{userid} )->[0]; >+ >+ my @biblionumbers; >+ for my $i ( 1 .. $number_of_biblios_to_insert ) { >+ my $biblio = MARC::Record->new(); >+ my $title = 'test biblio '.$i; >+ if ( C4::Context->preference('marcflavour') eq 'UNIMARC' ) { >+ $biblio->append_fields( >+ MARC::Field->new('200', ' ', ' ', a => 'test biblio '.$i), >+ MARC::Field->new('200', ' ', ' ', f => 'test author '.$i), >+ ); >+ } else { >+ $biblio->append_fields( >+ MARC::Field->new('245', ' ', ' ', a => 'test biblio '.$i), >+ MARC::Field->new('100', ' ', ' ', a => 'test author '.$i), >+ ); >+ } >+ my ($biblionumber, $biblioitemnumber) = AddBiblio($biblio, ''); >+ push @biblionumbers, $biblionumber; >+ } >+ time_diff("add biblio"); >+ >+ #Add items to the biblio >+ my $itemtype = $dbh->selectcol_arrayref(q|SELECT itemtype FROM itemtypes|); >+ $itemtype = $itemtype->[0]; >+ >+ for my $biblionumber ( @biblionumbers ) { >+ $driver->get($base_url."/cataloguing/additem.pl?biblionumber=$biblionumber"); >+ like( $driver->get_title(), qr(test biblio \d+ by test author), ); >+ my $form = $driver->find_element('//form[@name="f"]'); >+ my $inputs = $driver->find_child_elements($form, '//input[@ type="text"]'); >+ for my $input ( @$inputs ) { >+ next if $input->is_hidden(); >+ my $id = $input->get_attribute('id'); >+ next unless $id =~ m|^tag_952_subfield|; >+ $input->send_keys('t_value_bib'.$biblionumber); >+ } >+ $driver->find_element('//input[@name="add_submit"]')->click; >+ like( $driver->get_title(), qr($biblionumber.*Items) ); >+ >+ $dbh->do(q|UPDATE items SET notforloan=0 WHERE biblionumber=?|, {}, $biblionumber ); >+ $dbh->do(q|UPDATE biblioitems SET itemtype=? WHERE biblionumber=?|, {}, $itemtype, $biblionumber); >+ $dbh->do(q|UPDATE items SET itype=? WHERE biblionumber=?|,{}, $itemtype, $biblionumber); >+ } >+ time_diff("add items"); >+ >+ #Navigate into Reports and create a new report >+ $driver->get($base_url."mainpage.pl"); >+ $driver->find_element_by_xpath('/html/body/div[4]/div/div[1]/div/div[1]/div[2]/div/ul/li[3]/a')->click; >+ $driver->pause(20000); >+ $driver->find_element_by_xpath('/html/body/div[4]/div/div[1]/div/div[1]/ul[1]/li[2]/a')->click; >+ $driver->pause(20000); >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[1]/ol/li[1]/select')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[1]/ol/li[1]/select/option[2]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[2]/input[2]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div[1]/form/fieldset[2]/input[3]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset/div/div[1]/div[1]/select/optgroup[1]/option[1]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset/div/div[1]/div[2]/input[1]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset/div/div[1]/div[1]/select/optgroup[1]/option[2]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset/div/div[1]/div[2]/input[1]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/div/fieldset/input[3]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[2]/input[3]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[2]/input[3]')->click; >+ $driver->pause(20000); >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[2]/input[2]')->click; >+ $driver->pause(20000); >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset/input[2]')->click; >+ $driver->pause(20000); >+ $driver->find_element('//input[@id="reportname"]')->send_keys("Test report"); >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[1]/ol/li[4]/textarea')->send_keys("This test retrieves item information from the catalog"); >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/form/fieldset[2]/input[2]')->click; >+ $driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/ul/li[1]/a')->click; >+ if ($driver->find_element_by_xpath('/html/body/div[5]/div/div[1]/div/table/tbody/tr[1]/th[1]')) { >+ time_diff("Report successfully created"); >+ } else { >+ time_diff("Report not successfully created"); >+ } >+ >+ close $fh; >+ $driver->quit(); >+}; >+ >+END { >+ cleanup() if $cleanup_needed; >+}; >+ >+sub auth { >+ my ( $driver, $login, $password) = @_; >+ fill_form( $driver, { userid => 'koha', password => 'koha' } ); >+ my $login_button = $driver->find_element('//input[@id="submit"]'); >+ $login_button->submit(); >+} >+ >+sub patron_auth { >+ my ( $driver,$patronusername, $patronpassword) = @_; >+ fill_form( $driver, { userid => $patronusername, password => $patronpassword } ); >+ my $login_button = $driver->find_element('//input[@id="submit"]'); >+ $login_button->submit(); >+} >+ >+sub patron_opac_auth { >+ my ( $driver,$patronusername, $patronpassword) = @_; >+ fill_form( $driver, { userid => $patronusername, password => $patronpassword } ); >+ my $login_button = $driver->find_element('//input[@value="Log in"]'); >+ $login_button->submit(); >+} >+ >+sub fill_form { >+ my ( $driver, $values ) = @_; >+ while ( my ( $id, $value ) = each %$values ) { >+ my $element = $driver->find_element('//*[@id="'.$id.'"]'); >+ my $tag = $element->get_tag_name(); >+ if ( $tag eq 'input' ) { >+ $driver->find_element('//input[@id="'.$id.'"]')->send_keys($value); >+ } elsif ( $tag eq 'select' ) { >+ $driver->find_element('//select[@id="'.$id.'"]/option[@value="'.$value.'"]')->click; >+ } >+ } >+} >+ >+sub cleanup { >+ my $dbh = C4::Context->dbh; >+ $dbh->do(q|DELETE FROM categories WHERE categorycode = ?|, {}, $sample_data->{category}{categorycode}); >+ $dbh->do(q|DELETE FROM borrowers WHERE userid = ?|, {}, $sample_data->{patron}{userid}); >+} >+ >+sub time_diff { >+ my $lib = shift; >+ my $now = gettimeofday; >+ warn "CP $lib = " . sprintf("%.2f", $now - $prev_time ) . "\n"; >+ $prev_time = $now; >+} >-- >2.1.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 19359
:
67342
|
67925
|
67926
|
68120
|
68121
|
68122