From 6ad7127a7443ce86e44bcf963b3ae05ca87de2ec Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 28 Sep 2017 12:40:56 -0400 Subject: [PATCH] JBAS-1787 More SQL insert wrappers Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/aged-circs-api.sql | 8 ++++++-- KCLS/sql/schema/deploy/patron-co-history-stage-2.sql | 10 ++++++++-- 2 files changed, 14 insertions(+), 4 deletions(-) diff --git a/KCLS/sql/schema/deploy/aged-circs-api.sql b/KCLS/sql/schema/deploy/aged-circs-api.sql index 19a5908187..1ded8ad4f9 100644 --- a/KCLS/sql/schema/deploy/aged-circs-api.sql +++ b/KCLS/sql/schema/deploy/aged-circs-api.sql @@ -4,8 +4,12 @@ BEGIN; -\set eg_version '''2.7.8''' -SELECT evergreen.upgrade_deps_block_check('0998', :eg_version); +DO $INSERT$ +BEGIN + IF evergreen.insert_on_deploy() THEN + PERFORM evergreen.upgrade_deps_block_check('0998', '2.7.8'); + END IF; +END $INSERT$; DROP FUNCTION IF EXISTS action.summarize_all_circ_chain (INTEGER); DROP FUNCTION IF EXISTS action.all_circ_chain (INTEGER); diff --git a/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql b/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql index 716b7c0a9a..e0730a1245 100644 --- a/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql +++ b/KCLS/sql/schema/deploy/patron-co-history-stage-2.sql @@ -11,8 +11,14 @@ UPDATE config.global_flag SET value = '1 year 1 day', enabled = TRUE WHERE name = 'history.circ.retention_age'; -\set eg_version '''2.7.8''' -SELECT evergreen.upgrade_deps_block_check('0960', :eg_version); + +DO $INSERT$ +BEGIN + IF evergreen.insert_on_deploy() THEN + PERFORM evergreen.upgrade_deps_block_check('0960', '2.7.8'); + END IF; +END $INSERT$; + UPDATE action_trigger.hook SET core_type = 'auch' -- 2.11.0