From d924c64bd08956d20cdd1e8b75c74bd96a9b2ca5 Mon Sep 17 00:00:00 2001
From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Date: Tue, 4 Feb 2020 20:34:54 -0300
Subject: [PATCH] Bug 24583: Rewrite mandatory/sample_numberpatterns to YAML

YAML version of mandatory sample_numberpatterns

To test:
1) Same test plan of first patch, only check table
   subscription_numberpatterns
---
 .../en/mandatory/sample_numberpatterns.sql    |  25 ----
 .../en/mandatory/sample_numberpatterns.txt    |   1 -
 .../en/mandatory/sample_numberpatterns.yml    | 119 ++++++++++++++++++
 3 files changed, 119 insertions(+), 26 deletions(-)
 delete mode 100644 installer/data/mysql/en/mandatory/sample_numberpatterns.sql
 delete mode 100644 installer/data/mysql/en/mandatory/sample_numberpatterns.txt
 create mode 100644 installer/data/mysql/en/mandatory/sample_numberpatterns.yml

diff --git a/installer/data/mysql/en/mandatory/sample_numberpatterns.sql b/installer/data/mysql/en/mandatory/sample_numberpatterns.sql
deleted file mode 100644
index 794385e63d..0000000000
--- a/installer/data/mysql/en/mandatory/sample_numberpatterns.sql
+++ /dev/null
@@ -1,25 +0,0 @@
-INSERT INTO subscription_numberpatterns
-    (label, displayorder, description, numberingmethod,
-    label1, add1, every1, whenmorethan1, setto1, numbering1,
-    label2, add2, every2, whenmorethan2, setto2, numbering2,
-    label3, add3, every3, whenmorethan3, setto3, numbering3)
-VALUES
-    ('Number', 1, 'Simple Numbering method', 'No. {X}',
-    'Number', 1, 1, 99999, 1, NULL,
-    NULL, NULL, NULL, NULL, NULL, NULL,
-    NULL, NULL, NULL, NULL, NULL, NULL),
-
-    ('Volume, Number, Issue', 2, 'Volume Number Issue 1', 'Vol. {X}, Number {Y}, Issue {Z}',
-    'Volume', 1, 48, 99999, 1, NULL,
-    'Number', 1, 4, 12, 1, NULL,
-    'Issue', 1, 1, 4, 1, NULL),
-
-    ('Volume, Number', 3, 'Volume Number 1', 'Vol. {X}, No. {Y}',
-    'Volume', 1, 12, 99999, 1, NULL,
-    'Number', 1, 1, 12, 1, NULL,
-    NULL, NULL, NULL, NULL, NULL, NULL),
-
-    ('Seasonal', 4, 'Season Year', '{X} {Y}',
-    'Season', 1, 1, 3, 0, 'season',
-    'Year', 1, 4, 99999, 1, NULL,
-    NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/installer/data/mysql/en/mandatory/sample_numberpatterns.txt b/installer/data/mysql/en/mandatory/sample_numberpatterns.txt
deleted file mode 100644
index 853db0fd92..0000000000
--- a/installer/data/mysql/en/mandatory/sample_numberpatterns.txt
+++ /dev/null
@@ -1 +0,0 @@
-Sample numbering patterns for subscriptions
diff --git a/installer/data/mysql/en/mandatory/sample_numberpatterns.yml b/installer/data/mysql/en/mandatory/sample_numberpatterns.yml
new file mode 100644
index 0000000000..b898b8264e
--- /dev/null
+++ b/installer/data/mysql/en/mandatory/sample_numberpatterns.yml
@@ -0,0 +1,119 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+#  Koha is free software; you can redistribute it and/or modify it under the
+#  terms of the GNU General Public License as published by the Free Software
+#  Foundation; either version 2 of the License, or (at your option) any later
+#  version.
+#
+#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
+#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
+#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
+#
+#  You should have received a copy of the GNU General Public License along
+#  with Koha; if not, write to the Free Software Foundation, Inc.,
+#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+#
+
+description:
+  - "Sample numbering patterns for subscriptions"
+
+tables:
+  - subscription_numberpatterns:
+      translatable: [ label, description, numberingmethod, label1, label2, label3 ]
+      multiline: []
+      rows:
+        - label: "Number"
+          displayorder: 1
+          description: "Simple Numbering method"
+          numberingmethod: "No. {X}"
+          label1: "Number"
+          add1: 1
+          every1: 1
+          whenmorethan1: 99999
+          setto1: 1
+          numbering1: ~
+          label2: ""
+          add2: ~
+          every2: ~
+          whenmorethan2: ~
+          setto2: ~
+          numbering2: ~
+          label3: ""
+          add3: ~
+          every3: ~
+          whenmorethan3: ~
+          setto3: ~
+          numbering3: ~
+
+        - label: "Volume, Number, Issue"
+          displayorder: 2
+          description: "Volume Number Issue 1"
+          numberingmethod: "Vol. {X}, Number {Y}, Issue {Z}"
+          label1: "Volume"
+          add1: 1
+          every1: 48
+          whenmorethan1: 99999
+          setto1: 1
+          numbering1: ~
+          label2: "Number"
+          add2: 1
+          every2: 4
+          whenmorethan2: 12
+          setto2: 1
+          numbering2: ~
+          label3: "Issue"
+          add3: 1
+          every3: 1
+          whenmorethan3: 4
+          setto3: 1
+          numbering3: ~
+
+        - label: "Volume, Number"
+          displayorder: 3
+          description: "Volume Number 1"
+          numberingmethod: "Vol. {X}, No. {Y}"
+          label1: "Volume"
+          add1: 1
+          every1: 12
+          whenmorethan1: 99999
+          setto1: 1
+          numbering1: ~
+          label2: "Number"
+          add2: 1
+          every2: 1
+          whenmorethan2: 12
+          setto2: 1
+          numbering2: ~
+          label3: ""
+          add3: ~
+          every3: ~
+          whenmorethan3: ~
+          setto3: ~
+          numbering3: ~
+
+        - label: "Seasonal"
+          displayorder: 4
+          description: "Season Year"
+          numberingmethod: "{X} {Y}"
+          label1: "Season"
+          add1: 1
+          every1: 1
+          whenmorethan1: 3
+          setto1: 0
+          numbering1: season
+          label2: "Year"
+          add2: 1
+          every2: 4
+          whenmorethan2: 99999
+          setto2: 1
+          numbering2: ~
+          label3: ""
+          add3: ~
+          every3: ~
+          whenmorethan3: ~
+          setto3: ~
+          numbering3: ~
-- 
2.17.1