From eee8f9b0a65fd285ee157702ca9a9b71ba9ea10a Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Sun, 27 Nov 2022 09:12:17 -0500 Subject: [PATCH] fix this sql --- t/augment_concerto.sql | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/t/augment_concerto.sql b/t/augment_concerto.sql index 6a509ba..a0cc09e 100644 --- a/t/augment_concerto.sql +++ b/t/augment_concerto.sql @@ -1,3 +1,5 @@ +BEGIN; + update actor.usr set @@ -18,8 +20,8 @@ where name = 'sip.sc_status_before_login_institution' ; -INSERT INTO actor.stat_cat_sip_field (field, name, one_only) VALUES ('XX', 'Generic Unformatted Export', 'f'); -INSERT INTO asset.stat_cat_sip_field (field, name, one_only) VALUES ('YY', 'Generic Unformatted Export', 'f'); +INSERT INTO actor.stat_cat_sip_fields (field, name, one_only) VALUES ('XX', 'Generic Unformatted Export', 'f'); +INSERT INTO asset.stat_cat_sip_fields (field, name, one_only) VALUES ('YY', 'Generic Unformatted Export', 'f'); INSERT INTO actor.stat_cat (owner, name, opac_visible, usr_summary, sip_field, sip_format, checkout_archive, required, allow_freetext) VALUES (1, 'test', 'f', 'f', 'XX', '', 'f', 'f', 't'); @@ -27,7 +29,7 @@ INSERT INTO actor.stat_cat_entry_usr_map (stat_cat_entry, stat_cat, target_usr) VALUES ('abc', 1, 71); INSERT INTO asset.stat_cat (owner, opac_visible, name, required, sip_field, checkout_archive) - VALUES (1, 'f', 'test', 'f', 'YY', '', 'f'); + VALUES (1, 'f', 'test', 'f', 'YY', 'f'); INSERT INTO asset.stat_cat_entry(stat_cat, owner, value) VALUES (1, 1, 'a1'), (1, 1, 'b1'); INSERT INTO asset.stat_cat_entry_copy_map (stat_cat, stat_cat_entry, owning_copy) @@ -40,3 +42,4 @@ UPDATE action.hold_request SET phone_notify = '555-5555', pickup_lib = 4, reques UPDATE asset.copy SET circ_lib = 4 WHERE id = 485; INSERT INTO action.hold_copy_map (hold, target_copy, proximity) VALUES (254, 485, 0); +COMMIT; -- 2.11.0