# HG changeset patch # User Sascha Wilde # Date 1553788661 -3600 # Node ID 6d4f361c36e89e238166d0f86c49d4652450d65c # Parent b8972e4671faeafe1fc25d15b2101c8074ae7275 Do not delete predictions on import of agm. diff -r b8972e4671fa -r 6d4f361c36e8 pkg/imports/agm.go --- a/pkg/imports/agm.go Thu Mar 28 16:40:02 2019 +0100 +++ b/pkg/imports/agm.go Thu Mar 28 16:57:41 2019 +0100 @@ -76,8 +76,9 @@ FROM waterway.gauge_measurements o JOIN waterway.gauge_measurements n ON n.fk_gauge_id = o.fk_gauge_id AND n.measure_date = o.measure_date - WHERE n.id IN (SELECT key FROM staged) + WHERE n.id IN (SELECT key FROM staged) AND o.id NOT IN (SELECT key FROM staged) + AND NOT o.predicted ) DELETE FROM waterway.gauge_measurements WHERE id IN (SELECT id from to_delete)`