#!/bin/bash
set -e

# Database credentials
PG_HOST=$RDS_HOSTNAME
PG_PORT=$RDS_PORT
PG_DB_NAME=$RDS_DB_NAME
PG_USERNAME=$RDS_USERNAME
export PGPASSWORD=$RDS_PASSWORD

#aws cli uses these env variables, export them
export AWS_DEFAULT_REGION="us-west-2"
export AWS_ACCESS_KEY_ID=$AWS_DB_BACKUP_MANAGER_API_KEY
export AWS_SECRET_ACCESS_KEY=$AWS_DB_BACKUP_MANAGER_API_SECRET

# S3
S3_DIR="db-backups-element/$ELEMENT_ENV/$(date +"%Y-wk%V")"

# Vars
NOW=$(date +"%Y-%m-%d-at-%H-%M-%S")
SQL_FILENAME="$PG_DB_NAME"-"$NOW".sql

# Dump database
echo "Copying data to /tmp/$SQL_FILENAME"
pg_dump -c -h $PG_HOST -U $PG_USERNAME $PG_DB_NAME > /tmp/$SQL_FILENAME

# Copy to S3
echo "Uploading to s3://$S3_DIR"
aws s3 cp /tmp/$SQL_FILENAME s3://$S3_DIR/$SQL_FILENAME --sse aws:kms --sse-kms-key-id $KMS_KEY_ID --storage-class STANDARD_IA --region us-west-2

# Delete local file
echo "Removing tmp files"
rm /tmp/$SQL_FILENAME