Revision 8299
Added by Aaron Marcuse-Kubitza over 11 years ago
inputs/GBIF/MySQL_export | ||
---|---|---|
1 |
#!/bin/bash |
|
2 |
set -o errexit |
|
3 |
# Usage: env table=... [filter=...] self >out |
|
4 |
. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/util.run |
|
5 |
|
|
6 |
: "${table:?}" "${filter:=1}" |
|
7 |
|
|
8 |
(cat <<EOF |
|
9 |
SELECT * FROM $table |
|
10 |
WHERE $filter |
|
11 |
EOF |
|
12 |
)|echo_stdin|echo_run "time" ssh vegbiendev mysql --user=bien \ |
|
13 |
--password="$(cat "$top_dir"/../../config/bien_password)" --database=GBIF \ |
|
14 |
--quick |
|
0 | 15 |
Also available in: Unified diff
Added inputs/GBIF/MySQL_export, used by ./table.run