#!/bin/bash
if [ $# -eq 1 ]; then
    APPLICATION_PATH=$1
else
    APPLICATION_PATH=/home/data/www/amo/cashbox
fi

echo "----> Creation de la base"
echo "DROP DATABASE IF EXISTS CASHBOX;" | mysql -u cashbox --password=xobhsac
echo "CREATE DATABASE CASHBOX;" | mysql -u cashbox --password=xobhsac

echo "----> Import des schemas"
mysql -u cashbox --password=xobhsac < $APPLICATION_PATH/docs/BDD/schema_with_schema.sql;
mysql -u cashbox --password=xobhsac < $APPLICATION_PATH/docs/BDD/schema_with_schema_view.sql;

echo "----> Generation des donnees"
mysql -u cashbox --password=xobhsac CASHBOX < $APPLICATION_PATH/docs/BDD/data.sql;

echo "----> Base de tests unitaires"
$APPLICATION_PATH/tests/unit/utils/install-db

echo "[OK]"