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

#!/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

export PATH="$bin_dir:$PATH"

#### 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/3 "$@" 3>&1 >&2

}

fi

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

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