Mercurial > gemma

diff pkg/imports/sr.go @ 4055:98e2041c7ebf historization_ng

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapted sr-import to new historization model.
author Sascha Wilde <wilde@intevation.de>
date Wed, 24 Jul 2019 18:16:27 +0200
parents 3eab3fc113b7
children 5a650cde0574
line wrap: on
line diff
--- a/pkg/imports/sr.go	Wed Jul 24 17:40:17 2019 +0200
+++ b/pkg/imports/sr.go	Wed Jul 24 18:16:27 2019 +0200
@@ -116,13 +116,11 @@
 	insertHullSQL = `
 INSERT INTO waterway.sounding_results (
   bottleneck_id,
-  bottleneck_validity,
   date_info,
   depth_reference,
   area
 ) SELECT
   bottleneck_id,
-  validity,
   $2::date,
   $3,
   (SELECT
@@ -190,7 +188,7 @@
 FROM waterway.gauges_reference_water_levels grwl
   JOIN waterway.bottlenecks bns
     ON grwl.location = bns.gauge_location
-      AND grwl.validity = bns.gauge_validity
+      AND grwl.validity @> CAST($2 AS timestamptz)
 WHERE bns.objnam = $1
   AND bns.validity @> CAST($2 AS timestamptz)
   AND grwl.depth_reference like 'LDC%'