changeset 4701:ef2cf9c413e9

Merged
author Sascha Wilde <wilde@intevation.de>
date Wed, 16 Oct 2019 16:51:09 +0200
parents a0c320d89682 (diff) a130b5e55ffc (current diff)
children ef21c1464843
files
diffstat 2 files changed, 7 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/bottlenecks.go	Wed Oct 16 16:48:20 2019 +0200
+++ b/pkg/controllers/bottlenecks.go	Wed Oct 16 16:51:09 2019 +0200
@@ -84,8 +84,9 @@
 FROM waterway.gauges_reference_water_levels grwl
   JOIN waterway.bottlenecks bns
     ON grwl.location = bns.gauge_location
-      AND grwl.validity @> current_timestamp
-WHERE bns.validity @> current_timestamp
+      AND grwl.validity @> COALESCE(upper(bns.validity), current_timestamp)
+WHERE lower(bns.validity) = (SELECT max(lower(validity))
+                             FROM waterway.bottlenecks WHERE objnam = $1)
   AND bns.objnam = $1
   AND grwl.depth_reference like 'LDC%'
 `
--- a/pkg/controllers/stretches.go	Wed Oct 16 16:48:20 2019 +0200
+++ b/pkg/controllers/stretches.go	Wed Oct 16 16:51:09 2019 +0200
@@ -100,6 +100,10 @@
 		return nil, err
 	}
 
+	if len(ldc) == 0 {
+		return nil, fmt.Errorf("No LDC found for bottleneck: %s", bn.name)
+	}
+
 	var access func(*availMeasurement) float64
 	var breaks []float64