#!/bin/bash
PATH="/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin"
remote_host="204.232.170.236"
db_host="localhost"
db_user="backup"
db_pass="XXXXXXXXXXXXXXXXXXXXX"
backup_key="/usr/local/share/backup_key"
backup_dir="/var/backups/env_sync"

#prep our dir
[[ -d $backup_dir ]] || mkdir -p $backup_dir
find $backup_dir -type f | xargs rm -fv

ssh -i $backup_key backup@$remote_host env_sync_db
read -p "Populate panel schema only tables with random data (y/n)?"
[ "$REPLY" == "y" ] || ssh -i $backup_key backup@$remote_host env_sync_rand_data
rsync -av -e "ssh -i $backup_key" backup@$remote_host:$backup_dir/ $backup_dir/

cd $backup_dir
db_files=$(ls *.sql.gz | grep $(date +%m-%d))
for file in $db_files
  do
    db=$(echo $file | awk -F- '{print $1}')
    echo -n "Importing db: $db... "
    gunzip < $file | mysql -h $db_host -u $db_user -p$db_pass $db
    echo "Done"
done

rand_panel_datafiles=$(ls *.out)
for file in $rand_panel_datafiles
  do
    table=$(echo $file | awk -F\. '{print $1}')
    echo -n "Populating panel table: $table"
    mysqlimport -L -h $db_host -u $db_user -p$db_pass panel $file
    echo "Done"
done

echo "DB REFRESH COMPLETE"