#!/bin/bash -e

# links to locally-available resources

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

if self_not_included; then

root_dir="$(dirname "${BASH_SOURCE[0]}")"/..

bin_dir="$root_dir"/bin

bin_dir_abs="$(realpath "$bin_dir")"

export PATH="$bin_dir_abs:$PATH"

#### make

root_make () { echo_func; make --directory="$root_dir" "$@"; }

#### connection vars

: "${remote_server=vegbiendev.nceas.ucsb.edu}"

: "${local_server=localhost}"

: "${local_user=bien}"

: "${local_password="$(cat "$root_dir"/config/bien_password)"}"

#### databases

### MySQL

: "${postgres_compat=1}"

mysql () { echo_func; echo_run mysql_bien --database="$schema" --verbose "$@"; }

mysqldump_local () { echo_func; use_local_remote; mysqldump_diffable "$@"; }

### PostgreSQL

psql () # usage: [file=...] [dir=...] self

{

	echo_func

	if test -n "$file"; then

		set -- --file "$file" "$@"

		local dir="${dir:-$(dirname "$file")}"

	fi

	local dir="${dir:-$top_dir}"

	local psql_cmd="psql_$(if log_sql; then echo verbose; else echo script; fi)_vegbien"

	(cat <<EOF

\cd $dir

\set schema "$schema"

\set table "$table"

\set table_str '''"$table"'''

SET search_path TO "$schema", util;

EOF

	cat)|

	env no_search_path=1 "$psql_cmd" --output /dev/fd/4 "$@" 4>&1 >&2

}

fi