From 85eb36d88d277aa3be04bdd4f53fa879f85ea1b8 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 30 Jun 2017 14:36:46 -0400 Subject: [PATCH] JBAS-1741 Targeter SQL wrap inserts Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/hold-targeter-v2.sql | 39 ++++++++++++++++------------- 1 file changed, 22 insertions(+), 17 deletions(-) diff --git a/KCLS/sql/schema/deploy/hold-targeter-v2.sql b/KCLS/sql/schema/deploy/hold-targeter-v2.sql index f124cb6a08..e261feed4a 100644 --- a/KCLS/sql/schema/deploy/hold-targeter-v2.sql +++ b/KCLS/sql/schema/deploy/hold-targeter-v2.sql @@ -5,7 +5,28 @@ BEGIN; \set eg_version '''2.9.8''' -SELECT evergreen.upgrade_deps_block_check('1019', :eg_version); +DO $$ +BEGIN + IF evergreen.insert_on_deploy() THEN + + INSERT INTO config.upgrade_log (version) VALUES ('1019'); + INSERT INTO config.upgrade_log (version) VALUES ('1020'); + + INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( + 'circ.holds.retarget_interval', + oils_i18n_gettext( + 'circ.holds.retarget_interval', + 'Holds Retarget Interval', + 'cgf', + 'label' + ), + '24h', + TRUE + ); + + END IF; +END $$; + CREATE OR REPLACE FUNCTION action.hold_request_regen_copy_maps( @@ -14,22 +35,6 @@ CREATE OR REPLACE FUNCTION INSERT INTO action.hold_copy_map (hold, target_copy) SELECT $1, UNNEST($2); $$ LANGUAGE SQL; --- DATA - -INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( - 'circ.holds.retarget_interval', - oils_i18n_gettext( - 'circ.holds.retarget_interval', - 'Holds Retarget Interval', - 'cgf', - 'label' - ), - '24h', - TRUE -); - -SELECT evergreen.upgrade_deps_block_check('1020', :eg_version); - CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting_batch_by_org( setting_name TEXT, org_ids INTEGER[]) RETURNS SETOF actor.org_unit_setting AS -- 2.11.0