From acb1c944e8dbc4882f2f5d42538ed5928765feb2 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 5 Nov 2015 13:56:15 -0500 Subject: [PATCH] LP#1486294 ACQ sapmle holding subfield maps Collection of holding subfield map configurations for ACQ seed data providers. Maps for all providers are the same. Signed-off-by: Bill Erickson Signed-off-by: Kathy Lussier --- Open-ILS/tests/datasets/sql/acq.sql | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) diff --git a/Open-ILS/tests/datasets/sql/acq.sql b/Open-ILS/tests/datasets/sql/acq.sql index 794eb710a2..f20a2082f1 100644 --- a/Open-ILS/tests/datasets/sql/acq.sql +++ b/Open-ILS/tests/datasets/sql/acq.sql @@ -46,6 +46,34 @@ INSERT INTO acq.provider SELECT SETVAL('acq.provider_id_seq'::TEXT, 4); +INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield) VALUES + (1, 'quantity', 'q'), + (1, 'estimated_price', 'p'), + (1, 'owning_lib', 'o'), + (1, 'call_number', 'n'), + (1, 'fund_code', 'f'), + (1, 'circ_modifier', 'm'), + (1, 'note', 'z'), + (1, 'copy_location', 'l'), + (1, 'barcode', 'b'), + (1, 'collection_code', 'c'); + +-- give every provider the same holding subfield maps +INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield) + SELECT 2, name, subfield + FROM acq.provider_holding_subfield_map + WHERE provider = 1; + +INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield) + SELECT 3, name, subfield + FROM acq.provider_holding_subfield_map + WHERE provider = 1; + +INSERT INTO acq.provider_holding_subfield_map (provider, name, subfield) + SELECT 4, name, subfield + FROM acq.provider_holding_subfield_map + WHERE provider = 1; + INSERT INTO acq.purchase_order (id, owner, creator, editor, ordering_agency, provider, state, order_date) VALUES (1, 1, 1, 1, 4, 1, 'pending', NULL), -- 2.11.0