# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1563982817 -7200
# Node ID 033a8e3fec8e22e5238e7fa6698107b201e2d953
# Parent  d7e85b85918fe7870b66733e2b458a6551af7cf5
Adapted agm-import to new historization model.

diff -r d7e85b85918f -r 033a8e3fec8e pkg/imports/agm.go
--- 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,