#!/bin/bash -e

# links to locally-available resources

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

. "$(dirname "${BASH_SOURCE[0]}")"/db.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_export_local() { echo_func; use_local_remote; mysql_export "$@"; }

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

### PostgreSQL

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

{

	echo_func

	if test "$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)|stderr_is_errors=1 \

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

}

public_schema_exists() { psql_script_vegbien </dev/null 2>/dev/null; }

fi