Mercurial > gemma

changeset 2817:ff58440ce809

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added staging_done to the longterm waterlevels selections.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 27 Mar 2019 10:19:31 +0100
parents c02cebff3f16
children 89f5af7e14ad
files pkg/controllers/gauges.go
diffstat 1 files changed, 4 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/gauges.go	Tue Mar 26 19:37:55 2019 +0100
+++ b/pkg/controllers/gauges.go	Wed Mar 27 10:19:31 2019 +0100
@@ -85,7 +85,7 @@
   min(water_level) AS min,
   max(water_level) AS max
 FROM waterway.gauge_measurements, g
-WHERE fk_gauge_id = g.loc AND NOT predicted
+WHERE fk_gauge_id = g.loc AND NOT predicted AND staging_done
 GROUP BY extract(day from measure_date)::varchar || ':' ||
          extract(month from measure_date)::varchar;
 `
@@ -95,8 +95,9 @@
   water_level
 FROM waterway.gauge_measurements
 WHERE
-  NOT predicted
-  AND fk_gauge_id = (
+  NOT predicted AND
+  staging_done AND
+  fk_gauge_id = (
     $1::char(2),
     $2::char(3),
     $3::char(5),