Bug 19008: More database cleanups - deleted catalog
authorFridolin Somers <fridolin.somers@biblibre.com>
Fri, 28 Jul 2017 12:05:03 +0000 (14:05 +0200)
committerLucas Gass <lucas@bywatersolutions.com>
Thu, 9 Apr 2020 20:53:07 +0000 (20:53 +0000)
commit0f0e097bc79bc6452d1161bfd7a89a01f5c012c6
tree9a29f2fabe819fbf2343054f53c47fb9af7f24a4
parent6f9c8b9e1c597d9e7599b5a9abcd9d4147924a9f
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>
(cherry picked from commit a0a579d773c95ec87a647497cc755b0a4cc7f55f)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
misc/cronjobs/cleanup_database.pl