From 56d99a4d5c2259916919b0597a3b3d7a4b576569 Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Sun, 5 Mar 2023 16:17:49 -0500 Subject: [PATCH] LP1441750: Stamp Upgrade Script Also update unapi.mmr and actor.usr_merge to account for drift. Signed-off-by: Jason Boyer --- ...ring-agg.sql => 1360.schema.function-fixes-for-string-agg.sql} | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.function-fixes-for-string-agg.sql => 1360.schema.function-fixes-for-string-agg.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.function-fixes-for-string-agg.sql b/Open-ILS/src/sql/Pg/upgrade/1360.schema.function-fixes-for-string-agg.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.function-fixes-for-string-agg.sql rename to Open-ILS/src/sql/Pg/upgrade/1360.schema.function-fixes-for-string-agg.sql index 33b8601476..3783e44ee7 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.function-fixes-for-string-agg.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1360.schema.function-fixes-for-string-agg.sql @@ -1,6 +1,6 @@ BEGIN; ---SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1360', :eg_version); -- bshum / Dyrcona / JBoyer -- replace functions from 300.schema.staged_search.sql @@ -108,7 +108,7 @@ BEGIN IF format = 'holdings_xml' THEN -- the special case output := unapi.mmr_holdings_xml( obj_id, ouid, org, depth, - evergreen.array_remove_item_by_value(includes,'holdings_xml'), + array_remove(includes,'holdings_xml'), slimit, soffset, include_xmlns, pref_lib); RETURN output; END IF; @@ -136,7 +136,7 @@ BEGIN IF ('holdings_xml' = ANY (includes)) THEN hxml := unapi.mmr_holdings_xml( obj_id, ouid, org, depth, - evergreen.array_remove_item_by_value(includes,'holdings_xml'), + array_remove(includes,'holdings_xml'), slimit, soffset, include_xmlns, pref_lib); END IF; @@ -252,7 +252,7 @@ BEGIN UPDATE actor.usr_address SET usr = dest_usr WHERE usr = src_usr; END IF; - UPDATE actor.usr_note SET usr = dest_usr WHERE usr = src_usr; + UPDATE actor.usr_message SET usr = dest_usr WHERE usr = src_usr; -- dupes are technically OK in actor.usr_standing_penalty, should manually delete them... UPDATE actor.usr_standing_penalty SET usr = dest_usr WHERE usr = src_usr; PERFORM actor.usr_merge_rows('actor.usr_org_unit_opt_in', 'usr', src_usr, dest_usr); -- 2.11.0