diff pkg/imports/agm.go @ 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 4a7c2140e44b
children 4332b9e26e2f
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,