Mercurial > gemma

changeset 2120:817cd8b89a86

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Approved gauge measuments import: Give type hints when insertinf/querying isrs location codes.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 05 Feb 2019 12:27:40 +0100
parents d17a8dd1dfd3
children bd4370badbf7
files pkg/imports/agm.go
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/agm.go	Tue Feb 05 11:39:27 2019 +0100
+++ b/pkg/imports/agm.go	Tue Feb 05 12:27:40 2019 +0100
@@ -159,7 +159,7 @@
   source_organization
 FROM waterway.gauge_measurements
 WHERE
-  fk_gauge_id = ($1, $2, $3, $4, $5) AND
+  fk_gauge_id = ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int) AND
   measure_date = $6 AND staging_done`
 
 	agmInsertSQL = `
@@ -180,7 +180,7 @@
   is_waterlevel,
   staging_done
 ) VALUES(
-  ($1, $2, $3, $4, $5),
+  ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int),
   $6,
   $7,
   $8,