Mercurial > gemma

changeset 4051:0b65915757c8 historization_ng

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Adapted gm-import to new historization model.
author Sascha Wilde <wilde@intevation.de>
date Wed, 24 Jul 2019 17:30:22 +0200
parents 02d5c2e17eb8
children 8ab4c6dc3d6c
files pkg/imports/gm.go
diffstat 1 files changed, 0 insertions(+), 14 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/gm.go	Wed Jul 24 17:11:23 2019 +0200
+++ b/pkg/imports/gm.go	Wed Jul 24 17:30:22 2019 +0200
@@ -61,7 +61,6 @@
 	insertGMSQL = `
 INSERT INTO waterway.gauge_measurements (
   location,
-  validity,
   measure_date,
   sender,
   language_code,
@@ -74,12 +73,6 @@
   staging_done
 ) VALUES (
   ($1, $2, $3, $4, $5),
-  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,
@@ -98,7 +91,6 @@
 	insertGPSQL = `
 INSERT INTO waterway.gauge_predictions (
   location,
-  validity,
   measure_date,
   sender,
   language_code,
@@ -111,12 +103,6 @@
   source_organization
 ) VALUES(
   ($1, $2, $3, $4, $5),
-  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,