#!/bin/bash

cat app/config/parameters.yml |grep database_user| awk -F ":" '{print $2}' >> name.txt
cat app/config/parameters.yml |grep database_password| awk -F ":" '{print $2}' >> database.txt

sed -i 's/     //gI' name.txt
sed -i 's/     //gI' database.txt

PROJECTNAME=`cat name.txt`
DATABASEPASS=`cat database.txt`

mysql -u root -e "CREATE USER '$PROJECTNAME'@'localhost' IDENTIFIED BY '$DATABASEPASS';"
mysql -u root -e "GRANT ALL PRIVILEGES ON *.* TO '$PROJECTNAME'@'localhost';"
mysql -u root -e "FLUSH PRIVILEGES;"

CREATEDOMAIN="create database "$PROJECTNAME"_domain_1;"
CREATEMAIN="create database "$PROJECTNAME"_main;"

mysql -u $PROJECTNAME -p$DATABASEPASS -e "$CREATEDOMAIN"
mysql -u $PROJECTNAME -p$DATABASEPASS -e "$CREATEMAIN"

DBDOMAIN=""$PROJECTNAME"_domain_1"
DBMAIN=""$PROJECTNAME"_main"
SQLDOMAIN=""$PROJECTNAME"_domain_1.sql"
SQLMAIN=""$PROJECTNAME"_main.sql"

mysql -u $PROJECTNAME -p$DATABASEPASS $DBDOMAIN < databases/$SQLDOMAIN
mysql -u $PROJECTNAME -p$DATABASEPASS $DBMAIN < databases/$SQLMAIN

rm -f name.txt
rm -f database.txt

echo "Databases created. Have a good day"