# !/bin/bash
green=`tput setaf 2`
reset=`tput sgr0`
red=`tput setaf 1`
ok() { echo $1; }

envf() {
	sed -i "10i $1" ".env"
	sed -i "11i $2" ".env"
	sed -i "12i $3" ".env"
	echo "${green}Successfully modified .env file${reset}";
}

EXPECTED_ARGS=3
E_BADARGS=65
MYSQL=`which mysql`

Q1="CREATE DATABASE IF NOT EXISTS $1;"
Q2="GRANT ALL ON *.* TO '$2'@'localhost' IDENTIFIED BY '$3';"
Q3="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}"

if [ $# -ne $EXPECTED_ARGS ]
then
  echo "${red}Usage: $0 dbname dbuser dbpass${reset}"
  exit $E_BADARGS
fi

$MYSQL -u homestead -psecret -e "$SQL"

ok "Database ${green}$1${reset} and user ${green}$2${reset} created with a password ${green}$3${reset}!\n"
envf "DB_DATABASE=$1" "DB_USERNAME=$2" "DB_PASSWORD=$3"
sed -i '13 d' ".env"
sed -i '13 d' ".env"
sed -i '13 d' ".env"