From 00605cda71f84242e9800a3eacbc63b4ff941066 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 27 Jun 2016 15:50:42 -0400 Subject: [PATCH] JBAS-1390 Connexion authority SQL insert check Avoid inserts on initial build of sample databases. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/connexion-auth-imports.sql | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) diff --git a/KCLS/sql/schema/deploy/connexion-auth-imports.sql b/KCLS/sql/schema/deploy/connexion-auth-imports.sql index 37222e46ce..c8ee0b90e1 100644 --- a/KCLS/sql/schema/deploy/connexion-auth-imports.sql +++ b/KCLS/sql/schema/deploy/connexion-auth-imports.sql @@ -3,10 +3,19 @@ BEGIN; -INSERT INTO vandelay.authority_queue (owner, name) VALUES (1, 'Connexion'); +DO $$ +BEGIN + IF evergreen.insert_on_deploy() THEN + + INSERT INTO vandelay.authority_queue (owner, name) + VALUES (1, 'Connexion'); + + INSERT INTO vandelay.merge_profile (owner, name, strip_spec) + VALUES (1, 'Connexion Authority Imports', '905'); + + END IF; +END $$; -INSERT INTO vandelay.merge_profile (owner, name, strip_spec) - VALUES (1, 'Connexion Authority Imports', '905'); COMMIT; -- 2.11.0