Attachment 129897 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.24 KB, created by Jonathan Druart on 2022-01-27 15:14:44 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2022-01-27 15:14:44 UTC

Size: 1.24 KB

patch

obsolete

>From 15c93118a3a833e9d20765644e7bf85916a4e5c1 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
>
>Test plan:
>Run updatedatabase.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> 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 00000000000..f6f2e7db075
>--- /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.25.1

Actions: View | Diff | Splinter Review

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