From ebaf0fd679a1f466205cffa1a3edfd8dffac3e5f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 15 Mar 2012 12:06:48 -0400 Subject: [PATCH] stamped upgrade for hold-avail-email-notify validation Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...lable_email_notify.sql => 0683.hold_available_email_notify.sql} | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.hold_available_email_notify.sql => 0683.hold_available_email_notify.sql} (89%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 38966f27ab..6c5851f00e 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0682', :eg_version); -- berick/dbs/tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0683', :eg_version); -- tsbere/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.hold_available_email_notify.sql b/Open-ILS/src/sql/Pg/upgrade/0683.hold_available_email_notify.sql similarity index 89% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.hold_available_email_notify.sql rename to Open-ILS/src/sql/Pg/upgrade/0683.hold_available_email_notify.sql index a0ab077980..2765f4edcd 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.hold_available_email_notify.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0683.hold_available_email_notify.sql @@ -1,3 +1,8 @@ +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0683', :eg_version); + INSERT INTO action_trigger.event_params (event_def, param, value) VALUES (5, 'check_email_notify', 1); INSERT INTO action_trigger.event_params (event_def, param, value) @@ -16,6 +21,8 @@ UPDATE action_trigger.event_definition SET validator = 'HoldNotifyCheck' WHERE i -- NOT COVERED: Adding check_sms_notify to the proper trigger. It doesn't have a static id. +COMMIT; + --UNDO --UPDATE action_trigger.event_definition SET validator = 'NOOP_True' WHERE id = 9; --DELETE FROM action_trigger.event_params WHERE param = 'check_email_notify'; -- 2.11.0