SITKA Public Git / sitka / sitka-tools.git / blame
| Commit | Line | Data |
|---|---|---|
| 922948c9 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" | |
| 7 | POSTSEC_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 | |
| 11 | psql -A -t -c "$FULL_QUERY" $DATABASE\ | |
| 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 | |
| 13 | ||
| 14 | # media for BC ELN post-secondary libraries | |
| 15 | psql -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 | |
| 19 | psql -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 |