changeset 4054:033a8e3fec8e historization_ng

Adapted agm-import to new historization model.
author Sascha Wilde <wilde@intevation.de>
date Wed, 24 Jul 2019 17:40:17 +0200
parents d7e85b85918f
children 98e2041c7ebf
files pkg/imports/agm.go
diffstat 1 files changed, 0 insertions(+), 7 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/agm.go	Wed Jul 24 17:36:31 2019 +0200
+++ b/pkg/imports/agm.go	Wed Jul 24 17:40:17 2019 +0200
@@ -168,7 +168,6 @@
 	agmInsertSQL = `
 INSERT INTO waterway.gauge_measurements (
   location,
-  validity,
   measure_date,
   country_code,
   sender,
@@ -181,12 +180,6 @@
   staging_done
 ) VALUES (
   ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int),
-  COALESCE(
-    (SELECT validity FROM waterway.gauges
-       WHERE location
-            = ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int)
-         AND validity @> CAST($6 AS timestamp with time zone)),
-    tstzrange(NULL, NULL)),
   $6,
   $7,
   $8,