[Koha-bugs] [Bug 21560] Optimize ODS exports

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21560

--- Comment #11 from David Nind <david at davidnind.com> ---
An updated test plan for the second patch (Optimize ODS export of
gather_print_notices.pl)

Test plan
---------

Pre-requisites: To test the gather_print_notices.pl patch you need to setup
some overdue items to generate overdue notices. The basic steps to do this are
included in the test plan.

1) Define your ODUE notice for the print template (Tools > Patrons and
circulation > Notices & slips > edit the ODUE notice > expand the Print
section):
   cardnumber:patron:email:item
   <<borrowers.cardnumber>>:<<borrowers.firstname>>
<<borrowers.surname>>:<<borrowers.email>>:<item><<items.barcode>></item>
2) Define the overdue rules for a patron category, for example:
   . Check that 'Overdue notice required' is set to 'Yes' for the patron
category (Administration > Patrons and circulation > Patron categories)
   . Check that the 'Loan period' for the 'Standard rules all libraries' is set
to 5 days (Administration > Patrons and circulation > Circulation and fine
rules)
   . Check that a trigger is set for the patron category, for example: Delay =
1, Letter = Overdue Notice, Print = ticked (Tools > Patrons and circulation >
Overview notice/status triggers)
3) Check out 2 items for a patron in the same patron category defined in step 2
- set the due date so that it will generate the overdue notices. (Circulation >
Check out > enter patron details (card number or partial name) > enter a
barcode for an item > specifiy a due date by expanding 'Checkout settings' and
entering a date at least 5 days before the current date > Check out > confirm
check out.)
4) Run the overdue notices cronjob from the command line: perl
misc/cronjobs/overdue_notices.pl
5) Check that the 'message_queue' table in the database contains 2 new entries
(from the command line 'koha-mysql kohadev' and then enter the query 'select *
from message_queue;')
6) Run the gather_print_notices cronjob from the command line and record how
long it takes to run (use  the time command* if available to record this): time
perl misc/cronjobs/gather_print_notices.pl /tmp --ods --letter_code=ODUE -d=:
7) An ods file should be generated in the /tmp directory
8) Apply the patch
9) Run step 6 again to get the time after the patch is applied

* If using the bash shell and the time package is installed you can record how
long a script takes to run.

Result before the patch was applied:
real    0m1.702s
user    0m1.336s
sys     0m0.172s

Result after the patch was applied:
real    0m1.541s
user    0m1.404s
sys     0m0.132s

Note: got several different times, but all were quicker.

-- 
You are receiving this mail because:
You are watching all bug changes.