From 9d5bf491feda3e91006330e5d65d246f44f9a51d Mon Sep 17 00:00:00 2001
From: Jeff Davis <jdavis@sitka.bclibraries.ca>
Date: Thu, 24 Sep 2020 16:51:51 -0700
Subject: [PATCH] Update db hostname, modify depth per org tree adjustment,
 remove obsolete config for non-Sitka library

---
 marc_export_custom/cotr_ebsco.ini                  | 66 ----------------------
 marc_export_custom/fetch-shortcodes.sh             |  2 +-
 .../mucn-ebsco-full-export-parallel.sh             |  2 +-
 marc_export_custom/sitka-full-export-parallel.sh   |  4 +-
 4 files changed, 4 insertions(+), 70 deletions(-)
 delete mode 100644 marc_export_custom/cotr_ebsco.ini

diff --git a/marc_export_custom/cotr_ebsco.ini b/marc_export_custom/cotr_ebsco.ini
deleted file mode 100644
index a066a23..0000000
--- a/marc_export_custom/cotr_ebsco.ini
+++ /dev/null
@@ -1,66 +0,0 @@
-[SITKA]
-Flags=hidden
-
-; parent_ou=1
-[BBGVL]
-ExcludeEntireOrg=true
-[BBNCLF]
-ExcludeEntireOrg=true
-[BCK]
-ExcludeEntireOrg=true
-[BNCLF]
-ExcludeEntireOrg=true
-[BNELF]
-ExcludeEntireOrg=true
-[GOVLIBS]
-ExcludeEntireOrg=true
-[ISLANDLINK]
-ExcludeEntireOrg=true
-[K12]
-ExcludeEntireOrg=true
-[BVAVSA]
-ExcludeEntireOrg=true
-[BCCB]
-ExcludeEntireOrg=true
-[BMNVI]
-ExcludeEntireOrg=true
-[SGIC]
-ExcludeEntireOrg=true
-[BKCT]
-ExcludeEntireOrg=true
-[SPRUCE]
-ExcludeEntireOrg=true
-[UNFEDERATED]
-ExcludeEntireOrg=true
-[BOISSEVAIN]
-ExcludeEntireOrg=true
-[MANITOU]
-ExcludeEntireOrg=true
-[MB]
-ExcludeEntireOrg=true
-[MDB]
-ExcludeEntireOrg=true
-[MPLP]
-ExcludeEntireOrg=true
-[MS]
-ExcludeEntireOrg=true
-[MSOG]
-ExcludeEntireOrg=true
-[MSSC]
-ExcludeEntireOrg=true
-[MUCN]
-ExcludeEntireOrg=true
-[MWPL]
-ExcludeEntireOrg=true
-[SCRL]
-ExcludeEntireOrg=true
-[SIRL]
-ExcludeEntireOrg=true
-[SPECIAL]
-ExcludeEntireOrg=true
-[STEROSE]
-ExcludeEntireOrg=true
-[BCREK]
-CircMods=floppy-disc
-Statuses=Discard/Weed,Damaged
-Locations=ITSOFTWARE,LIB-STOR,SummitBasement,Weeding
diff --git a/marc_export_custom/fetch-shortcodes.sh b/marc_export_custom/fetch-shortcodes.sh
index 48380da..4c91014 100755
--- a/marc_export_custom/fetch-shortcodes.sh
+++ b/marc_export_custom/fetch-shortcodes.sh
@@ -3,7 +3,7 @@ SHORTCODES=$1
 if [ -z "${SHORTCODES}" ]; then
     SHORTCODES="shortcodes.csv"
 fi
-psql -Upostgres -U evergreen evergreen -h prod-pg94-db2-sitka.sitka.bclibraries.ca -o $SHORTCODES \
+psql -Upostgres -U evergreen evergreen -h dbprod-96-main-ndb2 -o $SHORTCODES \
 -c "COPY (
       SELECT
         a.shortname,a.name,b.shortname AS parent
diff --git a/marc_export_custom/mucn-ebsco-full-export-parallel.sh b/marc_export_custom/mucn-ebsco-full-export-parallel.sh
index 57731a0..adc4996 100755
--- a/marc_export_custom/mucn-ebsco-full-export-parallel.sh
+++ b/marc_export_custom/mucn-ebsco-full-export-parallel.sh
@@ -4,7 +4,7 @@ DIR=$(readlink -f $(dirname $0))
 #cd /srv/openils/bin
 
 PGUSER=evergreen
-PGHOST=prod-pg94-db2-sitka.sitka.bclibraries.ca
+PGHOST=dbprod-96-main-ndb2
 PSQL="psql -A -t -U $PGUSER -h $PGHOST"
 DATABASE=evergreen
 MUCN_QUERY="select distinct record FROM asset.call_number where owning_lib in (select distinct id from actor.org_unit_descendants(1400)) and not deleted and label != '##URI##';"
diff --git a/marc_export_custom/sitka-full-export-parallel.sh b/marc_export_custom/sitka-full-export-parallel.sh
index a6f5bcb..85fefa0 100755
--- a/marc_export_custom/sitka-full-export-parallel.sh
+++ b/marc_export_custom/sitka-full-export-parallel.sh
@@ -4,14 +4,14 @@ DIR=$(readlink -f $(dirname $0))
 #cd /srv/openils/bin
 
 PGUSER=evergreen
-PGHOST=prod-pg94-db2-sitka.sitka.bclibraries.ca
+PGHOST=dbprod-96-main-ndb2
 PSQL="psql -A -t -U $PGUSER -h $PGHOST"
 DATABASE=evergreen
 #FULL_QUERY="select distinct id from biblio.record_entry where not deleted"
 FULL_QUERY="select distinct acn.record FROM asset.call_number acn join biblio.record_entry bre on (acn.record = bre.id) where not bre.deleted and bre.active and not acn.deleted"
 POSTSEC_QUERY="select distinct record FROM asset.call_number where owning_lib in (select distinct id from actor.org_unit_descendants(27)) and not deleted and label != '##URI##';"
 NONEXPORTED_QUERY="select distinct acn.record FROM asset.call_number acn join biblio.record_entry bre on (acn.record = bre.id) where bre.deleted or not bre.active or acn.deleted"
-MARC_PARAMS="--config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --timeout 300 --force901 --encoding UTF-8 --onlyholdings --quiet"
+MARC_PARAMS="--config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 3 --timeout 300 --force901 --encoding UTF-8 --onlyholdings --quiet"
 MARC_EXPORT_BIN="${DIR}/marc_export_custom"
 # this lets us inject perl opts
 MARC_EXPORT="perl ${PERLOPT} -- ${MARC_EXPORT_BIN} ${MARC_PARAMS}"
-- 
2.3.6