From b5a8b8925854be3efe3135d2ca94f1ced42edd79 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Tue, 25 Jan 2022 15:35:05 +0000 Subject: [PATCH] Bug 29943: Db rev: replace typo in existing notices Test plan: Run updatedatabase. Signed-off-by: Marcel de Rooy Signed-off-by: Jonathan Druart Signed-off-by: Fridolin Somers Signed-off-by: Kyle M Hall --- installer/data/mysql/atomicupdate/bug_29943.pl | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_29943.pl diff --git a/installer/data/mysql/atomicupdate/bug_29943.pl b/installer/data/mysql/atomicupdate/bug_29943.pl new file mode 100755 index 0000000000..f6f2e7db07 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_29943.pl @@ -0,0 +1,16 @@ +use Modern::Perl; + +return { + bug_number => 29943, + description => "Fix typo in NOTIFY_MANAGER notice", + up => sub { + my ($args) = @_; + my ($dbh, $out) = @$args{qw(dbh out)}; + + # Correct "[% borrowers." (where present and restricted to specific notice) + $dbh->do(q| +UPDATE letter SET content = REPLACE(content, '[% borrowers.', '[% borrower.') +WHERE code = 'NOTIFY_MANAGER' + |); + }, +}; -- 2.39.5