Make Backend Routes for Catalog

[ThatMegamind]

Instructions

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

Notes

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

Acceptance Criteria

Routes should be created for the following:

• GET - Returns all data from the catalog table
• GET/:id - Returns the row that matches the id
• POST - Adds a new row to the catalog table
• PUT/:id - Updates an existing row given an id
  • Note: all fields in the req.body are optional (i.e. not all attributes in the table need to be specified)
• DELETE/:id - deletes an existing row given an id

Logistics:

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

Resources

• 2.3: Backend Programming
• DB Model

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