From b3af0311459a37d71d63ecc47b3456c12c0008e1 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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) --- .../mysql/fr-FR/2-Optionel/sample_libraries.sql | 16 ++++++++++++++++ .../mysql/fr-FR/2-Optionel/sample_libraries.txt | 1 + 2 files changed, 17 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..234cba5498 --- /dev/null +++ b/installer/data/mysql/fr-FR/2-Optionel/sample_libraries.sql @@ -0,0 +1,16 @@ +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.20.1