We are requested to assist the gaters to count vehicles in and out of the event, collect a histogram of arrival and departures, and display a counter for how many vehicles are currently inside the city.
Technical details
Add a new table called vehicle_entries that contains the following columns:
eventid (foreign key from events)
timestamp (timedate)
direction (enum: arrival, departure)
Add a new endpoint for creation and insertion of new entry records that receives time and direction
Add a new endpoint for retrieval of current number of vehicles in the city by querying the table and subtracting departures from arrivals
Background
We are requested to assist the gaters to count vehicles in and out of the event, collect a histogram of arrival and departures, and display a counter for how many vehicles are currently inside the city.
Technical details