From 51e616557eb8d7cba05e93edbc046a4e1412f986 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Sun, 14 Feb 2016 16:09:14 -0500 Subject: [PATCH] LP#1486592: Add price for some more items in concerto dataset Some additional items for peer bibs and part copies need prices too. Signed-off-by: Ben Shum --- Open-ILS/tests/datasets/sql/assets_concerto.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/Open-ILS/tests/datasets/sql/assets_concerto.sql b/Open-ILS/tests/datasets/sql/assets_concerto.sql index 82e050fe03..ad3631b281 100644 --- a/Open-ILS/tests/datasets/sql/assets_concerto.sql +++ b/Open-ILS/tests/datasets/sql/assets_concerto.sql @@ -99,13 +99,13 @@ INSERT INTO biblio.monograph_part (record, label) VALUES (53, 'DISC 1'), (53, 'DISC 2'), (53, 'DISC 3'), (53, 'DISC 4'); -- Create additional copies for the parts -INSERT INTO asset.copy (call_number, circ_lib, creator, editor, loan_duration, fine_level, barcode) - SELECT id, owning_lib, 1, 1, 1, 1, 'CONC70001' || id::text +INSERT INTO asset.copy (call_number, circ_lib, creator, editor, loan_duration, fine_level, price, barcode) + SELECT id, owning_lib, 1, 1, 1, 1, (SELECT evergreen.generate_price()), 'CONC70001' || id::text FROM asset.call_number WHERE record IN (53, 84) AND label LIKE 'M%' AND owning_lib = 7; -INSERT INTO asset.copy (call_number, circ_lib, creator, editor, loan_duration, fine_level, barcode) - SELECT id, owning_lib, 1, 1, 1, 1, 'CONC70002' || id::text +INSERT INTO asset.copy (call_number, circ_lib, creator, editor, loan_duration, fine_level, price, barcode) + SELECT id, owning_lib, 1, 1, 1, 1, (SELECT evergreen.generate_price()), 'CONC70002' || id::text FROM asset.call_number WHERE record IN (53, 84) AND label LIKE '78%' AND owning_lib = 7; @@ -125,8 +125,8 @@ INSERT INTO biblio.peer_type (name) VALUES ('Media player'); -- Create additional copies for the conjoined items -INSERT INTO asset.copy (call_number, circ_lib, creator, editor, loan_duration, fine_level, barcode) - SELECT id, owning_lib, 1, 1, 1, 1, 'PEERBIB' || record::text +INSERT INTO asset.copy (call_number, circ_lib, creator, editor, loan_duration, fine_level, price, barcode) + SELECT id, owning_lib, 1, 1, 1, 1, (SELECT evergreen.generate_price()), 'PEERBIB' || record::text FROM asset.call_number WHERE record = 15 AND label LIKE 'M%' AND owning_lib = 4; -- 2.11.0