Mercurial > gemma
diff pkg/imports/fm_bcnlat.go @ 4938:9f9d72a1d398 fairway-marks-import
Save some typos and wrong parameter counts when adding new fairway mark types
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 17 Feb 2020 14:47:54 +0100 |
parents | e41d42be0e13 |
children | 39b67b910204 |
line wrap: on
line diff
--- a/pkg/imports/fm_bcnlat.go Mon Feb 17 12:24:00 2020 +0100 +++ b/pkg/imports/fm_bcnlat.go Mon Feb 17 14:47:54 2020 +0100 @@ -80,47 +80,6 @@ } const ( - insertBCNLATSQL = ` -with a as ( - select users.current_user_area_utm() AS a -) -INSERT INTO waterway.fairway_marks_bcnlat ( - geom, - datsta, - datend, - persta, - perend, - objnam, - nobjnm, - inform, - ninfom, - scamin, - picrep, - txtdsc, - sordat, - sorind, - colour, - colpat, - condtn, - bcnshp, - catlam -) -SELECT newfm, $3, $4, $5, $6, $7, $8, $9, - $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20 - FROM ST_Transform(ST_GeomFromWKB($1, $2::integer), 4326) AS newfm (newfm) - WHERE pg_has_role('sys_admin', 'MEMBER') - OR ST_Intersects((select a from a), - ST_Transform(newfm, (select ST_SRID(a) from a))) -ON CONFLICT ( - CAST((geom, - datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom, - scamin, picrep, txtdsc, sordat, sorind, - 0, colour, colpat, condtn, bcnshp, catlam - ) AS waterway.fairway_marks_bcnlat) - ) - DO NOTHING -RETURNING id -` insertDirimpSQL = ` INSERT INTO waterway.fairway_marks_bcnlat_dirimps (fm_bcnlat_id, dirimp) VALUES ($1, $2) @@ -150,7 +109,11 @@ feedback.Info("Store fairway marks of type BCNLAT/bcnlat") - insertStmt, err := tx.PrepareContext(ctx, insertBCNLATSQL) + insertStmt, err := tx.PrepareContext( + ctx, + getFMInsertSQL("bcnlat", []string{ + "colour", "colpat", "condtn", "bcnshp", "catlam"}), + ) if err != nil { return }