#!/usr/bin/env bash

set -euo pipefail

source ./0-config_var_setup.sh

echo "======================================"
echo "92 PREPARE ACTIONS"
echo "======================================"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "

UPDATE sendgrid_suppressions
SET action_status='remove_from_sendgrid'
WHERE suppression_type='spam_report';

UPDATE sendgrid_suppressions
SET action_status='remove_from_sendgrid'
WHERE suppression_type='invalid_email';

UPDATE sendgrid_suppressions
SET action_status='keep_suppressed'
WHERE suppression_type='asm_unsubscribe';

UPDATE sendgrid_suppressions
SET action_status='reactivate_candidate'
WHERE suppression_type IN ('bounce','block');

"

echo ""
echo "======================================"
echo "ACTION SUMMARY"
echo "======================================"

mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-e "
SELECT
action_status,
COUNT(*) total
FROM sendgrid_suppressions
GROUP BY action_status
ORDER BY total DESC;
"

echo ""
echo "DONE"