Make CRUD SQL queries for Catalog table

[michellelin1]

Instructions

• Write the SQL queries associated with CRUD (create, read, update, delete) routes for the catalog 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/catalog.sql
• Use question marks in place of where you would use variable data
  • ex. SELECT * FROM catalog WHERE id=?

Acceptance Criteria

• 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
  • Confirmed should be defaulted to true
• PUT - Updates an existing row given an id
  • All fields are optional
• DELETE - deletes an existing row given an id

Resources

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