From f2fff3b2ac867e6fe6fd5ec75f30c6b05874225a Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Wed, 4 Mar 2020 19:06:03 +0100
Subject: [PATCH] Bug 24851: Insert libraries sample data for "UNIMARC"

I am trying to make koha-testing-docker UNIMARC compabible.
In order to have koha-misc4dev insert all the data correctly (users, etc.) we need at least 1 library.
I am suggesting to reuse the usual library list for UNIMARC.

misc4dev will use fr-FR sample data for "UNIMARC"
This is related to https://gitlab.com/koha-community/koha-misc4dev/issues/29

Test plan:
outside your box, in koha-testing-docker (up-to-date), edit .env and set
 KOHA_MARC_FLAVOUR=unimarc
 DEBUG_GIT_REPO_MISC4DEV_URL=https://gitlab.com/joubu/koha-misc4dev.git
 DEBUG_GIT_REPO_MISC4DEV_BRANCH=unimarc

Then start the koha container
When the misc4dev will start its job, the scripts will have the expected
data to continue.

Without this patch you will get
koha_1       | Not enough data in the database, library and/or patron category does not exist at /kohadevbox/misc4dev/create_superlibrarian.pl line 31.

And plenty of errors will follow.

Also, the sample data used in misc4dev will use CPL
(/kohadevbox/misc4dev/data/sql/unimarc/1812/after_22155/items.sql)

Signed-off-by: Jon Knight <J.P.Knight@lboro.ac.uk>

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 .../data/mysql/fr-FR/2-Optionel/sample_libraries.sql      | 15 +++++++++++++++
 .../data/mysql/fr-FR/2-Optionel/sample_libraries.txt      |  1 +
 2 files changed, 16 insertions(+)
 create mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_libraries.sql
 create mode 100644 installer/data/mysql/fr-FR/2-Optionel/sample_libraries.txt

diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.sql b/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.sql
new file mode 100644
index 0000000000..58dc24e249
--- /dev/null
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.sql
@@ -0,0 +1,15 @@
+INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
+
+('MPL','Midway','372 Forest Street'),
+('SPL','Springfield','Highland Boulevard'),
+('RPL','Riverside','Johnson Terrace'),
+('CPL','Centerville','Jefferson Summit'),
+('FPL','Fairview','Hickory Squere'),
+('FFL','Fairfield','River Station'),
+('IPT','Institut Protestant de Théologie',''),
+('PVL','Pleasant Valley','Meadow Grove'),
+('TPL','Troy','Valley Way'),
+('FRL','Franklin','Smith Heights'),
+('LPL','Liberty','East Hills'),
+('UPL','Union','Chestnut Hollow')
+;
diff --git a/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.txt b/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.txt
new file mode 100644
index 0000000000..2a1bd9a5f2
--- /dev/null
+++ b/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.txt
@@ -0,0 +1 @@
+Sample libraries.
-- 
2.11.0