Wrap upgrade script for "pretty-print XML" function

Signed-off-by: Dan Scott <dscott@laurentian.ca>

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 64a1a6a..1c885e4 100644 (file)
--- 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 ('0726', :eg_version); -- denials
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0727', :eg_version); -- denials/mrpeters
 
 CREATE TABLE config.bib_source (
        id              SERIAL  PRIMARY KEY,

diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.xml_pretty_print.sql b/Open-ILS/src/sql/Pg/upgrade/0727.function.xml_pretty_print.sql
similarity index 69%
rename from Open-ILS/src/sql/Pg/upgrade/XXXX.function.xml_pretty_print.sql
rename to Open-ILS/src/sql/Pg/upgrade/0727.function.xml_pretty_print.sql
index 0992821..d009070 100644 (file)
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.xml_pretty_print.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/0727.function.xml_pretty_print.sql
@@ -1,3 +1,13 @@
+-- Evergreen DB patch 0727.function.xml_pretty_print.sql
+--
+-- A simple pretty printer for XML.
+-- Particularly useful for debugging the biblio.record_entry.marc field.
+--
+BEGIN;
+
+-- check whether patch can be applied
+SELECT evergreen.upgrade_deps_block_check('0727', :eg_version);
+
 CREATE OR REPLACE FUNCTION evergreen.xml_pretty_print(input XML) 
     RETURNS XML
     LANGUAGE SQL AS
@@ -19,3 +29,4 @@ $func$;
 COMMENT ON FUNCTION evergreen.xml_pretty_print(input XML) IS
 'Simple pretty printer for XML, as written by Andrew Dunstan at http://goo.gl/zBHIk';
 
+COMMIT;