#!/bin/bash

# defaults
start=$(date +%s)
TIMESTAMP=$(date +%F_%H-%M-%S-%N)
SCRIPTDIR=$(dirname "$0")

cd $SCRIPTDIR

SOURCEFILE_DB="/var/www/dump/oxid_db_staging.sql.gz"
CHECK_MARK="\033[0;32m\xE2\x9C\x94\033[0m"

ENV=$(printenv OXID_ENV)
CONFIG="$SCRIPTDIR/../../configurations/$ENV/.config"

if test -f "$CONFIG"; then
    source $CONFIG
else
    echo "No config found. Exiting... $CONFIG ¯\_(ツ)_/¯"
    exit 1
fi

# import dump in pimcore db
echo -n "Importing database..."
gunzip < $SOURCEFILE_DB | mysql --host=$MYSQLHOST --user=$MYSQLUSER --password=$MYSQLPASS -D $MYSQLDB
SQLSTATUS=$?

if [ $SQLSTATUS -eq 0 ]; then
    echo -e "\\r${CHECK_MARK} Importing database... DONE"
else
    echo -e "Importing database... FAILED"
    exit 1
fi

end=$(date +%s)
executiontime=$((end-start))

echo "Pimcore database successfully imported from STAGING (took $executiontime seconds)"