From d5cfac2363f95ea9da5b1f6ad8fa4cad1c53778d Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Sun, 23 Dec 2012 15:38:43 -0500 Subject: [PATCH] Stamping upgrade script for index corporate authors Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...e_authors.sql => 0749.data.index_corporate_authors.sql} | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.index_corporate_authors.sql => 0749.data.index_corporate_authors.sql} (82%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 196e37f2d1..db3e77e3dc 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 ('0748', :eg_version); -- dbwells/dbs +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0749', :eg_version); -- dbs/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.index_corporate_authors.sql b/Open-ILS/src/sql/Pg/upgrade/0749.data.index_corporate_authors.sql similarity index 82% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.index_corporate_authors.sql rename to Open-ILS/src/sql/Pg/upgrade/0749.data.index_corporate_authors.sql index ff41992672..a8621d0047 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.index_corporate_authors.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0749.data.index_corporate_authors.sql @@ -1,6 +1,11 @@ -- Use MARC relator codes (710 subfield 4) to index corporate authors, along -- with the existing relator text (710 subfield e) +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0749', :eg_version); + UPDATE config.metabib_field SET xpath = $$//mods32:mods/mods32:name[@type='corporate' and (mods32:role/mods32:roleTerm[text()='creator'] @@ -16,3 +21,5 @@ SELECT metabib.reingest_metabib_field_entries(record, TRUE, TRUE, FALSE) AND subfield = '4' AND value IN ('cre', 'aut') ; + +COMMIT; -- 2.43.2