HSLdevcom / jore4

Public transport registry
European Union Public License 1.2
4 stars 2 forks source link

Research: Prevent adding duplicate vehicle journeys when combining staging timetables #1447

Closed Leitsi closed 1 year ago

Leitsi commented 1 year ago

In Jore3 this has been checked during the import process. The imported (combined) timetable should not contain departures that already exist in the current timetable. Vehicle journeys should be unique by: validity start time, day type, direction, route and departure time.

Currently our database constraints do not block this case. Should either be checked in the /combine API, or at database level with constraints.

Current understanding is, that in Jore4:

Discuss in a-rinki 7.9.

https://docs.google.com/spreadsheets/d/1JtklSwIm3CxqZrkquff4rHJoeA3q2_s_0npwkrDrM5s/edit?usp=sharing

culka commented 1 year ago

Documentation added to azure wiki.