Attachment 129769 Details for Bug 29943 – Bug 29943: Db rev: replace typo in existing notices

[patch] Bug 29943: Db rev: replace typo in existing notices

Bug-29943-Db-rev-replace-typo-in-existing-notices.patch (text/plain), 1.20 KB, created by Marcel de Rooy on 2022-01-25 15:36:58 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2022-01-25 15:36:58 UTC

Size: 1.20 KB

patch

obsolete

>From 6530ade093d53530ec5784bc7b19a6fff7286b1f Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Tue, 25 Jan 2022 15:35:05 +0000
>Subject: [PATCH] Bug 29943: Db rev: replace typo in existing notices
>Content-Type: text/plain; charset=utf-8
>
>Test plan:
>Run updatedatabase.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>---
> 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.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 29943: 129768 | 129769 | 129896 | 129897