Mercurial > gemma

comparison pkg/imports/agm.go @ 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 58a28715e386
children b868cb653c4d
comparison
equal deleted inserted replaced
2119:d17a8dd1dfd3 2120:817cd8b89a86
157 value_max, 157 value_max,
158 date_info, 158 date_info,
159 source_organization 159 source_organization
160 FROM waterway.gauge_measurements 160 FROM waterway.gauge_measurements
161 WHERE 161 WHERE
162 fk_gauge_id = ($1, $2, $3, $4, $5) AND 162 fk_gauge_id = ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int) AND
163 measure_date = $6 AND staging_done` 163 measure_date = $6 AND staging_done`
164 164
165 agmInsertSQL = ` 165 agmInsertSQL = `
166 INSERT INTO waterway.gauge_measurements ( 166 INSERT INTO waterway.gauge_measurements (
167 fk_gauge_id, 167 fk_gauge_id,
178 date_info, 178 date_info,
179 source_organization, 179 source_organization,
180 is_waterlevel, 180 is_waterlevel,
181 staging_done 181 staging_done
182 ) VALUES( 182 ) VALUES(
183 ($1, $2, $3, $4, $5), 183 ($1::char(2), $2::char(3), $3::char(5), $4::char(5), $5::int),
184 $6, 184 $6,
185 $7, 185 $7,
186 $8, 186 $8,
187 $9, 187 $9,
188 $10, 188 $10,