Get All MakeUpLab and Interview Events

[Anshul-Birla]

For the league, there are 2 types of additional events that people can schedule. One is make up labs and another is interview. We need a way to get all the make-up labs and all the interviews for the entire school and a specific user from the database.

The database tables look like the following:

• event_information: has basic info about the event (such as name, id)
• users: has info about users, such as userId, firstName, lastName.
• calendar_infrmation: has the actual start datetime and enddatetime, key’d by event_information_id
• commitments: maps event_infomration_id and user_id, so you know what users are committed to what events

We need to create the following routes:

GET /api/one-times-events/userId?=
This should get all make-up-lab events if the userid query param is not set. It should return the data in the following format

{
	Id: string
	startStr: string 
	endStr: string 
	Users: {
		firstName: string
		lastName: string
   }[]
}

Remember that we edit the models/openapi/models.swagger.yaml file to generate models for the api routes we are using