Project

General

Profile

1
#!/bin/bash -e
2
# links to locally-available resources
3
. "$(dirname "${BASH_SOURCE[0]}")"/util.sh
4
. "$(dirname "${BASH_SOURCE[0]}")"/db.sh
5

    
6
if self_not_included; then
7

    
8
root_dir="$(dirname "${BASH_SOURCE[0]}")"/../..
9
bin_dir="$root_dir"/bin
10
bin_dir_abs="$(realpath "$bin_dir")"
11

    
12
export PATH="$bin_dir_abs:$PATH"
13

    
14
#### make
15

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

    
18
#### 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
: "${postgres_compat=1}"
30

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

    
33
### PostgreSQL
34

    
35
psql () # usage: [file=...] [dir=...] self
36
{
37
	echo_func
38
	if test -n "$file"; then
39
		set -- --file "$file" "$@"
40
		local dir="${dir:-$(dirname "$file")}"
41
	fi
42
	local dir="${dir:-$top_dir}"
43
	
44
	local psql_cmd="psql_$(if log_sql; then echo verbose; else echo script; fi)_vegbien"
45
	(cat <<EOF
46
\cd $dir
47
\set schema "$schema"
48
\set table "$table"
49
\set table_str '''"$table"'''
50
SET search_path TO "$schema", util;
51
EOF
52
	cat)|
53
	env no_search_path=1 "$psql_cmd" --output /dev/fd/4 "$@" 4>&1 >&2
54
}
55

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

    
58
fi
(3-3/5)