cougarcs/cougarcs-backend

An Express API to service the CougarCS website.

cougarcs-backend's Issues

Add emails to mailing list during signup

In the payment.js file add a api call to sendgrid that will automate this step

Automatically Enroll Registered Members into Newsletter Ledger

We would like to automatically add registered members into our SendGrid newsletter so that the newsletter ledger does not need to be manually updated.

This feature logic will likely fit in the payment.js file after payment has been successfully processed and the member is added to our database.

Docker Compose for Development

Event Pagination Feature for CougarCS Calendar

Google Calendar Events List API used by CougarCS-Backend
https://developers.google.com/calendar/api/v3/reference/events/list
This fetches every single event, sorted by last updated.

When this was implemented, there was no consideration for pagination and now we pay the price of this tech debt.

However, recently we reached the limit on how much data we can fetch. This will impact any events shown in October and future.

Refer to fix #295

Let me know if you need more information!

Add Catch Space to Membership Date Function

At the moment, if a student attempts to enroll for a semester of CougarCS Membership on the last few days of an academic term, their membership will start and end on that same semester. We should add a catch space, say, 15 days, that if a student tries to enroll within 15 days of the end of the semester, their start term is still that semester, but the end term is extended to the following semester.

Spring Semester End = May 13
Fall Semester End = Dec 16
Catch Space = 15 days

Here are some cases:

Pays for "semester" on January 1, 2000
--> Membership Start = Spring 2000
--> Membership End = Spring 2000

Pays for "year" on March 1, 2000
--> Membership Start = Spring 2000
--> Membership End = Fall 2000

Pays for "semester" on May 5, 2000
--> Membership Start = Spring 2000
--> Membership End = Fall 2000

Student paid within catch space of end of Spring Semester. The end date rolled over to next semester.

Pays for "year" on May 5, 2000
--> Membership Start = Spring 2000
--> Membership End = Spring 2001

Student paid within catch space of end of Spring Semester. The end date rolled over to next semester.

Pays for "semester" on August 1, 2000
--> Membership Start = Fall 2000
--> Membership End = Fall 2000

Pays for "semester" on November 1, 2000
--> Membership Start = Fall 2000
--> Membership End = Fall 2000

Pays for "semester" on Dec 5, 2000
--> Membership Start = Fall 2000
--> Membership End = Spring 2001

Student paid within catch space of end of Fall Semester. The end date rolled over to next semester.

Pays for "year" on Dec 5, 2000
--> Membership Start = Fall 2000
--> Membership End = Fall 2001

Student paid within catch space of end of Fall Semester. The end date rolled over to next semester.

Dependency Dashboard

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Warning

These dependencies are deprecated:

Datasource	Name	Replacement PR?
npm	eslint-config-prettier-check

Rate-Limited

These updates are currently rate-limited. Click on a checkbox below to force their creation now.

• Update dependency express-actuator to v1.8.4
• Update dependency @sendgrid/mail to v7.7.0
• Update dependency @supabase/supabase-js to v2.44.4
• Update dependency dotenv to v16.4.5
• Update dependency eslint to v8.57.0
• Update dependency eslint-plugin-import to v2.29.1
• Update dependency eslint-plugin-jest to v26.9.0
• Update dependency eslint-plugin-prettier to v4.2.1
• Update dependency express-rate-limit to v6.11.2
• Update dependency express-validator to v6.15.0
• Update dependency helmet to v5.1.1
• Update dependency moment to v2.30.1
• Update dependency newrelic to v8.17.1
• Update dependency prettier to v2.8.8
• Update dependency supertest to v6.3.4
• Update dependency winston to v3.13.1
• Update GitHub Artifact Actions to v4 (major) (actions/download-artifact, actions/upload-artifact)
• Update actions/checkout action to v4
• Update actions/dependency-review-action action to v4
• Update actions/setup-node action to v4
• Update dependency @newrelic/winston-enricher to v4
• Update dependency @notionhq/client to v2
• Update dependency @sendgrid/mail to v8
• Update dependency eslint to v9
• Update dependency eslint-config-prettier to v9
• Update dependency eslint-plugin-jest to v28
• Update dependency eslint-plugin-prettier to v5
• Update dependency express-rate-limit to v7
• Update dependency express-validator to v7
• Update dependency helmet to v7
• Update dependency newrelic to v11
• Update dependency nodemon to v3
• Update dependency prettier to v3
• Update dependency stripe to v16
• Update dependency supertest to v7
• Update dependency uuid to v10
• Update github/codeql-action action to v3
• Update sentry-javascript monorepo (major) (@sentry/node, @sentry/tracing)
• 🔐 Create all rate-limited PRs at once 🔐

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• Update dependency axios to ^0.28.0 [SECURITY]
• Update dependency express to v4.19.2 [SECURITY]
• Update dependency @sentry/tracing to v6.19.7
• Update dependency nodemon to v2.0.22
• Update actions/upload-artifact action to v3.1.3
• Update babel monorepo (@babel/cli, @babel/core, @babel/node, @babel/plugin-transform-runtime, @babel/preset-env, @babel/register, @babel/runtime)
• Update dependency @changesets/cli to v2.27.7
• Update dependency @types/jest to v27.5.2
• Update dependency eslint-config-prettier to v8.10.0
• Update Node.js to v18
• Update jest monorepo to v29 (major) (@types/jest, jest)
• Update stryker-js monorepo to v8 (major) (@stryker-mutator/core, @stryker-mutator/jest-runner)
• Click on this checkbox to rebase all open PRs at once

Detected dependencies

docker-compose

docker-compose.dev.yml

dockerfile

Dockerfile

• node 16-alpine3.14

Dockerfile.dev

• node 16-alpine3.14

github-actions

.github/workflows/codeql-analysis.yml

• actions/checkout v3
• github/codeql-action v2
• github/codeql-action v2
• github/codeql-action v2

.github/workflows/dependency-review.yml

• actions/checkout v3
• actions/dependency-review-action v1

.github/workflows/node.js.yml

• actions/checkout v3
• actions/setup-node v3
• actions/checkout v3
• actions/setup-node v3
• actions/checkout v2
• actions/setup-node v3
• actions/upload-artifact v3.0.0
• actions/checkout v2
• actions/setup-node v3
• actions/checkout v3
• actions/download-artifact v3
• actions/checkout v3
• actions/download-artifact v3
• actions/checkout v3
• getsentry/action-release v1

npm

package.json

• @babel/runtime ^7.17.9
• @newrelic/winston-enricher ^2.1.2
• @notionhq/client ^0.4.2
• @sendgrid/mail ^7.5.0
• @sentry/node ^6.19.7
• @sentry/tracing ^6.19.0
• @supabase/supabase-js ^2.8.0
• axios ^0.27.2
• compression ^1.7.4
• cors ^2.8.5
• cross-env ^7.0.3
• dotenv ^16.0.0
• express ^4.18.1
• express-actuator ^1.8.1
• express-rate-limit ^6.4.0
• express-validator ^6.12.2
• helmet ^5.0.2
• lodash ^4.17.21
• memory-cache ^0.2.0
• moment ^2.29.4
• morgan ^1.10.0
• morgan-json ^1.1.0
• newrelic ^8.10.0
• stripe ^8.217.0
• uuid ^8.3.0
• winston ^3.7.2
• @babel/cli 7.17.10
• @babel/core 7.17.10
• @babel/node 7.17.10
• @babel/plugin-transform-runtime 7.17.10
• @babel/preset-env 7.17.10
• @babel/register 7.17.7
• @changesets/cli 2.26.0
• @stryker-mutator/core ^5.6.1
• @stryker-mutator/jest-runner ^5.6.1
• @types/jest 27.4.1
• eslint 8.14.0
• eslint-config-airbnb-base 15.0.0
• eslint-config-prettier 8.5.0
• eslint-config-prettier-check 1.0.0
• eslint-plugin-import 2.26.0
• eslint-plugin-jest 26.1.5
• eslint-plugin-prettier 4.0.0
• jest 27.5.1
• nodemon 2.0.15
• prettier 2.6.2
• supertest 6.2.4

---

• Check this box to trigger a request for Renovate to run again on this repository

Create an endpoint for newsletter subscriptions

Add an endpoint in the API that take in a POST request with following fields:

• First Name
• Last Name
• Email

Validate this input using express-validator

Send this information to sendgrid mailing list using Sendgrid API, link to sendgrid documentation (https://docs.sendgrid.com/api-reference/contacts-api-lists/add-a-single-recipient-to-a-list)

Notes:

• May need to create a test Sendgrid account to test the changes

Endpoint to serve YouTube videos

Strip backend integration

Minify response using compression