#!/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="$(canon_rel_path "$(dirname "${BASH_SOURCE[0]}")"/../..)" || return

root_rel_path() { echo_func; base_dir="$root_dir" canon_rel_path "$1"; }

bin_dir="$root_dir"/bin

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

export PATH="$bin_dir_abs:$PATH"

#### make

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

#### connection vars

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

: "${remote_server=}"

: "${local_server=localhost}"

: "${local_user=bien}"

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

: "${local_pg_database=vegbien}"

: "${root_user=root}"

: "${root_password=$local_password}"

#### databases

### MySQL

: "${postgres_compat=1}"

mysql_local() { echo_func; use_local_remote; mysql "$@"; }

mysql_export_local() { echo_func; use_local_remote; mysql_export "$@"; }

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

mysql_root() { echo_func; use_local_remote; use_root; mysql "$@"; }

### PostgreSQL

func_override psql__db_sh

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

{

	echo_func; kw_params file dir

	if test "$file"; then local dir="${dir:-$(dirname "$file")}"; fi

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

	mk_schema_esc

	mk_table_esc

	use_local

	(cat <<EOF

\cd $dir

\set schema $schema_esc

\set table $table_esc

\set table_str '''$table_esc'''

SET search_path TO $schema_esc, util;

EOF

	cat${file:+ "$file"}

	)|psql__db_sh "$@"

}

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

fi