From 0dde1ead0ac55bbd7576665cde29a8c40d62f411 Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Tue, 7 Feb 2017 15:11:59 -0800 Subject: [PATCH] LP#1541559: ebook API sample MARC records for test module This commit adds a small number of MARC records to the existing sample data. Each record contains a scoped URI in the 856 field. The records are intended to be usable with the OpenILS::Application::EbookAPI::Test module. Signed-off-by: Jeff Davis Signed-off-by: Kathy Lussier --- Open-ILS/tests/datasets/sql/bibs_ebook_api.sql | 8 ++++++++ Open-ILS/tests/datasets/sql/load_all.sql | 3 +++ 2 files changed, 11 insertions(+) create mode 100644 Open-ILS/tests/datasets/sql/bibs_ebook_api.sql diff --git a/Open-ILS/tests/datasets/sql/bibs_ebook_api.sql b/Open-ILS/tests/datasets/sql/bibs_ebook_api.sql new file mode 100644 index 0000000000..1a47fe6057 --- /dev/null +++ b/Open-ILS/tests/datasets/sql/bibs_ebook_api.sql @@ -0,0 +1,8 @@ +\set bib_tag '''IMPORT EBOOK_API''' + +INSERT INTO marcxml_import (tag, marc) VALUES +(:bib_tag,'00620nam a22 i 450020161210000052.0070101s o eng dSITKAengrdaSITKATolkien, J. R. R.(John Ronald Reuel),1892-1973,author.The fellowship of the ring /by J.R.R. Tolkien.2nd ed.textrdacontentcomputerrdamediaonline resourcerdacarrierThe Lord of the rings / J.R.R. Tolkien ;pt. 1Tolkien, J. R. R.(John Ronald Reuel),1892-1973.Lord of the ringshttp://example.com/ebookapi/t/001Click to access onlineCONS'), +(:bib_tag,'00620nam a22 i 450020161210000052.0070101s o eng dSITKAengrdaSITKATolkien, J. R. R.(John Ronald Reuel),1892-1973,author.The two towers /by J.R.R. Tolkien.2nd ed.textrdacontentcomputerrdamediaonline resourcerdacarrierThe Lord of the rings / J.R.R. Tolkien ;pt. 2Tolkien, J. R. R.(John Ronald Reuel),1892-1973.Lord of the ringshttp://example.com/ebookapi/t/002Click to access onlineCONS'), +(:bib_tag,'00620nam a22 i 450020161210000052.0070101s o eng dSITKAengrdaSITKATolkien, J. R. R.(John Ronald Reuel),1892-1973,author.The return of the king /by J.R.R. Tolkien.2nd ed.textrdacontentcomputerrdamediaonline resourcerdacarrierThe Lord of the rings / J.R.R. Tolkien ;pt. 3Tolkien, J. R. R.(John Ronald Reuel),1892-1973.Lord of the ringshttp://example.com/ebookapi/t/003Click to access onlineCONS'), +(:bib_tag,'00620nam a22 i 450020161210000052.0070101s o eng dSITKAengrdaSITKATolkien, J. R. R.(John Ronald Reuel),1892-1973,author.The hobbit, or, There and back again /by J.R.R. Tolkien.New ed.textrdacontentcomputerrdamediaonline resourcerdacarrierhttp://example.com/ebookapi/t/004Click to access onlineCONS') +; diff --git a/Open-ILS/tests/datasets/sql/load_all.sql b/Open-ILS/tests/datasets/sql/load_all.sql index 1d4914ed52..54d4e55125 100644 --- a/Open-ILS/tests/datasets/sql/load_all.sql +++ b/Open-ILS/tests/datasets/sql/load_all.sql @@ -30,6 +30,9 @@ 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; -- 2.43.2