#!/bin/bash -e
# This script do mysqldump from dev account
# It requests credentials from aws secretsmanager. Make sure you have rights to read scerets on default AWS account.
# You can pass additional arguments to mysqldump via args

MYSQL_USERNAME=`aws secretsmanager get-secret-value --secret-id dev/ows-podcast/rds_master_username --query SecretString --output text`
MYSQL_PASSWORD=`aws secretsmanager get-secret-value --secret-id dev/ows-podcast/rds_master_password --query SecretString --output text`

mysqldump -h dev-ows-podcast.cluster-co2yckwm6hcp.us-east-1.rds.amazonaws.com -u $MYSQL_USERNAME -p$MYSQL_PASSWORD ows_podcast $*