#!/bin/bash -x

PROD_DB_HOST=184.73.231.185
PROD_DB_NAME=dotcms_prod_19
PROD_DB_USER=dotcms
PROD_DB_PASS=dOtCmS
PROD_DB_LINUX_USER=dotCMS
PROD_DB_LINUX_PASS=A9u3nT.CMS

PROD_HOST=184.73.246.241
PROD_USER=dotCMS
PROD_PASS=A9u3nT.CMS
PROD_PATH=/dotcms_local/current

DEV_DB_HOST=199.196.251.93
DEV_DB_NAME=dotcms_dev_19
DEV_DB_USER=dotcms
DEV_DB_PASS=dOtCmS
DEV_PATH=/dotcms_local/current
DEV_TMP=/dotcms/tmp

DEV2_HOST=199.196.251.92
DEV2_USER=dotCMS
DEV2_PASS=A9u3nT.CMS
DEV2_PATH=/dotcms_local/current

## Shutdown Dev Server
$DEV_PATH/bin/shutdown.sh

## Shutdown Dev 2 Server
ssh $DEV2_USER@$DEV2_HOST "$DEV2_PATH/bin/shutdown.sh"

## Backup Prod MySQL
ssh $PROD_DB_LINUX_USER@$PROD_DB_HOST "mysqldump -h localhost --routines --ignore-table=$PROD_DB_NAME.clickstream --ignore-table=$PROD_DB_NAME.clickstream_request -u $PROD_DB_USER $PROD_DB_NAME --password=$PROD_DB_PASS > /tmp/backup1.sql"

## Copy Backup Local
scp $PROD_DB_LINUX_USER@$PROD_DB_HOST:/tmp/backup1.sql $DEV_TMP/backup1.sql

## Drop and Recreate DEV DB
mysql -h $DEV_DB_HOST -u $DEV_DB_USER --password=$DEV_DB_PASS -e "DROP DATABASE $DEV_DB_NAME"
mysql -h $DEV_DB_HOST -u $DEV_DB_USER --password=$DEV_DB_PASS -e "CREATE DATABASE $DEV_DB_NAME"

## Restore Dev MySQL
mysql -h $DEV_DB_HOST -u $DEV_DB_USER $DEV_DB_NAME --password=$DEV_DB_PASS  < $DEV_TMP/backup1.sql

## Copy Assets from PDOD
rsync -avz -e ssh $PROD_USER@$PROD_HOST:$PROD_PATH/dotCMS/assets/ $DEV_PATH/dotCMS/assets

## Delete Current DEV Index
rm -rf $DEV_PATH/dotCMS/dotsecure/dotlucene

## Copy Index from PROD
rsync -avz -e ssh $PROD_USER@$PROD_HOST:$PROD_PATH/dotCMS/dotsecure/dotlucene/ $DEV_PATH/dotCMS/dotsecure/dotlucene

## Copy Assets from Dev to Dev 2
rsync -avz -e ssh $DEV_PATH/dotCMS/assets/ $DEV2_USER@$DEV2_HOST:$DEV2_PATH/dotCMS/assets

## Delte Current Dev 2 Index
ssh $DEV2_USER@$DEV2_HOST "rm -rf $DEV2_PATH/dotCMS/dotsecure/dotlucene"

## Copy Index to Dev 2
rsync -avz -e ssh $DEV_PATH/dotCMS/dotsecure/dotlucene/ $DEV2_USER@$DEV2_HOST:$DEV2_PATH/dotCMS/dotsecure/dotlucene


## Startup Dev Server
#$DEV_INSTALL_PATH/bin/startup.sh