Add a table replicating agency.txt in the static spec
Add column to the route table foreign keying into the new agency table.
Add an alert_agency many-to-many relationship
Add supporting import code to populate the new tables and the foreign key.
Add systems/<system_id>/agencies and systems/<system_id>/agencies/<agency_id> endpoints. Should alerts be shown in the list endpoint? Should routes be shown in the get agency endpoint? Should agencies be shown in the get route endpoint? Probably: no, yes, yes.
Add agency href to the root document.
Remove the agency_alerts field in the root document.
Add a table replicating
agency.txt
in the static specAdd column to the
route
table foreign keying into the newagency
table.Add an
alert_agency
many-to-many relationshipAdd supporting import code to populate the new tables and the foreign key.
Add
systems/<system_id>/agencies
andsystems/<system_id>/agencies/<agency_id>
endpoints. Should alerts be shown in the list endpoint? Should routes be shown in the get agency endpoint? Should agencies be shown in the get route endpoint? Probably: no, yes, yes.Add agency href to the root document.
Remove the
agency_alerts
field in the root document.Add end to end test.