From 831b3035d879ec44ad7f8b6a225511c46b4b8fd0 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 14 Aug 2015 16:57:04 -0400 Subject: [PATCH] JBAS-837 sqitch test for data mangling on deploy Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/test-data-mangle.sql | 14 ++++++++++++++ KCLS/sql/schema/revert/test-data-mangle.sql | 7 +++++++ KCLS/sql/schema/sqitch.plan | 1 + KCLS/sql/schema/verify/test-data-mangle.sql | 7 +++++++ 4 files changed, 29 insertions(+) create mode 100644 KCLS/sql/schema/deploy/test-data-mangle.sql create mode 100644 KCLS/sql/schema/revert/test-data-mangle.sql create mode 100644 KCLS/sql/schema/verify/test-data-mangle.sql diff --git a/KCLS/sql/schema/deploy/test-data-mangle.sql b/KCLS/sql/schema/deploy/test-data-mangle.sql new file mode 100644 index 0000000000..a597758ff1 --- /dev/null +++ b/KCLS/sql/schema/deploy/test-data-mangle.sql @@ -0,0 +1,14 @@ +-- Deploy kcls-evergreen:test-data-mangle to pg +-- requires: KMAIN-1765-reingest-causing-false-browse-headings + +BEGIN; + +-- Teturns true if at least one org unit is in the DB +-- This is our indication that deployment scripts should +-- mangle (insert,update,delete) data. +CREATE OR REPLACE FUNCTION + evergreen.mangle_data_on_deploy() RETURNS BOOLEAN AS $$ + SELECT EXISTS(SELECT id FROM actor.org_unit LIMIT 1); +$$ LANGUAGE SQL; + +COMMIT; diff --git a/KCLS/sql/schema/revert/test-data-mangle.sql b/KCLS/sql/schema/revert/test-data-mangle.sql new file mode 100644 index 0000000000..0c1db80a49 --- /dev/null +++ b/KCLS/sql/schema/revert/test-data-mangle.sql @@ -0,0 +1,7 @@ +-- Revert kcls-evergreen:test-data-mangle from pg + +BEGIN; + +DROP FUNCTION evergreen.mangle_data_on_deploy(); + +COMMIT; diff --git a/KCLS/sql/schema/sqitch.plan b/KCLS/sql/schema/sqitch.plan index dadd4c5992..16653a0976 100644 --- a/KCLS/sql/schema/sqitch.plan +++ b/KCLS/sql/schema/sqitch.plan @@ -10,3 +10,4 @@ KMAIN_1729_Bug_from_KMAIN_268 [KMAIN_1448_Bug_from_KMAIN_268] 2015-08-12T19:01:3 02.collection-hq-items-2.5 [01.2.4.1-2.5.7-upgrade] 2015-08-12T21:42:53Z Joshua (JD) Drake # added KMAIN-1765-reingest-causing-false-browse-headings [02.collection-hq-items-2.5] 2015-08-12T21:45:43Z Joshua (JD) Drake # added +test-data-mangle [KMAIN-1765-reingest-causing-false-browse-headings] 2015-08-14T20:36:56Z Bill Erickson # Check for wether to mangle data on deploy diff --git a/KCLS/sql/schema/verify/test-data-mangle.sql b/KCLS/sql/schema/verify/test-data-mangle.sql new file mode 100644 index 0000000000..1c80c3a1c1 --- /dev/null +++ b/KCLS/sql/schema/verify/test-data-mangle.sql @@ -0,0 +1,7 @@ +-- Verify kcls-evergreen:test-data-mangle on pg + +BEGIN; + +SELECT has_function_privilege('evergreen.mangle_data_on_deploy()', 'execute'); + +ROLLBACK; -- 2.11.0