Mercurial > gemma

changeset 2850:6d4f361c36e8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Do not delete predictions on import of agm.
author Sascha Wilde <wilde@intevation.de>
date Thu, 28 Mar 2019 16:57:41 +0100
parents b8972e4671fa
children a7e31594959d
files pkg/imports/agm.go
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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)`