gratipay.com/recreate-schema.sh at master · gratipay/gratipay.com · GitHub

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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
#!/usr/bin/env bash

# Exit if any subcommands or pipeline returns a non-zero status.
set -e

# Make a database for Gratipay.
#
#   usage: DATABASE_URL=postgres://foo:bar@baz:5234/buz recreate-schema.sh

echo "=============================================================================="

# I got the idea for dropping the schema as a way to clear out the db from
# http://www.postgresql.org/message-id/200408241254.19075.josh@agliodbs.com. On
# Heroku Postgres we don't have permission to drop and create the db as a
# whole.

echo "Recreating public schema ... "
echo "DROP SCHEMA public CASCADE" | psql "$DATABASE_URL"
echo "CREATE SCHEMA public" | psql "$DATABASE_URL"


echo "=============================================================================="
echo "Enforcing UTC ..."
echo

psql "$DATABASE_URL" < sql/enforce-utc.sql


echo "=============================================================================="
echo "Applying sql/schema.sql ..."
echo

psql "$DATABASE_URL" < sql/schema.sql


echo "=============================================================================="
echo "Loading sql/countries.sql ..."
echo

psql "$DATABASE_URL" < sql/countries.sql


echo "=============================================================================="
echo "Applying deploy hooks ..."
echo

cd deploy
if [ -e before.sql -o -e after.py -o -e after.sql ]
then
    [ -e before.sql ] && echo 'Found before.sql ...' && psql "$DATABASE_URL" < before.sql
    [ -e after.py ] && echo 'Found after.py ...' && env/bin/python after.py
    [ -e after.sql ] && echo 'Found after.sql ...' && psql "$DATABASE_URL" < after.sql
else
    echo "None found. That's cool. See deploy/README.md if you want to modify the "
    echo "database as part of your pull request."
fi
cd ..
echo


echo "=============================================================================="
echo
echo "Okay! Initialized \"$DATABASE_URL\"."
echo
echo "=============================================================================="