#!/bin/bash

MYSQL="/Applications/MAMP/Library/bin/mysql"
MYSQL_USER="root"
MYSQL_PASS="root"
MYSQL_DB="prod_thr"
DB_FILE_NAME="latest.mysql"
DB_FILE_EXT="gz"
WORK_DIR="$HOME/Downloads"
FILE=$WORK_DIR/$DB_FILE_NAME
COMPRESSED_FILE=$WORK_DIR/$DB_FILE_NAME.$DB_FILE_EXT

if [ -e $COMPRESSED_FILE ]; then
  logger -s "Gunzipping database file"
  gunzip $COMPRESSED_FILE
fi

if [ -e $FILE ]; then
    logger -s "Removing and recreating DB"
    $MYSQL -u$MYSQL_USER -p$MYSQL_PASS -e "DROP DATABASE \`$MYSQL_DB\`;"
    $MYSQL -u$MYSQL_USER -p$MYSQL_PASS -e "CREATE DATABASE \`$MYSQL_DB\`; SET UNIQUE_CHECKS=0; SET AUTOCOMMIT = 0; SET FOREIGN_KEY_CHECKS = 0;"
    logger -s "Loading latest DB Copy to MySQL"
    $MYSQL -u$MYSQL_USER -p$MYSQL_PASS $MYSQL_DB < $FILE
    $MYSQL -u$MYSQL_USER -p$MYSQL_PASS -e "COMMIT; SET UNIQUE_CHECKS=1; SET FOREIGN_KEY_CHECKS = 1;"
    logger -s "DONE"
else
    logger -s "Could not find database file. Exiting"
    exit 1
fi

exit 0