#!/bin/bash -e

realpath () { readlink -f -- "$1"; }

include_guard_var () { realpath "$1"|sed 's/[^a-zA-Z0-9_]/_/g'; }

self_not_included () # usage: if self_not_included; then ... fi

{

	test "$#" -ge 1 || set -- "${BASH_SOURCE[1]}"

	local include_guard="$(include_guard_var "$1")"

	alias self_being_included=false

	test -z "${!include_guard+t}" && \

	{ eval "$include_guard"=1; alias self_being_included=true; }

}

# to load newly-defined aliases for use in functions in the same file:

## fi # load new aliases

## if self_being_included; then

# this is needed because aliases defined inside an if statement are not

# available inside that if statement

if self_not_included "${BASH_SOURCE[0]}"; then

shopt -s expand_aliases

#### arrays

join () { local IFS="$delim"; echo "$*"; } # usage: delim=... join elems...

reverse () # usage: array=($(reverse args...))

{

	local i

	for (( i=$#; i >= 1; i-- )); do printf '%q ' "${!i}"; done

}

#### verbose output

: "${verbosity:=$verbose}" "${verbosity:=0}"

echo_cmd () { echo "$PS4$*" >&2; }

echo_run () { echo_cmd "$@"; "$@"; }

if test "$verbosity" -ge 1; then

	alias env="echo_run env" # automatically echo commands that use env

fi

canon_rel_path ()

{

	local path="$1"

	path="$(realpath "$path")" # canonicalize

	path="${path#$(pwd -P)/}" # remove any shared prefix with the current dir

	echo "$path"

}

# usage: echo_func "$@"

echo_func ()

{

	local script="$(canon_rel_path "${BASH_SOURCE[1]}")"

	echo_cmd "$script:${BASH_LINENO[0]}" "${FUNCNAME[1]}" "$@"

}

echo_stdin () # usage: input|echo_stdin|cmd

{

	echo ----- >&2

	tee -a /dev/stderr;

	echo ----- >&2

}

echo_vars () # usage: echo_vars var...

{ { echo -n "$PS4"; declare -p "${@%%=*}";} >&2; }

echo_export ()

{

	builtin export "$@"

	echo_vars "$@"

}

if test "$verbosity" -ge 2; then

	alias export="echo_export" # automatically echo env vars when they are set

fi

usage () { echo "Usage: $1" >&2; (exit 2); }

#### strings

sed_ere_flag="$(test "$(uname)" = Darwin && echo E || echo r)"

sed () { echo_run env sed -"$sed_ere_flag" "$@";}

#### vars

set_var () { eval "$1"'="$2"'; }

set_inv () { set_var no_"$1" "$(test -n "${!1}" || echo 1)"; }

# usage: local var=...; local_inv

alias local_inv='local "no_$var=$(test -n "${!var}" || echo 1)"'

# usage: local prefix=..._; import_vars

alias import_vars="$(cat <<'EOF'

: "${prefix:?}"

local src_var dest_var

for src_var in $(eval echo '${!'$prefix'*}'); do

	dest_var="${src_var#$prefix}"

	local "$dest_var=${!src_var}"; echo_vars "$dest_var"

done

EOF

)"

#### commands

top_dir="$(dirname "$0")" # outermost script

run_args_cmd () # runs the command line args command

{

	test "$?" -eq 0 || return

	eval set -- "$(reverse "${BASH_ARGV[@]}")"

	test "$#" -ge 1 || set -- all

	echo_cmd "$(canon_rel_path "$0")" "$@"; "$@"

}

fwd () # usage: subdirs=(...); fwd "$FUNCNAME" "$@"

{

	echo_func "$@"

	: "${subdirs?}"

	for subdir in "${subdirs[@]}"; do

		"$(dirname "${BASH_SOURCE[1]}")"/"$subdir"/run "$@"

	done

}

#### make

make ()

{

	echo_func "$@"

	echo_run env make --directory="$top_dir" "$@"

}

if false; then ## usage:

inline_make 3<<'EOF'

target:

	$(self_dir)/cmd >$@

EOF

# target will be run automatically because it's first in the makefile

fi ##

inline_make ()

{

	echo_func "$@"

	local self="$(readlink -f "${BASH_SOURCE[1]}")"

	local self_dir="$(dirname "$self")"

	export self self_dir

	make --makefile=<((

		cat /dev/fd/3

		echo -n "

.SUFFIXES: # turn off built-in suffix rules

.SECONDARY: # don't automatically delete intermediate files

.DELETE_ON_ERROR: # delete target if recipe fails

"

	)|echo_stdin) "$@"

}

#### compression

### zip

alias zip="echo_run zip"

alias unzip="echo_run unzip"

set_inv force

alias zip_newer="zip${no_force:+ -u}"

alias unzip_newer="unzip${no_force:+ -u} -o"

	# -o is safe because -u only extracts newer files

#### databases

# using prefixed connection vars

alias use_local="local prefix=local_; import_vars"

alias use_remote="local prefix=remote_; import_vars"

alias use_local_remote="use_local; use_remote"

quote='"'

esc_name () { echo "$quote${1//$quote/$quote$quote}$quote"; }

mk_esc_name () { set_var "$1"_esc "$(esc_name "${!1}")"; }

alias mk_schema_esc="local schema_esc; mk_esc_name schema"

alias mk_table_esc="local table_esc; mk_esc_name table"

fi # load new aliases

if self_being_included; then

log_sql () { test "$verbosity" -ge 2; }

### MySQL

# auto-adds connection/login opts when specified

mysql_cmd () # usage: mysql* () { ...; mysql_cmd "$@"; }

{

	echo_func "$@"

	if test _"$ssh_server" = _"$(hostname -f)"; then local ssh_server=; fi

	if test -n "$ssh_server"; then

		local ssh_dest="${ssh_dest-${ssh_user:+$ssh_user@}$ssh_server}"

	fi

	local var=ssh_dest; local_inv

	echo_run ${no_ssh_dest:+env }${ssh_dest:+ssh "$ssh_dest" }"${FUNCNAME[1]}" \

${server:+ --host="$server" }${user+--user="$user" }\

--password${password+="$password"} "$@"

}

mysql ()

{

	echo_func "$@"

	mysql_cmd --verbose "$@"

}

mysql_ANSI ()

{

	echo_func "$@"

	(echo "SET sql_mode = 'ANSI';"; cat)|mysql "$@"

}

mysqldump () # usage: [schema=1 | data=1] mysqldump db [table...]

{

	echo_func "$@"

	mysql_cmd --quick --lock-tables=false --set-charset \

${postgres_compat:+--compatible=postgresql --add-locks=false }\

${schema:+--no-data }${data:+--no-create-info }"$@"

}

mysqldump_diffable ()

{

	echo_func "$@"

	mysqldump "$@"|sed 's/^(-- Dump completed).*$/\1/'

}

### PostgreSQL

pg_copy_to ()

{

	echo_func "$@"

	if test -z "$source"; then

		: "${table:?}"; mk_table_esc

		if test -z "$limit"; then local source="$table_esc"

		else local source="(SELECT * FROM $table_esc LIMIT $limit)"

		fi

	fi

	local pg_copy_format="${pg_copy_format-CSV HEADER}"

	psql "$@" <<<"COPY $source TO STDOUT $pg_copy_format;"

}

pg_header ()

{

	echo_func "$@"

	local pg_copy_format="CSV HEADER" limit=0

	pg_copy_to "$@"|echo_stdin

}

pg_export_table_no_header ()

{

	echo_func "$@"

	local pg_copy_format="CSV"

	pg_copy_to "$@"

}

pg_export_table_to_dir_no_header ()

{

	echo_func "$@"

	local table="$1"; shift; mk_table_esc

	local cols="$(pg_header)"

	pg_export_table_no_header "$@" >"$exports_dir/$table.no_header.cols=$cols.csv"

}

fi