#!/usr/bin/env bash

LOGFILE='./ows-assets.log'
table=$1

# User-friendly print wrapper.
log() {
  printf '[%s] [%s] %s\n' "${0##*/}" "$( date '+%Y-%m-%dT%H:%M:%S' )" "${@}" >> "${LOGFILE}"
}

log "Starting dump"
log "$(date)"

nohup mysqldump --order-by-primary --single-transaction=TRUE -h prod-ows.cb22xqmk0y0q.us-east-1.rds.amazonaws.com ows_assets ${table} > ${table}.sql
log "$(date)"
log "Finished mysqldump for ${table}"
log "Cleaning up file for ${table}"
sed -i -e 's/SET @@SESSION.SQL_LOG_BIN= 0;//' -e "s/SET @@GLOBAL.GTID_PURGED='';//" -e 's/SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;//' ${table}.sql

log "Beginning mysql import for ${table}"
log "$(date)"
nohup mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -h prod-ows-assets.cluster-cb22xqmk0y0q.us-east-1.rds.amazonaws.com ows_assets < ${table}.sql
log "$(date)"
log "Finished mysql import for ${table}"