terminal-save
echo
echo "Création de l'utilisateur et de la BDD"
echo "Creating MySql User ... "
new_db_pwd=`date +%s | sha256sum | base64 | head -c 12`
echo "Generated Pass : $new_db_pwd"
echo "Add MySql user"
$mysqlCommand -e "CREATE USER IF NOT EXISTS '$projectShortName'@'localhost' IDENTIFIED BY '$new_db_pwd';"
# re-set password if user exists
$mysqlCommand -e "ALTER USER '$projectShortName'@'localhost' IDENTIFIED BY '$new_db_pwd';"
echo "Create Database"
$mysqlCommand -e "CREATE DATABASE IF NOT EXISTS \`$projectShortName\` CHARACTER SET utf8 COLLATE utf8_general_ci;"
echo "Define user rights"
$mysqlCommand -e "GRANT ALL PRIVILEGES ON \`$projectShortName\`.* TO \`$projectShortName\`@'localhost';"
echo "Flush Privileges"
$mysqlCommand -e "FLUSH PRIVILEGES;"
sleep 1
terminal-restore
echo -e " + BDD user&base \e[1;92mInitialisés\e[0m (\e[1m$projectShortName : $new_db_pwd\e[0m)"
terminal-save
echo
echo -e "Import de la BDD en local, patientez un instant \033[5m...\033[0m"
echo
case $projectType in
"wordpress")
echo -e "Suppression du contenu lourd (relevanssi, seopress) \033[5m...\033[0m "
# remove relevanssi content & seo press (increase speed)
TABLE_PREFIX=$(wp config get table_prefix)
sed -i -e "/INSERT INTO \`${TABLE_PREFIX}relevanssi\`/d" -e "/INSERT INTO \`${TABLE_PREFIX}seopress_significant_keywords\`/d" $HOME/$projectShortName.sql
# mv $HOME/${projectShortName}_reduce.sql $HOME/${projectShortName}.sql
;;
"symfony")
;;
*)
# nothing special
;;
esac
# import de la BDD
{ pv $HOME/${projectShortName}.sql | $mysqlCommand $projectShortName; } || {
echo
echo -e "\033[1;31mErreur\033[0m d'import dans la commande";
echo "pv $HOME/$projectShortName.sql | $mysqlCommand $projectShortName";
exit 1;
}
# suppression du fichier SQL local
rm $HOME/$projectShortName.sql;
terminal-restore
echo -e " + BDD \e[1;92mImportée\e[0m"