From 8b41b28e2922c313d9b114b69804a0c378001646 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 19 Jun 2018 08:33:20 -0400 Subject: [PATCH] migration_tools.reset_event but consider using action_trigger.purge_events instead Signed-off-by: Jason Etheridge --- sql/base/base.sql | 16 ++++++++++++++++ 1 files changed, 16 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index e7096d4..3340482 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -2696,6 +2696,22 @@ CREATE OR REPLACE FUNCTION migration_tools.duplicate_templates (INTEGER, INTEGER END; $$ LANGUAGE PLPGSQL STRICT VOLATILE; +CREATE OR REPLACE FUNCTION migration_tools.reset_event (BIGINT) RETURNS VOID AS $$ + UPDATE + action_trigger.event + SET + start_time = NULL + ,update_time = NULL + ,complete_time = NULL + ,update_process = NULL + ,state = 'pending' + ,template_output = NULL + ,error_output = NULL + ,async_output = NULL + WHERE + id = $1; +$$ LANGUAGE SQL; + CREATE OR REPLACE FUNCTION migration_tools.get_marc_leader (TEXT) RETURNS TEXT AS $$ my ($marcxml) = @_; -- 1.7.2.5