#!/bin/bash

if [ -z "$1" ]; then
  echo -e "Like this:\nsqldump bcsu_staging\n"
  echo -e "Databases are:\nbcsu_staging\nauth_staging\nktbc_staging"
  exit 1
fi

DB_NAME=$1
TMP=$(mktemp -u) && \

gcloud sql export sql db1-bcahsn gs://bcahsn-sql-exports${TMP}.sql.gz --database=${DB_NAME} && \
  gsutil cp gs://bcahsn-sql-exports${TMP}.sql.gz ./${DB_NAME}.sql.gz && \
  gsutil rm gs://bcahsn-sql-exports${TMP}.sql.gz