The event-board-api from data-umbrella

Hello,
Data Umbrella is building a community Events Board. The app is still in Beta, and it does get a decent amount of traffic.

To share events (conferences, meetups, webinars), they can be submitted here. 
https://events.dataumbrella.org/

Please let us know if you encounter any technical issues.

Implement weekly digest background worker

Trigger weekly digest from admin

Contributing: move contributing instructions to its own file: CONTRIBUTING.md

Docker (desktop) should be running before docker compose build

add price categories to database

@jtorreggiani @iliadeleon
We were discussing, @symeneses and I, how to best represent the cost of the event.

This is some brainstorming that we did. We can also discuss later on how to best implement it.

Price Category	Price Range
0$	Free
1$	$1-99
2$	> 100
3$	> 500
4$	> 1000
5$	> 2000

Add pagination with Django for viewing events

Audit: https://docs.google.com/spreadsheets/d/1mfn1s6-ncwnaIYpDfD0OH1md6Ni2YB38N_qeyBZQwR8/edit#gid=0
Figma: https://www.figma.com/file/rs7dsdmKlxdfuQ0wobp5B2/Data-Umbrella?node-id=1457%3A4323

Linked to: data-umbrella/event-board-web#144

Resources: https://www.django-rest-framework.org/api-guide/filtering/#searchfilter

Missing pagination needs to be implemented with Django, and needs to have specific numbers of events shown on each page for grid, list, and map view

Details

We need to create a subscription and unsubscribe endpoint for the weekly digest.
The UI will be in react via the event board web repository.
The backend is in Django.

Nice to haves

Ideally, tests should be included for subscribe and unsubscribe.

Implement weekly digest email template

Add in test data

Link to test data:
https://docs.google.com/spreadsheets/d/1hPx63ox9yqG1R7YH5R7dy1_WejjAaKSQVnJYxnEGfUU/edit?usp=sharing

psycopg2 error in M1

Running the project in an M1 is not working because of this error:

psycopg2.OperationalError: SCRAM authentication requires libpq version 10 or above

Implement magic link authentication

Add alerts for failed production deployments

Deployments are handled by Digital Ocean App platform. Look into alerting when production deployments fail.

Consider looking into Slack alerts https://docs.digitalocean.com/products/app-platform/how-to/create-alerts.

Provide author and event form link in admin for providing authors feedback

Implement cron job for weekly digest email

Every week on Monday Morning around 4am PST, we need to send a weekly digest email to those whom have subscribed to it.

Start of implement cron job for weekly digest email

Add opt out link to weekly digest email

The weekly digest email needs to have an unsubscribe link
Figma Design

weekly_digest/templates/emails/weekly_digest_events.html

Opt out of the weekly digest subscription by setting WeeklyDigestSubscription.subscribed = False

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"])

Implement Twitter Event Posts

This task is to be completed after this issue is complete.

Install the tweepy package and configure the project to send tweets https://docs.tweepy.org/en/stable/getting_started.html.

@reshamas, we will need to coordinate on sharing the developer API access tokens. This tutorial shows where you can grab the required tokens in Twitter. https://www.mattcrampton.com/blog/step_by_step_tutorial_to_post_to_twitter_using_python. We can add them as encrypted environmental variables in Digital Ocean.

database field for image URL

@jtorreggiani @iliadeleon

In the models.py file (https://github.com/data-umbrella/event-board-api/blob/main/events/models.py), where can we find a field for "image_url"?

Example of image:
https://2022.pycon.co/img/tickets/background-intro-tickets-regular.png

cc: @symeneses

Normalize search filters to work with seed data

Add Welcome Bot

[Reference Resource] PSF event data

@jtorreggiani
I found this calendar on the PSF site which has only conferences:
https://calendar.google.com/calendar/u/0/[email protected]&ctz=Europe/London

Reference:

PyCon Events calendar: https://pycon.org/#calendar
https://wiki.python.org/moin/PythonEventsCalendar#Python_Events_Calendar

Map

Their map still has 2021 events on it.

Python Events map: http://lmorillas.github.io/python_events/

email subject for sign-in should be "Data Events Board ..."

Currently, the email subject is: Data Event Board: Sign In

It should be: Data Events Board: Sign In

Implement digest email

Profile Page API endpoints

Ensure current data model includes relevant fields (user name and email)
Add endpoint to urls.py
Add class to views.py
write test for API

database: add field for scholarships

@jtorreggiani @iliadeleon
This information to collect. We can include in Phase 1 or a later phase if that is better.
It would be nice to collect information on whether there are scholarships to cover cost of attending the conference.