Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /usr/bin/env bash
- CMD="${1?valid commands are psql, seed, create, drop, reset}"
- set -eux pipefail
- export $(sed '/^#/ d' .env)
- HOST="${DB_HOST-localhost}"
- USERNAME="${DB_USERNAME-postgres}"
- PASSWORD="${DB_PASSWORD-postgres}"
- PORT="${DB_PORT-5432}"
- S_ENV="${SCALA_ENV-development}"
- if [ -z "${DB_DATABASE+x}" ]; then
- DATABASE="aqueduct_$S_ENV"
- else
- DATABASE="$DB_DATABASE"
- fi
- if [[ "$CMD" == "psql" ]]; then
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" "$DATABASE"
- elif [[ "$CMD" == "seed" ]]; then
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -d "$DATABASE" -f schema/seed.sql
- elif [[ "$CMD" == "create" ]]; then
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -c "CREATE DATABASE $DATABASE;"
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -d "$DATABASE" -f schema/create.sql
- elif [[ "$CMD" == "drop" ]]; then
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -c "DROP DATABASE $DATABASE;"
- elif [[ "$CMD" == "reset" ]]; then
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -c "DROP DATABASE IF EXISTS $DATABASE;"
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -c "CREATE DATABASE $DATABASE;"
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -d "$DATABASE" -f schema/create.sql
- PGPASSWORD="$PASSWORD" psql -h "$HOST" -U "$USERNAME" -p "$PORT" -d "$DATABASE" -f schema/seed.sql
- fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement