# HG changeset patch # User Sascha Wilde # Date 1563982222 -7200 # Node ID 0b65915757c87e0eeb59c9465f72f0c360123e15 # Parent 02d5c2e17eb8f31e85d72c0c033cf9e25322b18a Adapted gm-import to new historization model. diff -r 02d5c2e17eb8 -r 0b65915757c8 pkg/imports/gm.go --- 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,