From 4f5846551b45d53dd34664a6616c86695860c385 Mon Sep 17 00:00:00 2001 From: Jeff Davis Date: Thu, 28 May 2020 09:17:11 -0700 Subject: [PATCH] LP#1096209: add check_sms_notify parameter to all relevant event defs Signed-off-by: Jeff Davis Signed-off-by: Chris Sharp --- .../Pg/upgrade/XXXX.data.use_check_sms_notify.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.use_check_sms_notify.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.use_check_sms_notify.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.use_check_sms_notify.sql new file mode 100644 index 0000000000..202d8b1d54 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.use_check_sms_notify.sql @@ -0,0 +1,15 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO action_trigger.event_params (event_def, param, value) +SELECT id, 'check_sms_notify', 1 +FROM action_trigger.event_definition +WHERE reactor = 'SendSMS' +AND validator IN ('HoldIsAvailable', 'HoldIsCancelled', 'HoldNotifyCheck') +AND NOT EXISTS ( + SELECT * FROM action_trigger.event_params + WHERE param = 'check_sms_notify' +); + +--COMMIT; -- 2.43.2