Create /bounce-list Endpoint

[nelsonic]

At present we only have a "Production" version of the Email App so the Dashboard is polluted with a lot of test data:

Todo

• Create an endpoint that our Lambda function can query to check if a given email address has bounced in the past. If the status includes the word "bounce" then we do not attempt to re-send the email.
• Additionally exclude the test@gmail.com email address and other known test emails from the dashboard.

[nelsonic]

DISTINCT appears to work for grouping sent items to reduce the scrolling in the dashboard. 👍

SELECT DISTINCT ON (p.id, s.status_id) p.id as pid, 
s.id as sid, s.message_id, s.updated_at, s.template, s.person_id, s.status_id
FROM people p
JOIN sent s on s.person_id = p.id
GROUP BY (pid, sid)

[nelsonic]

The dashboard is now grouped by the person.id and sent.status_id so we only see one entry per person for a given status of email. this means we don't have many entries for bounces for a given address.

I think there is still a lot more that can be done to make this dashboard more useful.
But It's only worth doing once we have Auth and the product working. 👍