Attachment 117050 Details for Bug 22824 – Bug 22824: Atomic update

[patch] Bug 22824: Atomic update

Bug-22824-Atomic-update.patch (text/plain), 1.33 KB, created by Julian Maurice on 2021-02-19 10:07:40 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Julian Maurice

Created: 2021-02-19 10:07:40 UTC

Size: 1.33 KB

patch

obsolete

>From 13ab25774dc30e34a8cdb90b16c370e6bdca2bb9 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 11 Feb 2021 12:31:25 +0100
>Subject: [PATCH] Bug 22824: Atomic update
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
>---
> installer/data/mysql/atomicupdate/bug_22824.perl | 16 ++++++++++++++++
> 1 file changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_22824.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_22824.perl b/installer/data/mysql/atomicupdate/bug_22824.perl
>new file mode 100644
>index 0000000000..058204280a
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_22824.perl
>@@ -0,0 +1,16 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(q{
>+        UPDATE systempreferences SET type="Free" WHERE variable="OverDriveClientSecret" OR variable="RecordedBooksClientSecret"
>+    });
>+    $dbh->do(q{
>+        UPDATE systempreferences SET type="integer" WHERE variable="UsageStats"
>+    });
>+    $dbh->do(q{
>+        UPDATE systempreferences
>+        SET value="0"
>+        WHERE ( ( type = "YesNo" AND ( value NOT IN ( "1", "0" ) OR value IS NULL ) ) )
>+    });
>+
>+    NewVersion( $DBversion, 22824, "Update syspref values for YesNo");
>+}
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 22824: 116722 | 116723 | 116724 | 116725 | 116726 | 116727 | 116728 | 116729 | 116730 | 116731 | 116732 | 116733 | 116734 | 116735 | 116736 | 116741 | 116742 | 116743 | 116744 | 116745 | 116746 | 116747 | 116748 | 116749 | 116750 | 116751 | 116752 | 116753 | 116754 | 116755 | 116756 | 116881 | 116882 | 116883 | 116884 | 117037 | 117039 | 117040 | 117041 | 117042 | 117043 | 117044 | 117045 | 117046 | 117047 | 117048 | 117049 | 117050 | 117051 | 117052 | 117053 | 117054 | 117055 | 117056 | 117057 | 117058 | 117636 | 117637 | 117638 | 117639 | 117640 | 117641 | 117642 | 117643 | 117644 | 117645 | 117646 | 117647 | 117648 | 117649 | 117650 | 117651 | 117652 | 117653 | 117664 | 117666