Bug 19008: More database cleanups - deleted catalog
authorFridolin Somers <fridolin.somers@biblibre.com>
Fri, 28 Jul 2017 12:05:03 +0000 (14:05 +0200)
committerJoy Nelson <joy@bywatersolutions.com>
Thu, 2 Apr 2020 18:45:05 +0000 (18:45 +0000)
commita0a579d773c95ec87a647497cc755b0a4cc7f55f
treeb2c05b1ea47132190773e4c5c92e98bed5cf4bfa
parent20118bb795ce046c2b00152aeccb94ae998375e6
Bug 19008: More database cleanups - deleted catalog

misc/cronjobs/cleanup_database.pl provides some database cleanup.
Yet some tables that could need cleanup are not in this script.

This patch adds cleanup for deleted catalog tables.
Note that deletedbiblio_metadata is managed by foreign key on biblionumber.

Test plan :
- Count :
select count(*),year(timestamp) from deleteditems group by year(timestamp);
select count(*),year(timestamp) from deletedbiblio group by year(timestamp);
select count(*),year(timestamp) from deletedbiblioitems group by year(timestamp);
- Run cleanup : misc/cronjobs/cleanup_database.pl -v --deleted-catalog 30
- Recount

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
misc/cronjobs/cleanup_database.pl