#!/bin/bash
echo "------------------------------"
echo "I create the postgres DB for u"
echo "------------------------------"


#DB_NAME
read -p 'DB name : ' var_DBName
echo $var_DBName


#USER_NAME
var_DBUsername=""
read -p "DB user (if empty %DB_name%_u):" var_DBUsername
if [ $var_DBUsername="" ]
then
	var_DBUsername=$var_DBName"_u"
fi
echo $var_DBUsername

#PASSWORD
read -p 'DB password (>=12 char) : ' var_DBpassword
echo $var_DBpassword
if [ 11 -ge ${#var_DBpassword} ]
then
	echo "ERROR : PASSWORD MUST BE LONGER THAN 12 CHAR";
	echo "END OF SCRIPT"
	exit
else
	echo "je suis toujours là"
fi

su -c "psql --command=\"CREATE DATABASE $var_DBName;\" \
--command=\"CREATE USER $var_DBUsername WITH PASSWORD '$var_DBpassword';\" \
--command=\"ALTER ROLE $var_DBUsername SET client_encoding TO 'utf8';\" \
--command=\"ALTER ROLE $var_DBUsername SET default_transaction_isolation TO 'read committed';\" \
--command=\"ALTER ROLE $var_DBUsername SET timezone TO 'Europe/Paris';\" \
--command=\"GRANT ALL PRIVILEGES ON DATABASE $var_DBName TO $var_DBUsername;\" \
" -m "postgres"