Make CRUD SQL queries for Users table

[ThatMegamind]

Instructions

• Write the SQL queries associated with CRUD (create, read, update, delete) routes for the users endpoint.

Notes

• You can’t test the queries at the moment so just try your best and leave the queries in a temporary file under server/queries/users.sql.

Acceptance Criteria

• 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
• DELETE/:uid - Deletes an existing user given their id

Resources

• DB Model
• Postgres Select
• Postgres Insert
• Postgres Update
• Postgres Delete