From b92bdcb98793dfe145070647fcddf9aec2f7b7ad Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 17 Feb 2017 01:12:08 -0500 Subject: [PATCH] LP#1596595: Stamping upgrade scripts for hold targeter refactoring Signed-off-by: Kathy Lussier --- .../sql/Pg/upgrade/XXXX.schema.hold_targeter.sql | 25 ---------------------- .../upgrade/YYYY.schema.batch_settings_by_org.sql | 24 --------------------- 2 files changed, 49 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql deleted file mode 100644 index ba584f0f57..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql +++ /dev/null @@ -1,25 +0,0 @@ -BEGIN; - -CREATE OR REPLACE FUNCTION - action.hold_request_regen_copy_maps( - hold_id INTEGER, copy_ids INTEGER[]) RETURNS VOID AS $$ - DELETE FROM action.hold_copy_map WHERE hold = $1; - INSERT INTO action.hold_copy_map (hold, target_copy) SELECT $1, UNNEST($2); -$$ LANGUAGE SQL; - --- DATA - -INSERT INTO config.global_flag (name, label, value, enabled) VALUES ( - 'circ.holds.retarget_interval', - oils_i18n_gettext( - 'circ.holds.retarget_interval', - 'Holds Retarget Interval', - 'cgf', - 'label' - ), - '24h', - TRUE -); - -COMMIT; - diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql deleted file mode 100644 index 567183f307..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql +++ /dev/null @@ -1,24 +0,0 @@ -BEGIN; - -CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting_batch_by_org( - setting_name TEXT, org_ids INTEGER[]) - RETURNS SETOF actor.org_unit_setting AS -$FUNK$ -DECLARE - setting RECORD; - org_id INTEGER; -BEGIN - /* Returns one actor.org_unit_setting row per org unit ID provided. - When no setting exists for a given org unit, the setting row - will contain all empty values. */ - FOREACH org_id IN ARRAY org_ids LOOP - SELECT INTO setting * FROM - actor.org_unit_ancestor_setting(setting_name, org_id); - RETURN NEXT setting; - END LOOP; - RETURN; -END; -$FUNK$ LANGUAGE plpgsql STABLE; - -COMMIT; - -- 2.11.0