Trajectories are replaced rather than expanded about simport-learning-app

[schrooom]

This was my conclusion just now too. Changing the INSERT OR REPLACE to INSERT OR UPDATE does the trick.

[noerw]

Couldn't reproduce this previously on android, I'll test today with current develop to see if it's an iOS sqlite quirk

[noerw]

Idea: this might be a regression of the recent addition of ON DELETE CASCADE to points table in 57b553e:

simport-learning-app/src/app/shared-services/db/migrations.ts

Line 71 in 57b553e

FOREIGN KEY (trajectory) REFERENCES trajectories(id) ON DELETE CASCADE);`,

in combination with INSERT OR REPLACE on trajectory?

simport-learning-app/src/app/shared-services/db/sqlite.service.ts

Line 89 in 57b553e

'INSERT OR REPLACE INTO trajectories (id,type,placename,durationDays) VALUES (?,?,?,?)',

edit: can reproduce on android

[noerw]

fixed by #39

[schrooom]

Unfortunately this did not work as well as it seemed - now new trajectories aren't properly inserted. Working on another fix just now.