~joetalbott/+junk/ci-dashboard

temp commit

added added

removed removed

PG_PASS=qa_pass

PG_ADMIN_USER=ciadmin

PG_ADMIN_PASS=ciadmin

if [ -f "$DB_DUMPFILE" ]; then

echo "Initializing DB from dump-file: $DB_DUMPFILE"

juju scp "$DB_DUMPFILE" "$PG_UNIT":

juju run --unit "$PG_UNIT" sudo su - postgres<<< "psql < ~/$DB_DUMPFILE"

echo "Creating ROLEs and DB at $PG_UNIT ..."

juju set ${PG_UNIT%/*} admin_addresses="$(${0%/*}/get-ip $APP_UNIT)"

juju ssh $PG_UNIT sudo su - postgres<<< "psql -c \"CREATE ROLE $PG_ADMIN_USER WITH LOGIN SUPERUSER PASSWORD '$PG_ADMIN_PASS'\"; exit"

juju ssh $PG_UNIT sudo su - postgres<<< "psql -c \"CREATE ROLE $PG_USER WITH LOGIN PASSWORD '$PG_PASS'\"; exit"

juju ssh $PG_UNIT sudo su - postgres<<< "psql -c \"CREATE DATABASE qa_dashboard\"; exit"

if [ ! -f "$DB_DUMPFILE" ]; then

juju ssh $PG_UNIT sudo su - postgres<<< "psql -c \"CREATE DATABASE qa_dashboard\"; exit"

echo "Setting db_host on $APP_UNIT to $PG_UNIT..."

juju set ${APP_UNIT%/*} db_host="$(${0%/*}/get-ip $PG_UNIT)"

sleep 2

echo "Running initial migration to set up db..."

juju run --unit $APP_UNIT "actions/migrate $PG_ADMIN_USER $PG_ADMIN_PASS"