#!/bin/bash
# Download folder
#TEMP_DIR=/home/hust921/Downloads
# Local username
#MYSQL_USER='root'
# Database name
#DB_NAME='plp'
# user password
#MYSQL_PASS=''
# Pantheon connection string
# Available at dashboard under: connection information and looks something like this:
#PAN_CONNECTION_STR='mysql -u pantheon -p1111111111111 -h dbserver.dev.993b8ce9-00cda7b056.drush.in -P 10307 pantheon'
# Pantheon machine token
# Generated by "terminus auth login"
#PAN_TOKEN=''

if [ $UID -ne 0 ];then
    echo "Must be run as root"
    exit
fi

# Check env
if [ -z "$TEMP_DIR" ] || [ -z "$MYSQL_USER" ] || [ -z "$PAN_CONNECTION_STR" ]; then
    echo "enviroment variables not set"
fi

if [ $# -ne 1 ]; then
    echo "Usage $0 [-i|--import] [-e|--export]"
    echo "  -i    Import pantheon db to local"
    echo "  -e    Export local db to pantheon"
elif [[ $1 == "-e" || $1 == "--export" ]];then
    mysqldump -u$MYSQL_USER -p$MYSQL_PASS $DB_NAME > $TEMP_DIR/drupalbackup.sql.gz
    eval $PAN_CONNECTION_STR < $TEMP_DIR/drupalbackup.sql.gz && rm $TEMP_DIR/drupalbackup.sql.gz
elif [[ $1 == "-i" || $1 == "--import" ]];then
    terminus auth login --machine-token=$PAN_TOKEN
    terminus site backups create --element=database --env=dev
    terminus site backups get --element=database --to=$TEMP_DIR/drupalbackup.sql.gz --latest --env=dev
    gunzip < $TEMP_DIR/drupalbackup.sql.gz | mysql -u root -p$MYSQL_PASS $DB_NAME && rm $TEMP_DIR/drupalbackup.sql.gz
fi