Mercurial > gemma

comparison pkg/controllers/bottlenecks.go @ 4052:8ab4c6dc3d6c historization_ng

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapted loadLDCReferenceValue to new historization model.
author Sascha Wilde <wilde@intevation.de>
date Wed, 24 Jul 2019 17:35:36 +0200
parents 2f9ad89f780f
children 21854740f433
comparison
equal deleted inserted replaced
4051:0b65915757c8 4052:8ab4c6dc3d6c
81 SELECT 81 SELECT
82 grwl.value 82 grwl.value
83 FROM waterway.gauges_reference_water_levels grwl 83 FROM waterway.gauges_reference_water_levels grwl
84 JOIN waterway.bottlenecks bns 84 JOIN waterway.bottlenecks bns
85 ON grwl.location = bns.gauge_location 85 ON grwl.location = bns.gauge_location
86 AND grwl.validity = bns.gauge_validity 86 AND grwl.validity @> current_timestamp
87 WHERE bns.validity @> current_timestamp 87 WHERE bns.validity @> current_timestamp
88 AND bns.objnam = $1 88 AND bns.objnam = $1
89 AND grwl.depth_reference like 'LDC%' 89 AND grwl.depth_reference like 'LDC%'
90 ` 90 `
91 ) 91 )