Make Backend Routes for Users

[ThatMegamind]

Instructions

• Create CRUD routes for each query associated with Users, which will allow us to access the data from the frontend

Notes

• Use the queries under server/queries/users.sql as a jumping-off point!

Acceptance Criteria

Routes should be created for the following:

• GET - Returns all data from the Users table
• GET/pending-accounts - Returns all data from Users table who are currently pending approval
• POST - Adds a new row into Users table
• PUT/:uid - Updates an existing user as approved
  • Note: all fields in the req.body are optional (i.e. not all attributes in the table need to be specified)
• DELETE/:uid - Deletes an existing user given their id

Logistics:

• Add the routes in a file located in routes/users.js
• app.js should be updated accordingly
• Delete server/queries/users.sql once this task is complete

As always, feel free to message Michael and Michelle if you have any questions!