From e65782fd72948d3b6594ed77a53ae43a1f6109ae Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sat, 11 Apr 2020 17:52:30 +0000 Subject: [PATCH] Bug 24378: Database update to rewrite notice if left unchanged The database update makes the same changes as done by Andrew on the old database entry. We check for full sentences left unchanged to minimize issues with changes made by the library. Test plan of first patch applies. Signed-off-by: Andrew Fuerste-Henry --- .../atomicupdate/bug_24378_auto_renewals.perl | 35 ++++++++++++++++++++++ 1 file changed, 35 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl diff --git a/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl b/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl new file mode 100644 index 0000000000..a9580353d8 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_24378_auto_renewals.perl @@ -0,0 +1,35 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # you can use $dbh here like: + # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" ); + + $dbh->do(q{ + UPDATE letter SET + name = REPLACE(name, "notification on auto renewing", "Notification of automatic renewal"), + title = REPLACE(title, "Auto renewals", "Automatic renewal notice"), + content = REPLACE(content, "You have reach the maximum of checkouts possible.", "You have reached the maximum number of checkouts possible.") + WHERE code = 'AUTO_RENEWALS'; + }); + $dbh->do(q{ + UPDATE letter SET + content = REPLACE(content, "You have overdues.", "You have overdue items.") + WHERE code = 'AUTO_RENEWALS'; + }); + $dbh->do(q{ + UPDATE letter SET + content = REPLACE(content, "It\'s too late to renew this checkout.", "It\'s too late to renew this item.") + WHERE code = 'AUTO_RENEWALS'; + }); + $dbh->do(q{ + UPDATE letter SET + content = REPLACE(content, "You have too much unpaid fines.", "Your total unpaid fines are too high.") + WHERE code = 'AUTO_RENEWALS'; + }); + $dbh->do(q{ + UPDATE letter SET + content = REPLACE(content, "The following item [% biblio.title %] has correctly been renewed and is now due [% checkout.date_due %]", "The following item, [% biblio.title %], has correctly been renewed and is now due on [% checkout.date_due %] +") + WHERE code = 'AUTO_RENEWALS'; + }); + NewVersion( $DBversion, 24378, "Fix some grammatical errors in default auto renewal notice"); +} -- 2.11.0