From 64bdb45d4ca0047f8573fd0f7f643a0df7c5a706 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Fri, 15 Mar 2013 10:22:13 -0400 Subject: [PATCH] Wrap upgrade script for use ID as TCN value fix Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....sql => 0783.schema.enforce_use_id_for_tcn.sql} | 14 ++++++++++++++ 2 files changed, 15 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.enforce_use_id_for_tcn.sql => 0783.schema.enforce_use_id_for_tcn.sql} (88%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index c1feea7af6..e9bc0e290a 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,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 ('0782', :eg_version); -- miker/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0783', :eg_version); -- gmcharlt/dbs CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.enforce_use_id_for_tcn.sql b/Open-ILS/src/sql/Pg/upgrade/0783.schema.enforce_use_id_for_tcn.sql similarity index 88% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.enforce_use_id_for_tcn.sql rename to Open-ILS/src/sql/Pg/upgrade/0783.schema.enforce_use_id_for_tcn.sql index 87d74bd4ec..0f1381149e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.enforce_use_id_for_tcn.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0783.schema.enforce_use_id_for_tcn.sql @@ -1,3 +1,14 @@ +-- Evergreen DB patch 0783.schema.enforce_use_id_for_tcn.sql +-- +-- Sets the TCN value in the biblio.record_entry row to bib ID, +-- if the appropriate setting is in place +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0783', :eg_version); + +-- FIXME: add/check SQL statements to perform the upgrade CREATE OR REPLACE FUNCTION evergreen.maintain_901 () RETURNS TRIGGER AS $func$ use strict; use MARC::Record; @@ -96,3 +107,6 @@ $_TD->{new}{marc} = $xml; return "MODIFY"; $func$ LANGUAGE PLPERLU; + + +COMMIT; -- 2.43.2