Mercurial > gemma

diff pkg/imports/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 aaa9e658cabd
children bbc257dd9abf
line wrap: on
line diff
--- a/pkg/imports/sr.go	Fri Apr 01 16:47:53 2022 +0200
+++ b/pkg/imports/sr.go	Fri Apr 01 18:51:23 2022 +0200
@@ -145,8 +145,8 @@
   area,
   surtyp,
   zpg_exception
-) SELECT
-  bottleneck_id,
+) VALUES (
+  $1,
   $2::date,
   $3,
   (SELECT
@@ -157,8 +157,7 @@
     END),
   $7,
   $8
-FROM waterway.bottlenecks
-WHERE objnam = $1 AND validity @> CAST($2 AS timestamptz)
+)
 RETURNING
   id,
   ST_X(ST_Centroid(area::geometry)),
@@ -226,7 +225,7 @@
   JOIN waterway.bottlenecks bns
     ON grwl.location = bns.gauge_location
       AND grwl.validity @> CAST($2 AS timestamptz)
-WHERE bns.objnam = $1
+WHERE bns.bottleneck_id = $1
   AND bns.validity @> CAST($2 AS timestamptz)
   AND grwl.depth_reference like 'LDC%'
 `