Bug 24584: Rewrite optional/parameters to YAML

YAML version of optional parameters

To test:
1) Same test plan of first patch, only check table
   currency

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

diff --git a/installer/data/mysql/en/optional/parameters.sql b/installer/data/mysql/en/optional/parameters.sql
deleted file mode 100644 (file)
index 16e8642..0000000
--- a/installer/data/mysql/en/optional/parameters.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-INSERT INTO `currency` (currency, rate, symbol, active) VALUES
-('USD', 1.0, '$', '1'),
-('GBP', 1.9929, '£', '0'),
-('CAD', 1.02207, '$', '0'),
-('EUR', .874003, '€', '0');

diff --git a/installer/data/mysql/en/optional/parameters.txt b/installer/data/mysql/en/optional/parameters.txt
deleted file mode 100644 (file)
index a778b1f..0000000
--- a/installer/data/mysql/en/optional/parameters.txt
+++ /dev/null
@@ -1 +0,0 @@
-Some basic currencies with USA dollar as default for ACQ module

diff --git a/installer/data/mysql/en/optional/parameters.yml b/installer/data/mysql/en/optional/parameters.yml
new file mode 100644 (file)
index 0000000..3df3214
--- /dev/null
+++ b/installer/data/mysql/en/optional/parameters.yml
@@ -0,0 +1,47 @@
+---
+#
+#  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:
+  - "Some basic currencies with USA dollar as default for ACQ module"
+
+tables:
+  - currency:
+      translatable: [ ]
+      multiline: []
+      rows:
+        - currency: "USD"
+          rate: 1.0
+          symbol: "$"
+          active: 1
+
+        - currency: "GBP"
+          rate: 1.9929
+          symbol: "£"
+          active: 0
+
+        - currency: "CAD"
+          rate: 1.02207
+          symbol: "$"
+          active: 0
+
+        - currency: "EUR"
+          rate: .874003
+          symbol: "€"
+          active: 0