Make CRUD SQL queries for Published Schedule table

[michellelin1]

Instructions

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

Acceptance Criteria

• GET - Returns all data from the published_schedule table
• GET/:id - Returns the row that matches the id
• POST - Adds a new row to the published_schedule 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 Select
• Postgres Insert
• Postgres Update
• Postgres Delete