From ad31c13ed08d4f5e93925deb3139101b0eeb3e92 Mon Sep 17 00:00:00 2001
From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Date: Wed, 5 Feb 2020 09:53:12 -0300
Subject: [PATCH] Bug 24584: Rewrite optional/sample_z3950_servers to YAML

YAML version of optional sample_z3950_servers

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

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 .../en/optional/sample_z3950_servers.sql      | 11 ---
 .../en/optional/sample_z3950_servers.txt      |  5 --
 .../en/optional/sample_z3950_servers.yml      | 82 +++++++++++++++++++
 3 files changed, 82 insertions(+), 16 deletions(-)
 delete mode 100644 installer/data/mysql/en/optional/sample_z3950_servers.sql
 delete mode 100644 installer/data/mysql/en/optional/sample_z3950_servers.txt
 create mode 100644 installer/data/mysql/en/optional/sample_z3950_servers.yml

diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.sql b/installer/data/mysql/en/optional/sample_z3950_servers.sql
deleted file mode 100644
index 1168fe12b9..0000000000
--- a/installer/data/mysql/en/optional/sample_z3950_servers.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-INSERT INTO z3950servers
-(host, port, db, userid, password, servername, checked, `rank`, syntax, encoding,recordtype) VALUES
-('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
-('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
-('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
-
-#Insert SRU server
-INSERT INTO z3950servers
-(host, port, db, servername, syntax, encoding, servertype, sru_fields)
-VALUES
-('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier');
diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.txt b/installer/data/mysql/en/optional/sample_z3950_servers.txt
deleted file mode 100644
index b7a48c0f0b..0000000000
--- a/installer/data/mysql/en/optional/sample_z3950_servers.txt
+++ /dev/null
@@ -1,5 +0,0 @@
-Allow access to the following servers to search and download record information:
-LIBRARY OF CONGRESS
-LIBRARY OF CONGRESS NAMES (authority records)
-LIBRARY OF CONGRESS SUBJECTS (authority records)
-COLUMBIA UNIVERSITY
diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.yml b/installer/data/mysql/en/optional/sample_z3950_servers.yml
new file mode 100644
index 0000000000..7cd1f6f915
--- /dev/null
+++ b/installer/data/mysql/en/optional/sample_z3950_servers.yml
@@ -0,0 +1,82 @@
+---
+#
+#  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:
+  - "Allow access to the following servers to search and download record information:"
+  - "LIBRARY OF CONGRESS"
+  - "LIBRARY OF CONGRESS NAMES (authority records)"
+  - "LIBRARY OF CONGRESS SUBJECTS (authority records)"
+  - "COLUMBIA UNIVERSITY"
+
+
+tables:
+  - z3950servers:
+      translatable: [ servername ]
+      multiline: []
+      rows:
+        - host: "lx2.loc.gov"
+          port: 210
+          db: LCDB
+          userid: ""
+          password: ""
+          servername: "LIBRARY OF CONGRESS"
+          checked: 1
+          rank: 1
+          syntax: USMARC
+          encoding: utf8
+          recordtype: biblio
+
+        - host: "lx2.loc.gov"
+          port: 210
+          db: NAF
+          userid: ""
+          password: ""
+          servername: "LIBRARY OF CONGRESS NAMES"
+          checked: 1
+          rank: 1
+          syntax: USMARC
+          encoding: utf8
+          recordtype: authority
+
+        - host: "lx2.loc.gov"
+          port: 210
+          db: SAF
+          userid: ""
+          password: ""
+          servername: "LIBRARY OF CONGRESS SUBJECTS"
+          checked: 1
+          rank: 2
+          syntax: USMARC
+          encoding: utf8
+          recordtype: authority
+
+  - z3950servers:
+      translatable: [ servername ]
+      multiline: []
+      rows:
+        # Insert SRU server
+        - host: "lx2.loc.gov"
+          port: 210
+          db: LCDB
+          servername: "LIBRARY OF CONGRESS SRU"
+          syntax: USMARC
+          encoding: utf8
+          servertype: sru
+          sru_fields: "title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier"
-- 
2.20.1