[Koha-bugs] [Bug 16672] Add ability to remove expired holidays from special_holidays

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

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

Florent Mara <florent.mara at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |florent.mara at gmail.com
             Status|Needs Signoff               |Signed Off

--- Comment #2 from Florent Mara <florent.mara at gmail.com> ---
Inserted 3 entries using the following on June 7th 2016:
INSERT INTO special_holidays(branchcode, day, month, year, isexception,
description) VALUES
('FFL', 1, 6, 2016, 1, 'description1'), 
('FFL', 2, 6, 2016, 1, 'description2'), 
('FFL', 3, 6, 2016, 1, 'description3');

Ran cleanup_database using the new switch:
# perl misc/cronjobs/cleanup_database.pl --unique-holidays 5

Only 2 entries were remaining in table `special_holidays`.

Then ran the same switch with the verbose flag
# perl misc/cronjobs/cleanup_database.pl --unique-holidays 4 --verbose
Removed 1 unqiue holidays

One entry was left in table `special_holidays`.
This patch works as expected.

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