From 39a3500a21b27be836605e51aa15aab4c5b308d8 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 1 Sep 2016 11:40:01 -0700 Subject: [PATCH] Payflow org settings SQL insert-on-deploy wrapper Avoid inserting payflow settings on new dev DB builds -- the data will come later from an export. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/payflow-hosted-org-settings.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/payflow-hosted-org-settings.sql b/KCLS/sql/schema/deploy/payflow-hosted-org-settings.sql index e4d2d6c03c..3928e9edea 100644 --- a/KCLS/sql/schema/deploy/payflow-hosted-org-settings.sql +++ b/KCLS/sql/schema/deploy/payflow-hosted-org-settings.sql @@ -3,6 +3,10 @@ BEGIN; +DO $$ +BEGIN + IF evergreen.insert_on_deploy() THEN + INSERT INTO config.org_unit_setting_type (name, label, description, datatype, view_perm, update_perm, grp) VALUES @@ -33,7 +37,9 @@ VALUES 'reported by the web server). Otherwise, all responses are ' || 'delivered to the return/error/cancel URLs configured with PayPay', 'bool', 1005, 1006, 'credit') - ; + END IF; -- insert_on_deploy +END $$; + COMMIT; -- 2.11.0