[Koha-bugs] [Bug 13409] Add ability to purge old special holidays using cleanup_database.pl
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Sun May 24 16:09:11 CEST 2015
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13409
--- Comment #3 from Jonathan Druart <jonathan.druart at biblibre.com> ---
Comment on attachment 34177
--> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=34177
Bug 13409 - Add ability to purge old special holidays using cleanup_database.pl
Review of attachment 34177:
--> (http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=13409&attachment=34177)
-----------------------------------------------------------------
::: misc/cronjobs/cleanup_database.pl
@@ +340,5 @@
> +sub PurgeHolidays {
> + $sth = $dbh->prepare(
> + q{
> + DELETE FROM special_holidays
> + WHERE DATE( CONCAT( year, '-', month, '-', day ) ) < DATE_SUB( CURDATE(), INTERVAL ? DAY )
It would be good to have a DB agnostic way to day that.
For instance "DATE_SUB( CURDATE(), INTERVAL ? DAY )" could be done in Perl,
don't you think?
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list