From 9d5bf491feda3e91006330e5d65d246f44f9a51d Mon Sep 17 00:00:00 2001 From: Jeff Davis 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