#!/usr/bin/env bash

set -euo pipefail

source ./0-config_var_setup.sh

EXPORT_DIR="./exports"

mkdir -p "$EXPORT_DIR"

echo "======================================"
echo "93 EXPORT ACTIONS"
echo "======================================"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "
SELECT *
FROM sendgrid_suppressions
WHERE action_status='remove_from_sendgrid'
" \
> "$EXPORT_DIR/remove_from_sendgrid.tsv"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "
SELECT *
FROM sendgrid_suppressions
WHERE action_status='reactivate_candidate'
" \
> "$EXPORT_DIR/reactivate_candidates.tsv"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "
SELECT *
FROM sendgrid_suppressions
WHERE action_status='keep_suppressed'
" \
> "$EXPORT_DIR/keep_suppressed.tsv"

echo ""
echo "Archivos generados:"
ls -lh "$EXPORT_DIR"

echo ""
echo "DONE"