From 6f9ba03d5dab0a7d2fd341eb30040bbf75a5a2d0 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 --- 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