Mercurial > gemma

comparison cmd/octree2contour/store.go @ 736:34ea9d5df653

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed problem with unique constraint for countour lines.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Mon, 24 Sep 2018 11:24:42 +0200
parents 83a9f04f1759
children fb9faf2c4f60
comparison
equal deleted inserted replaced
735:83a9f04f1759 736:34ea9d5df653
19 FROM waterway.sounding_results 19 FROM waterway.sounding_results
20 WHERE bottleneck_id = $1 AND date_info = $2) 20 WHERE bottleneck_id = $1 AND date_info = $2)
21 ` 21 `
22 insertSQL = ` 22 insertSQL = `
23 INSERT INTO waterway.sounding_results_contour_lines 23 INSERT INTO waterway.sounding_results_contour_lines
24 (sounding_result_id, height, lines)
24 SELECT 25 SELECT
25 sounding_result_id, 26 id,
26 $1, 27 $1,
27 ST_Transform(ST_SetSRID(ST_GeomFromWKB($2), $3), 4326)::geography 28 ST_Transform(ST_SetSRID(ST_GeomFromWKB($2), $3), 4326)::geography
28 FROM waterway.sounding_results 29 FROM waterway.sounding_results
29 WHERE bottleneck_id = $4 AND date_info = $5 30 WHERE bottleneck_id = $4 AND date_info = $5
30 ` 31 `