From 69b28b8dd84974e4515c3f59f2dbbfa4595bca04 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Sat, 1 Sep 2012 22:59:21 -0400 Subject: [PATCH] Do the SQL upgrade dance for list pubdate in CSV With a slight tweak to base the upgrade off of the event definition name instead of the ID; possibly more resilient. Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...nerCSV_template.sql => 0737.data.update_ContainerCSV_template.sql} | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.update_ContainerCSV_template.sql => 0737.data.update_ContainerCSV_template.sql} (92%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 1ded67eddb..8439b14644 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0736', :eg_version); -- miker/tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0737', :eg_version); -- dyrcona/dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_ContainerCSV_template.sql b/Open-ILS/src/sql/Pg/upgrade/0737.data.update_ContainerCSV_template.sql similarity index 92% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_ContainerCSV_template.sql rename to Open-ILS/src/sql/Pg/upgrade/0737.data.update_ContainerCSV_template.sql index 5af0feb52a..6e1106f3f1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.update_ContainerCSV_template.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0737.data.update_ContainerCSV_template.sql @@ -1,6 +1,6 @@ BEGIN; -- check whether patch can be applied -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0737', :eg_version); UPDATE action_trigger.event_definition SET template = @@ -28,6 +28,6 @@ FOR item IN items; helpers.csv_datum(title) %],[% helpers.csv_datum(author) %],[% helpers.csv_datum(pub_date) %],[% helpers.csv_datum(item_type) %],[% FOR note IN item.notes; helpers.csv_datum(note.note); ","; END; "\n"; END -%] $$ -WHERE id = 48; +WHERE name = 'Bookbag CSV'; COMMIT; -- 2.11.0