Project

General

Profile

1 8699 aaronmk
#!/bin/bash -e
2
# links to locally-available resources
3 8893 aaronmk
. "$(dirname "${BASH_SOURCE[0]}")"/util.sh
4 9014 aaronmk
. "$(dirname "${BASH_SOURCE[0]}")"/db.sh
5 8699 aaronmk
6 8705 aaronmk
if self_not_included; then
7
8 9331 aaronmk
root_dir="$(canon_rel_path "$(dirname "${BASH_SOURCE[0]}")"/../..)" || return
9 8699 aaronmk
bin_dir="$root_dir"/bin
10 9331 aaronmk
bin_dir_abs="$(realpath "$bin_dir")" || return
11 8705 aaronmk
12 8925 aaronmk
export PATH="$bin_dir_abs:$PATH"
13 8708 aaronmk
14 8939 aaronmk
#### make
15
16 9074 aaronmk
root_make() { echo_func; make --directory="$root_dir" "$@"; }
17 8939 aaronmk
18 8890 aaronmk
#### connection vars
19
20
: "${remote_server=vegbiendev.nceas.ucsb.edu}"
21
: "${local_server=localhost}"
22
: "${local_user=bien}"
23
: "${local_password="$(cat "$root_dir"/config/bien_password)"}"
24
25
#### databases
26
27
### MySQL
28
29 8891 aaronmk
: "${postgres_compat=1}"
30
31 9153 aaronmk
mysql_export_local() { echo_func; use_local_remote; mysql_export "$@"; }
32
33 9074 aaronmk
mysqldump_local() { echo_func; use_local_remote; mysqldump_diffable "$@"; }
34 8892 aaronmk
35 8890 aaronmk
### PostgreSQL
36
37 9074 aaronmk
psql() # usage: [file=...] [dir=...] self
38 8777 aaronmk
{
39 9235 aaronmk
	echo_func; kw_params file dir
40 9050 aaronmk
	if test "$file"; then
41 8777 aaronmk
		set -- --file "$file" "$@"
42 8834 aaronmk
		local dir="${dir:-$(dirname "$file")}"
43 8777 aaronmk
	fi
44 8834 aaronmk
	local dir="${dir:-$top_dir}"
45 9427 aaronmk
	mk_schema_esc
46
	mk_table_esc
47 8777 aaronmk
48 9421 aaronmk
	local psql_cmd="psql_$(if can_log; then echo verbose; else echo script; fi)_vegbien"
49 8777 aaronmk
	(cat <<EOF
50
\cd $dir
51 9427 aaronmk
\set schema $schema_esc
52
\set table $table_esc
53
\set table_str '''$table_esc'''
54
SET search_path TO $schema_esc, util;
55 8777 aaronmk
EOF
56 9214 aaronmk
	cat)|cmd_log_fd=1 \
57 9213 aaronmk
	env no_search_path=1 "$psql_cmd" --output /dev/fd/11 "$@" 11>&1
58 8777 aaronmk
}
59
60 9074 aaronmk
public_schema_exists() { psql_script_vegbien </dev/null 2>/dev/null; }
61 9046 aaronmk
62 8705 aaronmk
fi