From 848449309cd9504ef06d4a662b0536b0fef63409 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 14 Aug 2015 13:58:39 -0400 Subject: [PATCH] JBAS-651 Port checkout-ok DB changes to sqitch Signed-off-by: Bill Erickson --- .../deploy/copy-stat-checkout-ok.sql} | 9 +++++++-- .../revert/copy-stat-checkout-ok.sql} | 3 +++ KCLS/sql/schema/sqitch.plan | 1 + KCLS/sql/schema/verify/copy-stat-checkout-ok.sql | 8 ++++++++ 4 files changed, 19 insertions(+), 2 deletions(-) rename KCLS/sql/{jbas-651/jbas-651-copy-status-co-allowed.sql => schema/deploy/copy-stat-checkout-ok.sql} (97%) rename KCLS/sql/{jbas-651/jbas-651-copy-status-co-allowed.UNDO.sql => schema/revert/copy-stat-checkout-ok.sql} (99%) create mode 100644 KCLS/sql/schema/verify/copy-stat-checkout-ok.sql diff --git a/KCLS/sql/jbas-651/jbas-651-copy-status-co-allowed.sql b/KCLS/sql/schema/deploy/copy-stat-checkout-ok.sql similarity index 97% rename from KCLS/sql/jbas-651/jbas-651-copy-status-co-allowed.sql rename to KCLS/sql/schema/deploy/copy-stat-checkout-ok.sql index 15cd0acaf2..592105af1f 100644 --- a/KCLS/sql/jbas-651/jbas-651-copy-status-co-allowed.sql +++ b/KCLS/sql/schema/deploy/copy-stat-checkout-ok.sql @@ -1,12 +1,17 @@ +-- Deploy kcls-evergreen:copy-stat-checkout-ok to pg +-- requires: KMAIN-1765-reingest-causing-false-browse-headings + BEGIN; ALTER TABLE config.copy_status ADD COLUMN checkout_ok BOOL NOT NULL DEFAULT FALSE; -UPDATE config.copy_status SET checkout_ok = TRUE +UPDATE config.copy_status + SET checkout_ok = TRUE WHERE id IN (0, 7, 8); -- available, reshelving, holds shelf. -UPDATE config.copy_status SET checkout_ok = TRUE WHERE id = 116; -- Grand Opening +UPDATE config.copy_status + SET checkout_ok = TRUE WHERE id = 116; -- Grand Opening CREATE OR REPLACE FUNCTION action.item_user_circ_test( circ_ou INT, match_item BIGINT, match_user INT, renewal BOOL ) RETURNS SETOF action.circ_matrix_test_result AS $func$ DECLARE diff --git a/KCLS/sql/jbas-651/jbas-651-copy-status-co-allowed.UNDO.sql b/KCLS/sql/schema/revert/copy-stat-checkout-ok.sql similarity index 99% rename from KCLS/sql/jbas-651/jbas-651-copy-status-co-allowed.UNDO.sql rename to KCLS/sql/schema/revert/copy-stat-checkout-ok.sql index 9b049ea974..32c66a5763 100644 --- a/KCLS/sql/jbas-651/jbas-651-copy-status-co-allowed.UNDO.sql +++ b/KCLS/sql/schema/revert/copy-stat-checkout-ok.sql @@ -1,3 +1,5 @@ +-- Revert kcls-evergreen:copy-stat-checkout-ok from pg + BEGIN; ALTER TABLE config.copy_status DROP COLUMN checkout_ok; @@ -221,4 +223,5 @@ BEGIN END; $func$ LANGUAGE plpgsql; + COMMIT; diff --git a/KCLS/sql/schema/sqitch.plan b/KCLS/sql/schema/sqitch.plan index 16653a0976..06438fff76 100644 --- a/KCLS/sql/schema/sqitch.plan +++ b/KCLS/sql/schema/sqitch.plan @@ -11,3 +11,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 +copy-stat-checkout-ok [test-data-mangle] 2015-08-14T20:47:19Z Bill Erickson # copy_status.checkout_ok flag for Grand Opening diff --git a/KCLS/sql/schema/verify/copy-stat-checkout-ok.sql b/KCLS/sql/schema/verify/copy-stat-checkout-ok.sql new file mode 100644 index 0000000000..ebe27efeb9 --- /dev/null +++ b/KCLS/sql/schema/verify/copy-stat-checkout-ok.sql @@ -0,0 +1,8 @@ +-- Verify kcls-evergreen:copy-stat-checkout-ok on pg + +BEGIN; + +-- will fail if new column does not exist +SELECT checkout_ok FROM config.copy_status WHERE FALSE; + +ROLLBACK; -- 2.11.0