Attachment 118345 Details for Bug 15563 – Bug 15563: add label and card creator batch deletion to cleanup_database

[patch] Bug 15563: add label and card creator batch deletion to cleanup_database

Bug-15563-add-label-and-card-creator-batch-deletio.patch (text/plain), 5.50 KB, created by Andrew Fuerste-Henry on 2021-03-16 19:15:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Andrew Fuerste-Henry

Created: 2021-03-16 19:15:58 UTC

Size: 5.50 KB

patch

obsolete

>From 154757204a139f3837016dfbc84dd836e8604faa Mon Sep 17 00:00:00 2001
>From: Andrew Fuerste-Henry <andrew@bywatersolutions.com>
>Date: Mon, 20 Jul 2020 15:09:30 +0000
>Subject: [PATCH] Bug 15563: add label and card creator batch deletion to
> cleanup_database
>
>To test:
>For item label batches:
>1- Create 3 item label batches of at least 2 items each
>2- Perform the following updates via the database
>3- In Batch 1, set all items' timestamps to 10+ days prior to today
>4- In Batch 2, set 1 item's timestamp to 10+ days prior to today
>5- In Batch 3, do not update any timestamps
>6- Run cron with --labels 9
>7- Confirm batch 1 is deleted, batches 2 and 3 are not
>
>Repeat with card creator batches
>8- Create 3 card creator batches of at least 2 items each
>9- Perform the following updates via the database
>10- In Batch 1, set all cards' timestamps to 10+ days prior to today
>11- In Batch 2, set 1 card's timestamp to 10+ days prior to today
>12- In Batch 3, do not update any timestamps
>13- Run cron with --cards 9
>14- Confirm batch 1 is deleted, batches 2 and 3 are noti
>
>Signed-off-by: Abbey Holt <aholt@dubuque.lib.ia.us>
>---
> misc/cronjobs/cleanup_database.pl | 46 ++++++++++++++++++++++++++++++++++++++-
> 1 file changed, 45 insertions(+), 1 deletion(-)
>
>diff --git a/misc/cronjobs/cleanup_database.pl b/misc/cronjobs/cleanup_database.pl
>index 062efe6041..1340d152fd 100755
>--- a/misc/cronjobs/cleanup_database.pl
>+++ b/misc/cronjobs/cleanup_database.pl
>@@ -55,7 +55,7 @@ use Koha::Patron::Messages;
> 
> sub usage {
>     print STDERR <<USAGE;
>-Usage: $0 [-h|--help] [--confirm] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] [--restrictions DAYS] [--all-restrictions] [--fees DAYS] [--temp-uploads] [--temp-uploads-days DAYS] [--uploads-missing 0|1 ] [--statistics DAYS] [--deleted-catalog DAYS] [--deleted-patrons DAYS] [--old-issues DAYS] [--old-reserves DAYS] [--transfers DAYS]
>+Usage: $0 [-h|--help] [--confirm] [--sessions] [--sessdays DAYS] [-v|--verbose] [--zebraqueue DAYS] [-m|--mail] [--merged] [--import DAYS] [--logs DAYS] [--searchhistory DAYS] [--restrictions DAYS] [--all-restrictions] [--fees DAYS] [--temp-uploads] [--temp-uploads-days DAYS] [--uploads-missing 0|1 ] [--statistics DAYS] [--deleted-catalog DAYS] [--deleted-patrons DAYS] [--old-issues DAYS] [--old-reserves DAYS] [--transfers DAYS] [--labels DAYS] [--cards DAYS]
> 
>    -h --help          prints this help message, and exits, ignoring all
>                       other options
>@@ -107,6 +107,9 @@ Usage: $0 [-h|--help] [--confirm] [--sessions] [--sessdays DAYS] [-v|--verbose]
>    --pseudo-transactions DAYS   Purge the pseudonymized transactions that have been originally created more than DAYS days ago
>                                 DAYS is optional and can be replaced by:
>                                     --pseudo-transactions-from YYYY-MM-DD and/or --pseudo-transactions-to YYYY-MM-DD
>+   --labels DAYS           Purge item label batches last added to more than DAYS days ago.
>+   --cards DAY             Purge card creator batches last added to more than DAYS days ago.
>+
> USAGE
>     exit $_[0];
> }
>@@ -142,6 +145,8 @@ my $pOldReserves;
> my $pTransfers;
> my ( $pPseudoTransactions, $pPseudoTransactionsFrom, $pPseudoTransactionsTo );
> my $pMessages;
>+my $labels;
>+my $cards;
> 
> GetOptions(
>     'h|help'            => \$help,
>@@ -177,6 +182,8 @@ GetOptions(
>     'pseudo-transactions:i'      => \$pPseudoTransactions,
>     'pseudo-transactions-from:s' => \$pPseudoTransactionsFrom,
>     'pseudo-transactions-to:s'   => \$pPseudoTransactionsTo,
>+    'labels'            => \$labels,
>+    'cards'             => \$cards,
> ) || usage(1);
> 
> # Use default values
>@@ -222,6 +229,8 @@ unless ( $sessions
>     || $pPseudoTransactionsFrom
>     || $pPseudoTransactionsTo
>     || $pMessages
>+    || $labels
>+    || $cards
> ) {
>     print "You did not specify any cleanup work for the script to do.\n\n";
>     usage(1);
>@@ -598,6 +607,41 @@ if (defined $pPseudoTransactions or $pPseudoTransactionsFrom or $pPseudoTransact
>           ? sprintf "Done with purging %d pseudonymized transactions.", $count
>           : sprintf "%d pseudonymized transactions would have been purged.", $count;
>     }
>+
>+if ($labels) {
>+    print "Purging item label batches last added to more than $labels days ago.\n" if $verbose;
>+    $sth = $dbh->prepare(
>+        q{
>+        DELETE from creator_batches
>+        WHERE batch_id in
>+            (SELECT batch_id
>+            FROM (SELECT batch_id
>+                    FROM creator_batches
>+                    WHERE creator='labels'
>+                    GROUP BY batch_id
>+                    HAVING max(timestamp) < date_sub(curdate(),interval ? day)) a)
>+        }
>+    );
>+    $sth->execute($labels) or die $dbh->errstr;
>+    print "Done with purging item label batches last added to more than $labels days ago.\n" if $verbose;
>+}
>+
>+if ($cards) {
>+    print "Purging card creator batches last added to more than $cards days ago.\n" if $verbose;
>+    $sth = $dbh->prepare(
>+        q{
>+        DELETE from creator_batches
>+        WHERE batch_id in
>+            (SELECT batch_id
>+            FROM (SELECT batch_id
>+                    FROM creator_batches
>+                    WHERE creator='patroncards'
>+                    GROUP BY batch_id
>+                    HAVING max(timestamp) < date_sub(curdate(),interval ? day)) a);
>+        }
>+    );
>+    $sth->execute($cards) or die $dbh->errstr;
>+    print "Done with purging card creator batches last added to more than $cards days ago.\n" if $verbose;
> }
> 
> exit(0);
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 15563: 102934 | 102948 | 103003 | 103004 | 103011 | 103012 | 103492 | 103493 | 107115 | 107639 | 118076 | 118078 | 118081 | 118082 | 118345 | 118762 | 118763 | 118764 | 120082 | 120221