Mercurial > gemma

diff pkg/models/sr.go @ 5585:7e8830c808ba surveysperbottleneckid

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed SR import for use of Bottleneck_Id instead of bottlenecks objnam.
author Sascha Wilde <wilde@sha-bang.de>
date Fri, 01 Apr 2022 18:51:23 +0200
parents 235cfce555b5
children 1222b777f51f
line wrap: on
line diff
--- a/pkg/models/sr.go	Fri Apr 01 16:47:53 2022 +0200
+++ b/pkg/models/sr.go	Fri Apr 01 18:51:23 2022 +0200
@@ -67,16 +67,16 @@
       ON bn.gauge_location = g.location AND $3::timestamptz <@ g.validity
     JOIN waterway.gauges_reference_water_levels rl
       ON g.location = rl.location AND g.validity = rl.validity
-  WHERE bn.objnam = $1
+  WHERE bn.bottleneck_id = $1
     AND rl.depth_reference = $2)`
 
 	checkBottleneckSQL = `
-SELECT true FROM waterway.bottlenecks WHERE objnam = $1`
+SELECT true FROM waterway.bottlenecks WHERE bottleneck_id = $1`
 
 	checkBottleneckDateUniqueSQL = `
 SELECT true FROM waterway.sounding_results sr JOIN
   waterway.bottlenecks bn ON sr.bottleneck_id = bn.bottleneck_id
-WHERE bn.objnam = $1 AND sr.date_info = $2`
+WHERE bn.bottleneck_id = $1 AND sr.date_info = $2`
 )
 
 func (m *SoundingResultMeta) Decode(r io.Reader) error {