#!/usr/bin/env bash

set -euo pipefail

source ./0-config_var_setup.sh

echo "======================================"
echo "95 EXECUTE CLEANUP (DRY RUN)"
echo "======================================"

echo ""

REMOVE_COUNT=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(*)
FROM sendgrid_suppressions
WHERE action_status='remove_from_sendgrid';
")

REACTIVATE_COUNT=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(*)
FROM sendgrid_suppressions
WHERE action_status='reactivate_candidate';
")

KEEP_COUNT=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(*)
FROM sendgrid_suppressions
WHERE action_status='keep_suppressed';
")

echo "Would remove from SendGrid : $REMOVE_COUNT"
echo "Would reactivate           : $REACTIVATE_COUNT"
echo "Would keep suppressed      : $KEEP_COUNT"

echo ""
echo "DRY RUN ONLY"
echo "DONE"