Support databases with custom triggers

MerginMaps / geodiff

Library for handling diffs for geospatial data

https://merginmaps.com

MIT License

146 stars 16 forks source link

Support databases with custom triggers #48

Open saberraz opened 4 years ago

saberraz commented 4 years ago

I have a geopackage, which users edit in QGIS/Input. When they try to submit their changes, it cannot determine the changes and creates conflict.

The changes are to data (add/remove/edit features) and there is no schema change.

PeterPetrik commented 4 years ago

does it have connected tables by foreign keys?

saberraz commented 4 years ago

Probably yes...I shares you the data.

PeterPetrik commented 4 years ago

This is caused by SpatiaLite database with some extra tables (and triggers on top of them). Geodiff reject to do a automatic rebase for databases with unknown triggers (right now it only accepts geopackage triggers)

wonder-sk commented 4 years ago

We could investigate if we can relax the current rules a bit without compromising user data, e.g.:

ignore tables / triggers that are specific to SpatiaLite - https://www.gaia-gis.it/fossil/libspatialite/wiki?name=metadata-4.0
ignore triggers on views (?)
ignore triggers on tables that are not modified (?)