-
Notifications
You must be signed in to change notification settings - Fork 1
/
export_schema.sh
executable file
·42 lines (31 loc) · 1.29 KB
/
export_schema.sh
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
#!/bin/sh
set -e
function finish {
rm pgpassfile
}
trap finish EXIT
# ensure some environment variables are set
: "${DATABASE_URL:?DATABASE_URL not set in environment}"
: "${POSTGRES_USER:?POSTGRES_USER not set in environment}"
: "${POSTGRES_PASSWORD:?POSTGRES_PASSWORD not set in environment}"
# pull apart some of those pieces stuck together in DATABASE_URL
URL=`echo ${DATABASE_URL} | sed -E 's/^jdbc\:(.+)/\1/'` # jdbc:<url>
: "${URL:?URL not parsed}"
HOST=`echo ${DATABASE_URL} | sed -E 's/^.*\/{2}(.+):.*$/\1/'` # //<host>:
: "${HOST:?HOST not parsed}"
PORT=`echo ${DATABASE_URL} | sed -E 's/^.*\:([0-9]+)\/.*$/\1/'` # :<port>/
: "${PORT:?Port not parsed}"
DB=`echo ${DATABASE_URL} | sed -E 's/^.*\/(.+)\?*$/\1/'` # /<db>?
: "${DB:?DB not set}"
# pgpassfile makes it easy and safe to login
echo "${HOST}:${PORT}:${DB}:${POSTGRES_USER}:${POSTGRES_PASSWORD}" > pgpassfile
chmod 600 pgpassfile
export PGPASSFILE=pgpassfile
export PGHOST=$HOST
export PGPORT=$PORT
export PGDATABASE=$DB
export PGUSER=$POSTGRES_USER
mkdir -p build/schema
pg_dump -n $1 -T jv_* -T data_loaded -O > build/schema/schema.$1.sql
pg_dump -n $1 -T jv_* -T data_loaded -O --section=pre-data --section=data > build/schema/pre.schema.$1.sql
pg_dump -n $1 -T jv_* -T data_loaded -O --section=post-data > build/schema/post.schema.$1.sql