#!/bin/bash
# Script to facilitate the initial settings of database on a project with Symfony 1.4 and CPANEL
# author @gpupo
# 11/08/2011
# Save this file in the project folder (config/sfInitDb.sh maybe)
# Usage: config/sfInitDb.sh username password

printf "CPANEL_USER='${1}';\nCPANEL_PASSWORD='${2}';" > config/host_vars.sh;
source config/host_vars.sh
cat << EOF > config/configureDatabase.sh
symfony configure:database --env=prod "mysql:host=localhost;dbname=${CPANEL_USER}_web" ${CPANEL_USER}_web ${CPANEL_PASSWORD}
symfony configure:database --env=dev "mysql:host=localhost;dbname=${CPANEL_USER}_dev" ${CPANEL_USER} ${CPANEL_PASSWORD}
symfony configure:database --env=test "mysql:host=localhost;dbname=${CPANEL_USER}_test" ${CPANEL_USER} ${CPANEL_PASSWORD}
EOF

cat << EOF > config/schemaCreate.sql

CREATE USER '${CPANEL_USER}'@'localhost' IDENTIFIED BY '${CPANEL_PASSWORD}';
GRANT ALL PRIVILEGES ON \`${CPANEL_USER}\_%\` . * TO '${CPANEL_USER}'@'localhost';
CREATE DATABASE IF NOT EXISTS ${CPANEL_USER}_dev;
CREATE DATABASE IF NOT EXISTS ${CPANEL_USER}_test;
flush privileges;
EOF

sh config/configureDatabase.sh;
mysql -u root -p < config/schemaCreate.sql;