[Koha-bugs] [Bug 18212] Move SQL code from aqplan.pl administrative script into Koha directory perl modules

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

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

--- Comment #19 from Alex Buckley <alexbuckley at catalyst.net.nz> ---
Created attachment 66570
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=66570&action=edit
Bug 18212 - Moved all sql queries out aqplan.pl into Koha::Libraries.pm,
Koha::ItemType.pm, Koha::AuthorisedValue.pm files

The new subroutines in the perl modules contain POD

Test plan:
1. Apply all the patches attached to this bug report
2. Restart memcached: sudo service memcached restart
3. Drop and recreate the Koha instance database
4. Go through the web installer, selecting all data to be installed in
step 3
5. After the web installer is finished log in with the Koha database
administrator credentials
6. Create yourself a patron account
7. Set the patron account to have superlibrarian privileges
8. Log out and back in as your newly created patron
9. Navigate to the Acquisitions interface
10. Create a budget named 'testbudget'
11. Create a fund named 'testfund'
12. Navigate to the 'Administrator' interface
13. Write in the URL 'cgi-bin/koha/admin/aqplan.pl'
14. There should be no records showing
15. If you click on Planning->Plan by Months testfund will be displayed
16. Repeat step 14 but click on Planning->Plan by libraries and
Planning->Plan by Itemtypes, Both of these pages should also show
'testfund'
17. In your terminal navigate from your Koha instance root directory to
t/db_dependent
18. Enter koha shell: sudo koha-shell <instancename>
19. Run AuthorisedValues unit tests: prove -v AuthorisedValues.t
20. The tests should run successful
21. Exit the koha shell
22. cd into the 'koha' directory from where you are
23. Enter the koha shell and run the ItemTypes.t and Libraries.t unit
tests by writing in: prove -v filename.t (both of which should be
successful)

Sponsored-by: Catalyst IT

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