LP1800871: small correction to upgrade script
authorJane Sandberg <sandbej@linnbenton.edu>
Tue, 5 Jan 2021 21:27:05 +0000 (13:27 -0800)
committerJane Sandberg <js7389@princeton.edu>
Thu, 7 Apr 2022 22:35:03 +0000 (15:35 -0700)
Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu>
Signed-off-by: Jason Boyer <JBoyer@equinoxOLI.org>

Open-ILS/src/sql/Pg/upgrade/XXXX.data.MADS21-xsl.sql

index e1ed27d..fe706e7 100644 (file)
@@ -2,7 +2,7 @@ BEGIN;
 
 -- SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version);
 
-INSERT INTO config.xml_transform (name,namespace_uri,prefix,xslt) VALUES ('mads21','http://www.loc.gov/mads/v2','mads21',$XSLT$<?xml version="1.0" encoding="UTF-8"?>
+UPDATE config.xml_transform SET xslt=$XSLT$<?xml version="1.0" encoding="UTF-8"?>
 <xsl:stylesheet version="1.0" xmlns:mads="http://www.loc.gov/mads/v2"
        xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:marc="http://www.loc.gov/MARC21/slim"
        xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="marc">
@@ -1626,6 +1626,6 @@ INSERT INTO config.xml_transform (name,namespace_uri,prefix,xslt) VALUES ('mads2
                </xsl:choose>
        </xsl:template>
        <xsl:template match="*"/>
-</xsl:stylesheet>$XSLT$);
+</xsl:stylesheet>$XSLT$ WHERE name = 'mads21';
 
 COMMIT;