[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