#!/bin/bash

echo -n "Enter project name: "
read PROJECT

DBFILE="/srv/www/$PROJECT/conf/database"

POSTGRESQL_USERNAME="postgres"
POSTGRESQL_PORT="5432"
DB_NAME=`grep "DB_NAME" $DBFILE | awk '{print $3}'`
DB_USER=`grep "DB_USER" $DBFILE | awk '{print $3}'`
DB_PASSWORD=`grep "DB_PASSWORD" $DBFILE | awk '{print $3}'`

PGPASSWORD=$DB_PASSWORD
export PGPASSWORD

#dropdb --username=$POSTGRESQL_USERNAME --port=$POSTGRESQL_PORT $DB_NAME
#dropuser --username=$POSTGRESQL_USERNAME --port=$POSTGRESQL_PORT $DB_USER
createuser --username=$POSTGRESQL_USERNAME --port=$POSTGRESQL_PORT --no-superuser --no-createdb --no-createrole --encrypted $DB_USER
createdb --username=$POSTGRESQL_USERNAME --port=$POSTGRESQL_PORT --encoding=utf-8 --template=template0 --owner=$DB_USER $DB_NAME
psql --username=$POSTGRESQL_USERNAME --port=$POSTGRESQL_PORT --dbname=postgres --command="ALTER USER \\\\"$DB_USER\" WITH ENCRYPTED PASSWORD '$DB_PASSWORD'"