Weekly Digest Email

[dashcraft]

Details

Every week on Monday Morning around 4am PST, we need to send a weekly digest email to those whom have subscribed to it.
The email and cron job need to be created with this ticket.
Figma Email Link
The email needs to have an unsubscribe link, that uses the endpoint from issue #59
The weekly digest needs to include the upcoming events for the week.
If there are no events in the next week, we can expand the query to the next month and send that instead.

Additional Context

The email can be drastically reduced if necessary, much more spartan than the design. There are numerous issues with email services and providers, creating a consistent email across providers is very difficult, usually i'd recommend a 3rd party service (send grid templates for instance) for this kind of work.

An example query for selecting the events for the digest for a given month:

Events.objects.filter(date__year='2022', date__month='01')

Events.objects.filter(date__range=["2011-01-01", "2011-01-31"])

[jackwkinsey]

@dashcraft @jtorreggiani

Is there a server where I need to setup the cronjob?

[dashcraft]

I can unblock if we need to, if you can test locally with an exaggerated cron schedule and then set it to the weekly, we can test ourselves this weekend (on digital ocean, etc)

[mjtribble]

Separate digital ocean service that queries the db to send email? potentially use the same repo but set up as a separate service? any other color that would be helpful here @dashcraft @jackwkinsey ?

[dashcraft]

There should be a built in django cron plugin to do this, shouldn't require digital ocean for any other service.

django-crontab

[mjtribble]

Cron Job & Unsubscribe link are ticketed out. Email has been implemented and can be triggered via console atm

#83 #81