From 1a9b8120518584740dd6236ed04d6f0758b5fd36 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 20 Feb 2017 22:34:54 -0500 Subject: [PATCH] LP#1541559: Change order of test bib loading Move the new ebook bibs to the end of the script and away from the rest of bib loading and item creation to avoid breaking tests. Signed-off-by: Ben Shum Signed-off-by: Kathy Lussier --- Open-ILS/tests/datasets/sql/load_all.sql | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index 54d4e55125..50ea078d50 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -30,9 +30,6 @@ BEGIN; -- load RDA bibs \i bibs_rda.sql --- load EbookAPI bibs -\i bibs_ebook_api.sql - -- insert all loaded bibs into the biblio.record_entry in insert order INSERT INTO biblio.record_entry (marc, last_xact_id) SELECT marc, tag FROM marcxml_import ORDER BY id; @@ -68,6 +65,16 @@ INSERT INTO biblio.record_entry (marc, last_xact_id) -- funds, orders, etc. \i acq.sql +-- delete previously imported bibs +DELETE FROM marcxml_import; + +-- load EbookAPI bibs +\i bibs_ebook_api.sql + +-- insert all loaded bibs into the biblio.record_entry in insert order +INSERT INTO biblio.record_entry (marc, last_xact_id) + SELECT marc, tag FROM marcxml_import ORDER BY id; + -- clean up the env \i env_destroy.sql -- 2.11.0