SITKA Public Git / sitka / sitka-tools.git / blame
| Commit | Line | Data |
|---|---|---|
| 22ff20e5 JF |
1 | #!/bin/bash |
| 2 | ||
| 3 | cd /srv/openils/bin | |
| 4 | ||
| 5 | DATABASE=evergreen | |
| 6 | FULL_QUERY="select id from biblio.record_entry where not deleted" | |
| 922948c9 | 7 | 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##';" |
| 0eba6526 | 8 | MARC_PARAMS="--config /srv/openils/conf/opensrf_core.xml --items --location SITKA --collapse_to_depth 2 --timeout 300 --force901 --encoding UTF-8 --onlyholdings" |
| 22ff20e5 JF |
9 | |
| 10 | # full dump for outlook public libraries | |
| 11 | psql -A -t -c "$FULL_QUERY" $DATABASE\ | |
| 0eba6526 | 12 | |./marc_export_custom $MARC_PARAMS --exclusion_ini sitka_full_outlook.ini |
| 22ff20e5 JF |
13 | |
| 14 | # media for BC ELN post-secondary libraries | |
| 15 | psql -A -t -c "$POSTSEC_QUERY" $DATABASE\ | |
| 0eba6526 | 16 | |./marc_export_custom $MARC_PARAMS --exclusion_ini bc_eln_media.ini |
| 22ff20e5 JF |
17 | ~ |
| 18 | # serials for BC ELN post-secondary libraries | |
| 19 | psql -A -t -c "$POSTSEC_QUERY" $DATABASE\ | |
| 0eba6526 | 20 | |./marc_export_custom $MARC_PARAMS --exclusion_ini bc_eln_serials.ini |