From ee556511981eecc1bd4115d309c8f92ed251f80d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 15 Jan 2015 15:55:39 -0500 Subject: [PATCH] JBAS-408 delete copy maps at fulfillment time Revert part of the change introduced by JBAS-149, which caused hold copy maps to be deleted at capture time instead of fulfillment time. That part of the change (which has no real benefit) had unexpected side effects. We now return to deleting copy maps at fulfillment time. Signed-off-by: Bill Erickson --- KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql | 15 +++++++++++++++ .../jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql | 14 ++++++++++++++ 2 files changed, 29 insertions(+) create mode 100644 KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql create mode 100644 KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql diff --git a/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql b/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql new file mode 100644 index 0000000000..e7362a20b3 --- /dev/null +++ b/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.sql @@ -0,0 +1,15 @@ +BEGIN; + +DROP TRIGGER hold_request_clear_map_tgr ON action.hold_request; + +CREATE TRIGGER hold_request_clear_map_tgr + AFTER UPDATE ON action.hold_request + FOR EACH ROW + WHEN ( + (NEW.cancel_time IS NOT NULL AND OLD.cancel_time IS NULL) + OR (NEW.fulfillment_time IS NOT NULL AND OLD.fulfillment_time IS NULL) + ) + EXECUTE PROCEDURE action.hold_request_clear_map(); + +COMMIT; + diff --git a/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql b/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql new file mode 100644 index 0000000000..068a469438 --- /dev/null +++ b/KCLS/sql/jbas-408/jbas-408-copy-map-delete-fulfill.undo.sql @@ -0,0 +1,14 @@ +BEGIN; + +DROP TRIGGER hold_request_clear_map_tgr ON action.hold_request; + +CREATE TRIGGER hold_request_clear_map_tgr + AFTER UPDATE ON action.hold_request + FOR EACH ROW + WHEN ( + (NEW.cancel_time IS NOT NULL AND OLD.cancel_time IS NULL) + OR (NEW.capture_time IS NOT NULL AND OLD.capture_time IS NULL) + ) + EXECUTE PROCEDURE action.hold_request_clear_map(); + +COMMIT; -- 2.11.0