#!/usr/bin/env bash

set -euo pipefail

source ./0-config_var_setup.sh

echo "======================================"
echo "96 VERIFY CLEANUP"
echo "======================================"

echo ""

CONTACTS=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(*)
FROM contacts;
")

SUPPRESSIONS=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(*)
FROM sendgrid_suppressions;
")

MATCHED=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(DISTINCT s.email)
FROM sendgrid_suppressions s
INNER JOIN contacts c
ON s.email = c.email;
")

ASM=$(mysql \
-u"$MYSQL_USER" \
-p"$MYSQL_PASS" \
"$MYSQL_DB" \
-Nse "
SELECT COUNT(*)
FROM sendgrid_suppressions
WHERE suppression_type='asm_unsubscribe';
")

echo "Contacts                    : $CONTACTS"
echo "Suppressions                : $SUPPRESSIONS"
echo "Suppressions in Contacts    : $MATCHED"
echo "ASM Unsubscribes            : $ASM"

echo ""

echo "ACTION STATUS"

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 "PROJECT STATUS"

echo "90 Import    : OK"
echo "91 Analyze   : OK"
echo "92 Prepare   : OK"
echo "93 Export    : OK"
echo "94 Backup    : OK"
echo "95 Dry Run   : OK"
echo "96 Verify    : OK"

echo ""
echo "PROJECT COMPLETE"