#!/bin/bash

echo "Please enter the database name"
read DB_NAME
echo "Please enter the database password"
read DB_PASSWORD
sudo su postgres <<EOF
psql -c 'CREATE DATABASE ${DB_NAME};'
psql -c "CREATE ROLE ${DB_NAME} WITH LOGIN PASSWORD 'password';"
psql -c 'GRANT ALL PRIVILEGES ON DATABASE ${DB_NAME} TO ${DB_NAME};'
psql -c 'ALTER ROLE ${DB_NAME} CREATEDB;'
psql -c 'ALTER ROLE ${DB_NAME} WITH LOGIN;'
EOF

echo "Created database $DB_NAME and user $DB_NAME"

echo "------------- Creating environment -----------"
echo -e "DEBUG=on\nDJANGO_DEBUG=True\nDJANGO_EMAIL_BACKEND=kumaraswins@gmail.com\nSECRET_KEY=WLPxHX7XqSnutd8JpLvwhaEu86294Qp5HDxaYA2smkqDqAyOuwpjLMJjf6fKJCHU\nDATABASE_HOST=localhost\nDB_NAME=$DB_NAME\nDB_USER=$DB_NAME\nDB_PASSWORD=$DB_PASSWORD" >> local.env
echo END
echo --------------------------------------------------
exit