[GIT] Evergreen ILS branch main updated. 3bc427ad3132c9ddd67a314c8ee596a9ccd2570f

This is an automated email from the git hooks/post-receive script. It was generated because a ref change was pushed to the repository containing the project "Evergreen ILS". The branch, main has been updated via 3bc427ad3132c9ddd67a314c8ee596a9ccd2570f (commit) from aee5289e4334e678cc9649aa0cb51eecc9a51641 (commit) Those revisions listed above that are new to this repository have not appeared on any other notification email; so we list those revisions in full, below. - Log ----------------------------------------------------------------- commit 3bc427ad3132c9ddd67a314c8ee596a9ccd2570f Author: Jason Stephenson <jason@sigio.com> Date: Wed Jun 18 19:27:27 2025 -0400 Forward port 3.15.1 to 3.15.2 db upgrade script Signed-off-by: Jason Stephenson <jason@sigio.com> diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.15.1-3.15.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.15.1-3.15.2-upgrade-db.sql new file mode 100644 index 0000000000..ed0c2b7b80 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.15.1-3.15.2-upgrade-db.sql @@ -0,0 +1,39 @@ +--Upgrade Script for 3.15.1 to 3.15.2 +\set eg_version '''3.15.2''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.15.2', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1471', :eg_version); + +CREATE OR REPLACE FUNCTION evergreen.oils_xpath_string(text, text, text, anyarray) RETURNS text +AS $F$ + SELECT ARRAY_TO_STRING( + oils_xpath( + $1 || + CASE WHEN $1 ~ $re$/[^/[]*@[^]]+$$re$ OR $1 ~ $re$\)$$re$ THEN '' ELSE '//text()' END, + $2, + $4 + ), + $3 + ); +$F$ LANGUAGE SQL IMMUTABLE; + + + +SELECT evergreen.upgrade_deps_block_check('1472', :eg_version); + +INSERT into config.workstation_setting_type (name, grp, datatype, label) +VALUES ( + 'eg.grid.admin.config.coded_value_map', 'gui', 'object', + oils_i18n_gettext( + 'eg.grid.admin.config.coded_value_map', + 'Grid Config: eg.grid.admin.config.coded_value_map', + 'cwst', 'label' + ) +); + +COMMIT; + +-- Update auditor tables to catch changes to source tables. +-- Can be removed/skipped if there were no schema changes. +SELECT auditor.update_auditors(); ----------------------------------------------------------------------- Summary of changes: ....7-upgrade-db.sql => 3.15.1-3.15.2-upgrade-db.sql} | 19 ++++++++++++++++--- 1 file changed, 16 insertions(+), 3 deletions(-) copy Open-ILS/src/sql/Pg/version-upgrade/{3.14.6-3.14.7-upgrade-db.sql => 3.15.1-3.15.2-upgrade-db.sql} (61%) hooks/post-receive -- Evergreen ILS
participants (1)
-
Git User