Deleting the db to avoid id collisions

[laem]

Hi, I was confronted with a weird problem : while analysing routes for their frequency, I got strange results : a suppposedly school bus was apparently running on sundays.

Turns out, it was a db update problem : the GTFS I was loading every day was updated reusing serviceIds that were used by totally different routes.

My simple solution is to delete the DB. Maybe this could be a feature ?

Right now, I'm calling the DB "2024-05-12-11-14" (day hour minutes) and removing them after a successful update.

[brendannee]

If you leave the config sqlitePath empty, an in memory database will be used. This will be deleted as soon as the process is complete. Would that solve the problem you describe?

…

On Sun, May 12, 2024 at 02:14 Mael ***@***.***> wrote: Hi, I was confronted with a weird problem : while analysing routes for their frequency, I got strange results : a suppposedly school bus was apparently running on sundays. Turns out, it was a db update problem : the GTFS I was loading every day was updated reusing serviceIds that were used by totally different routes. My simple solution is to delete the DB. Maybe this could be a feature ? Right now, I'm calling the DB "2024-05-12-11-14" (day hour minutes) and removing them after a successful update. — Reply to this email directly, view it on GitHub <#161>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAXPWKBEVKMOED3DVLZR6TZB4XHLAVCNFSM6AAAAABHSUYLCSVHI2DSMVQWIX3LMV43ASLTON2WKOZSGI4TCMRUGY3TQOA> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[laem]

Not really, because I want to store the database in the filesystem to avoid reparsing the GTFS if the server crashes (or in dev mode, when I restart my server after a change).

[brendannee]

Check out the latest version https://github.com/BlinkTagInc/node-gtfs/releases/tag/4.10.3 - I added a deleteDb method: https://github.com/BlinkTagInc/node-gtfs?tab=readme-ov-file#deleting-a-database

Let me know if this doesn't work for your use case.