#!/usr/bin/env bash

set -euo pipefail

source ./0-config_var_setup.sh

BACKUP_DIR="./backups"

mkdir -p "$BACKUP_DIR"

TS=$(date +"%Y%m%d_%H%M%S")

echo "======================================"
echo "94 BACKUP SENDGRID DATA"
echo "======================================"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "SELECT * FROM contacts" \
> "$BACKUP_DIR/contacts_backup_${TS}.tsv"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "SELECT * FROM sendgrid_suppressions" \
> "$BACKUP_DIR/suppressions_backup_${TS}.tsv"

echo ""
echo "Backups generados:"
ls -lh "$BACKUP_DIR"

echo ""
echo "DONE"