From 77e399c7126687d9c282e684b44f9db3e04028ed Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 12 May 2017 13:46:49 -0400 Subject: [PATCH] LP#1690418 Action/trigger complete_time back-fill Set trigger event complete_time equal to its update_time for completed events that have no complete time. As noted in the SQL, this could be a very large update. Signed-off-by: Bill Erickson --- .../upgrade/XXXX.data.action-trigger-complete-time.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger-complete-time.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger-complete-time.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger-complete-time.sql new file mode 100644 index 0000000000..2c8ed1b934 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.action-trigger-complete-time.sql @@ -0,0 +1,18 @@ +BEGIN; -- needed? + +-- NOTE: This could be a very large update, affecting millions of rows. +-- It should be exectued as a separate part of any version upgrade scripts, +-- running outside of the main transaction. + +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +\qecho +\qecho Setting action_trigger.event.complete_time. +\qecho This could affect many rows and take a while to run. +\qecho + +UPDATE action_trigger.event + SET complete_time = update_time + WHERE state = 'complete' AND complete_time IS NULL; + +COMMIT; -- 2.11.0