install-osrf.sh: set ejabberd host correctly during registration on prod
[sitka/sitka-tools.git] / marc_export_custom / sitka-export-no-cotr.sh
CommitLineData
922948c9
JF
1#!/bin/bash
2
3cd /srv/openils/bin
4
5DATABASE=evergreen
6FULL_QUERY="select id from biblio.record_entry where not deleted"
7POSTSEC_QUERY="select record FROM asset.call_number where owning_lib = 610 and not deleted and label != '##URI##';"
8#POSTSEC_QUERY="select record FROM asset.call_number where owning_lib in (select id from actor.org_unit_descendants(27)) and not deleted and label != '##URI##';"
9
10# full dump for outlook public libraries
11psql -A -t -c "$FULL_QUERY" $DATABASE\
1649d461 12|./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --force901 --exclusion_ini sitka_full_outlook.ini --quiet
922948c9
JF
13
14# media for BC ELN post-secondary libraries
15psql -A -t -c "$POSTSEC_QUERY" $DATABASE\
16|./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --force901 --exclusion_ini bc_eln_media.ini
17~
18# serials for BC ELN post-secondary libraries
19psql -A -t -c "$POSTSEC_QUERY" $DATABASE\
20|./marc_export_custom --config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --force901 --exclusion_ini bc_eln_serials.ini