search

skinkie / reference

Personal repository where I collect working examples to understand inner workings while building PyNeTExConv
GNU Affero General Public License v3.0
1 stars 1 forks source link

Problem with Line based data (e.g. AT) #99

Open ue71603 opened 2 months ago

ue71603 commented 2 months ago

Hi Stefan AT uses a line based NeTEx file, where each line is complete (see eMail).

This results in multiple files containing the same PSA. This then leads to an error when loading everything:

duckdb.duckdb.ConstraintException: Constraint Error: Duplicate key "id: at:vvv:PassengerStopAssignment:at-48-244-0-1:, version: any" violates primary key constraint. If this is an unexpected constraint violation please double check with the known index limitations section in our documentation (https://duckdb.org/docs/sql/indexes).

How should the software handle that (and I think we should do that). E.g. if the PSA references the same things, it should just accept it.

Do we have other elements for which this might occur?

skinkie commented 2 months ago

I would expect it could also happen for scheduled stop points.