#!/bin/bash

set -o errexit

# Usage: env table=... [filter=...] self >out

. "$(dirname "${BASH_SOURCE[0]}")"/../../lib/sh/util.sh

: "${table:?}"

(cat <<EOF

SELECT * FROM $table

${filter:+WHERE $filter}

${limit:+LIMIT $limit }${offset:+OFFSET $offset}

EOF

)|echo_stdin|echo_run "time" ssh vegbiendev mysql --user=bien \

--password="$(cat "$top_dir"/../../config/bien_password)" --database=GBIF \

--quick