Bug 17350: Purge old saved reports via cleanup_database
authorAndrew Fuerste-Henry <andrewfh@dubcolib.org>
Mon, 21 Nov 2022 20:00:57 +0000 (20:00 +0000)
committerTomas Cohen Arazi <tomascohen@theke.io>
Mon, 27 Feb 2023 16:08:05 +0000 (13:08 -0300)
commitfe6a03c43a61100f5df1b273ff671eee4326809c
tree9a4425594359bd81465fede656f6a17c73d389b1
parentbcc1c6c3fd19fe25d00b0fae4862a6b90b215ca5
Bug 17350: Purge old saved reports via cleanup_database

To test:
apply patch
1 - have or create a report
2 - run your report via the command line with --store-results. Do this twice.
3 - update the saved_reports table to set date_run for one of your two saved results set to a datetime more than 5 days ago
4 - perl misc/cronjobs/cleanup_database.pl --reports 5 --verbose --confirm
5 - Koha tells you its deleting saved reports data from more than 5 days ago
6 - confirm in the database and the staff interface that it's done so

Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
Signed-off-by: Victor Grousset/tuxayo <victor@tuxayo.net>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
misc/cronjobs/cleanup_database.pl