#!/bin/bash
set -e

# We use this to configure our Postgres Docker image with our environment's
# users on instance boot
# 
# Note that you'll need to `docker volume rm palolo-db` everytime this changes
# https://hub.docker.com/_/postgres

DATABASE_NAME=${DATABASE_NAME:-palolo}
DATABASE_USER=${DATABASE_USER:-test}
DATABASE_PASSWORD=${DATABASE_PASSWORD:-test}

psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$POSTGRES_DB" <<-EOSQL
    CREATE DATABASE ${DATABASE_NAME};
	CREATE USER $DATABASE_USER WITH PASSWORD '$DATABASE_PASSWORD' CREATEDB;
	GRANT ALL PRIVILEGES ON DATABASE $DATABASE_NAME TO $DATABASE_USER;
EOSQL