Attachment 116682 Details for Bug 8179 – Bug 8179: Add syspref to database

[patch] Bug 8179: Add syspref to database

Bug-8179-Add-syspref-to-database.patch (text/plain), 2.72 KB, created by Agustín Moyano on 2021-02-10 16:01:11 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Agustín Moyano

Created: 2021-02-10 16:01:11 UTC

Size: 2.72 KB

patch

obsolete

>From 7b0300e0ddc0d198fff4f873b85983df3a97a5d9 Mon Sep 17 00:00:00 2001
>From: Agustin Moyano <agustinmoyano@theke.io>
>Date: Fri, 9 Oct 2020 13:38:45 -0300
>Subject: [PATCH] Bug 8179: Add syspref to database
>
>This patch adds the AcqReceiveMultipleOrderLines syspref by atomicupdate
>and in sysprefs.sql
>
>Sponsored-by: Virginia Polytechnic Institute and State University
>---
> installer/data/mysql/atomicupdate/bug_8179.perl | 15 +++++++++++++++
> installer/data/mysql/mandatory/sysprefs.sql     |  1 +
> 2 files changed, 16 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_8179.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_8179.perl b/installer/data/mysql/atomicupdate/bug_8179.perl
>new file mode 100644
>index 0000000000..efd5000e10
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_8179.perl
>@@ -0,0 +1,15 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    # you can use $dbh here like:
>+    $dbh->do( qq{
>+        INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
>+        ('AcqReceiveMultipleOrderLines', '0', NULL, 'Process multiple order lines at once', 'YesNo')
>+    });
>+    # or perform some test and warn
>+    # if( !column_exists( 'biblio', 'biblionumber' ) ) {
>+    #    warn "There is something wrong";
>+    # }
>+
>+    # Always end with this (adjust the bug info)
>+    NewVersion( $DBversion, 8179, "Add AcqReceiveMultipleOrderLines system preference");
>+}
>diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql
>index eab5e66838..ecdb4f7d1f 100644
>--- a/installer/data/mysql/mandatory/sysprefs.sql
>+++ b/installer/data/mysql/mandatory/sysprefs.sql
>@@ -5,6 +5,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `
> ('AcqEnableFiles','0',NULL,'If enabled, allows librarians to upload and attach arbitrary files to invoice records.','YesNo'),
> ('AcqItemSetSubfieldsWhenReceiptIsCancelled','', '','Upon cancelling a receipt, update the items subfields if they were created when placing an order (e.g. o=5|a="bar foo")', 'Free'),
> ('AcqItemSetSubfieldsWhenReceived','','','Upon receiving items, update their subfields if they were created when placing an order (e.g. o=5|a="foo bar")','Free'),
>+('AcqReceiveMultipleOrderLines', '0', NULL, 'Process multiple order lines at once', 'YesNo'),
> ('AcquisitionDetails', '1', '', 'Hide/Show acquisition details on the biblio detail page.', 'YesNo'),
> ('AcqViewBaskets','user','user|branch|all','Define which baskets a user is allowed to view: their own only, any within their branch, or all','Choice'),
> ('AcqWarnOnDuplicateInvoice','0','','Warn librarians when they try to create a duplicate invoice','YesNo'),
>-- 
>2.25.0

Actions: View | Diff | Splinter Review

Attachments on bug 8179: 9881 | 111437 | 111438 | 111439 | 111440 | 112554 | 112555 | 112556 | 112558 | 112588 | 112643 | 112644 | 112645 | 112646 | 112744 | 112745 | 112746 | 112747 | 114688 | 114689 | 114690 | 114691 | 116582 | 116583 | 116584 | 116585 | 116588 | 116589 | 116590 | 116591 | 116681 | 116682 | 116683 | 116684 | 116942 | 116943 | 116944 | 116945 | 119178 | 119179 | 119180 | 119181 | 120620 | 120621 | 120622 | 120623 | 148215 | 148216 | 148217 | 148218 | 148233 | 148284 | 148285 | 148286 | 148287 | 148288 | 148521 | 148522 | 148523 | 148524 | 148525 | 148526 | 148685 | 148981 | 148982 | 148983 | 148984 | 148985 | 148986 | 151026 | 151086 | 151087 | 151088 | 151089 | 151092 | 151093 | 151137 | 151138 | 151139 | 151140 | 151141 | 151142 | 151143 | 151144 | 151145 | 151163 | 151250 | 151367 | 151431