#!/bin/bash

set -e

if [ -z "${AWS_KEY}" ]; then
  echo "You need to set the AWS_KEY environment variable."
  exit 1
fi

if [ -z "${AWS_SECRET}" ]; then
  echo "You need to set the AWS_SECRET environment variable."
  exit 1
fi

if [ -z "${MYSQL_USER}" ]; then
  MYSQL_USER=root
fi

if [ -z "${MYSQL_PASSWORD}" ]; then
  MYSQL_PASSWORD=''
fi

if [ -z "${MYSQL_HOST}" ]; then
  MYSQL_HOST=localhost
fi

AWS_BUCKET="legacy-mysql-dumps"
DB="skydeo"
MYSQL_HOST_OPTS="-h $MYSQL_HOST -u $MYSQL_USER"
if [ ! -z "${MYSQL_PASSWORD}" ]; then
  MYSQL_HOST_OPTS="$MYSQL_HOST_OPTS -p$MYSQL_PASSWORD"
fi

MYSQLDUMP_OPTIONS="--quote-names --complete-insert --no-create-info --compact --quick --single-transaction --create-options --comments --net_buffer_length=16384"

echo "Starting dump of ${DB} database from ${MYSQL_HOST}..."
echo "With Options ${MYSQLDUMP_OPTIONS}"

for TABLE in `mysql $MYSQL_HOST_OPTS $DB -e 'show tables' | egrep -v 'Tables_in_' `; do
  TABLENAME=$(echo $TABLE|awk '{ printf "%s", $0 }')
  echo Dumping $TABLENAME
  mysqldump $MYSQL_HOST_OPTS $MYSQLDUMP_OPTIONS $DB $TABLENAME | gzip | AWS_ACCESS_KEY_ID=$AWS_KEY AWS_SECRET_ACCESS_KEY=$AWS_SECRET aws s3 cp - s3://$AWS_BUCKET/$TABLENAME.sql.gz
done

echo "Done!"

exit 0