#!/bin/sh

USER="ci"
DB_USER="cyneo_ci"
DB_NAME="cyneo_ci"
DB_PASS="cyneo_ci"

PROD_DB_USER="cyneofdc15"
PROD_DB_NAME="cyneofdc15"
PROD_DB_PASS="B3jR98Ek"

PROD_SERVER=s4.econcepto.cognix-systems.net
CI_SERVER=s1.dev-econcepto.com

PROJECT_TITLE=$1
PROJECT_NUMBER=$2
BLD_NUMBER=$3
BLD_PATH=$4

echo "[INFO] Building project $PROJECT_TITLE  - Build N°$BLD_NUMBER "

echo "[INFO] Récupération de la base de données en prod..."
ssh root@$PROD_SERVER "mysqldump --opt -u$PROD_DB_USER -p$PROD_DB_PASS $PROD_DB_NAME > /tmp/init.sql; scp /tmp/init.sql root@$CI_SERVER:/tmp/init.sql; rm -f /tmp/init.sql";
mysql -u$DB_USER -p$DB_PASS $DB_NAME < /tmp/init.sql;
rm -f /tmp/init.sql;

echo "[INFO] Vérification de la présence d'un fichier de nettoyage"
if [ -f tests/db/clean.sql ]
then
   echo "[INFO] Un fichier clean.sql existe"
   mysql -u$DB_USER -p$DB_PASS $DB_NAME < tests/db/clean.sql;
   mv tests/db/clean.sql tests/db/_clean.sql;
else
   echo "[INFO] Aucun fichier clean.sql trouvé"
fi

echo "[INFO] Vérification de la présence d'un fichier d'update"
if [ -f tests/db/update.sql ]
then
   echo "[INFO] Un fichier update.sql existe"
   mysql -u$DB_USER -p$DB_PASS $DB_NAME < tests/db/update.sql;
   mv tests/db/update.sql tests/db/_update.sql;
else
   echo "[INFO] Aucun fichier update.sql trouvé"
fi

echo "[INFO] Configuration de l'application"
cp -a tests/bootstrap/configuration_test.php php/configuration.php
chown -R $USER:$USER .

sed -i "s/__DB_USER__/${DB_USER}/g" php/configuration.php
sed -i "s/__DB_NAME__/${DB_NAME}/g" php/configuration.php
sed -i "s/__DB_PASS__/${DB_PASS}/g" php/configuration.php
sed -i "s/__PROJECT_NUMBER__/${PROJECT_NUMBER}/g" php/configuration.php
sed -i "s/__BUILD_NUMBER__/${BLD_NUMBER}/g" php/configuration.php