Mercurial > gemma
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