#!/bin/sh
# This file have to be executed like a git hook before every commit. In order to do this copy this script inside
# your repository dir "./git/hooks" naming it "pre-commit" and allowing it to be executed (chmod +x pre-commit)

echo "Executing pre-commit operations..."; 

#games database dump
database_name_games_0=cityrace;
database_name_games_1=eaic;
database_name_games_2=elise; 
database_name_games_3=quorum;
database_name_games_4=creastoria_2016-05-10
database_name_games_5=creastoria
database_name_games_6=sculptures_db

database_user_games_0=cityrace;
database_user_games_1=eaic;
database_user_games_2=elise; 
database_user_games_3=quorum;

database_password_games_0=alinasirbu;
database_password_games_1=misuroeaic2; 
database_password_games_2=perelise;
database_password_games_3=alinasirbu;

#mysql
echo "Dumping ${database_name_games_0} database..."; 
mysqldump -u "${database_user_games_0}" -p"${database_password_games_0}" --replace "${database_name_games_0}" > /var/www/xtribe.eu/etsman/games_db/"${database_name_games_0}".sql
echo "Dumping ${database_name_games_1} database..."; 
mysqldump -u "${database_user_games_1}" -p"${database_password_games_1}" --replace "${database_name_games_1}" > /var/www/xtribe.eu/etsman/games_db/"${database_name_games_1}".sql
echo "Dumping ${database_name_games_2} database..."; 
mysqldump -u "${database_user_games_2}" -p"${database_password_games_2}" --replace "${database_name_games_2}" > /var/www/xtribe.eu/etsman/games_db/"${database_name_games_2}".sql
echo "Dumping ${database_name_games_3} database..."; 
mysqldump -u "${database_user_games_3}" -p"${database_password_games_3}" --replace "${database_name_games_3}" > /var/www/xtribe.eu/etsman/games_db/"${database_name_games_3}".sql

#mongo db
echo "Dumping ${database_name_games_4} database..."; 
mongodump -d "${database_name_games_4}" -o /var/www/xtribe.eu/etsman/games_db/
echo "Dumping ${database_name_games_5} database..."; 
mongodump -d "${database_name_games_5}" -o /var/www/xtribe.eu/etsman/games_db/
echo "Dumping ${database_name_games_6} database..."; 
mongodump -d "${database_name_games_6}" -o /var/www/xtribe.eu/etsman/games_db/

# adding newly created dumps to git
cd /var/www/xtribe.eu/files/
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_0}".sql
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_1}".sql
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_2}".sql
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_3}".sql
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_4}"
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_5}"
git add /var/www/xtribe.eu/etsman/games_db/"${database_name_games_6}"