#!/bin/bash

DATE=`date +%Y-%m-%d-%s`

echo "Creating database folder"
if [ -d "/home/jenkins/database" ]; then
  echo "database folder exists!!"
else
  mkdir -p /home/jenkins/database/
fi

if [ -e /home/jenkins/database/db-last.sql ]; then
  mv /home/jenkins/database/db-last.sql /home/jenkins/database/db-$DATE.sql
fi

echo "Dumping mysql to jenkins home ie. /home/jenkins/"
/usr/bin/mysqldump --user=$DEV_USER --password=$DEV_PASSWORD -h $DEV_HOST $DEV_DB > /home/jenkins/database/db-last.sql
echo "Done!"

echo "Importing database from dev"
/usr/bin/mysql --user=$PROD_USER --password=$PROD_PASSWORD -h $PROD_HOST $PROD_DB < /home/jenkins/database/db-last.sql
echo "Success!!"