Mercurial > gemma

diff pkg/imports/agm.go @ 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 ce39e9954e85
children adf355aaef57
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)`