gemma: pkg/imports/fm.go annotate

annotate pkg/imports/fm.go @ 4958:6d5d6b27c3c3 fairway-marks-import

Added pre commit hooks before commiting fairway marks to invalidate old.

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Wed, 26 Feb 2020 12:54:33 +0100
parents	7cc79c65a9e5
children	2ab75c48e8e7

rev	line source
4948 821ae20b6a20 Re-added missing header lines. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4947 diff changeset	1 // This is Free Software under GNU Affero General Public License v >= 3.0
821ae20b6a20 Re-added missing header lines. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4947 diff changeset	2 // without warranty, see README.md and license for details.
821ae20b6a20 Re-added missing header lines. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4947 diff changeset	3 //
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	4 // SPDX-License-Identifier: AGPL-3.0-or-later
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	5 // License-Filename: LICENSES/AGPL-3.0.txt
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	6 //
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	7 // Copyright (C) 2020 by via donau
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	8 // – Österreichische Wasserstraßen-Gesellschaft mbH
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	9 // Software engineering by Intevation GmbH
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	10 //
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	11 // Author(s):
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	12 // * Tom Gottfried <tom.gottfried@intevation.de>
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	13 // * Sascha L. Teichmann <sascha.teichmann@intevation.de>
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	14
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	15 package imports
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	16
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	17 import (
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	18 "database/sql"
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	19 "fmt"
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	20 "strings"
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	21
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	22 "gemma.intevation.de/gemma/pkg/pgxutils"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	23 )
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	24
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	25 type (
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	26 // Properties common to all types of fairway marks
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	27 fairwayMarksProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	28 Datsta *string `json:"hydro_datsta"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	29 Datend *string `json:"hydro_datend"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	30 Persta *string `json:"hydro_persta"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	31 Perend *string `json:"hydro_perend"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	32 Objnam *string `json:"hydro_objnam"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	33 Nobjnm *string `json:"hydro_nobjnm"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	34 Inform *string `json:"hydro_inform"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	35 Ninfom *string `json:"hydro_ninfom"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	36 Scamin *int `json:"hydro_scamin"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	37 Picrep *string `json:"hydro_picrep"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	38 Txtdsc *string `json:"hydro_txtdsc"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	39 Sordat *string `json:"hydro_sordat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	40 Sorind *string `json:"hydro_sorind"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	41 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	42
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	43 bcnlatProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	44 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	45 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	46 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	47 Condtn *int `json:"hydro_condtn"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	48 Bcnshp *int `json:"hydro_bcnshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	49 HydroCatlam *int64 `json:"hydro_catlam,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	50 IENCCatlam *int64 `json:"ienc_catlam,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	51 Dirimp *string `json:"ienc_dirimp,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	52 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	53
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	54 boylatProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	55 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	56 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	57 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	58 Conrad *int `json:"hydro_conrad"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	59 HydroMarsys *int64 `json:"hydro_marsys,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	60 IENCMarsys *int64 `json:"ienc_marsys,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	61 Boyshp *int `json:"hydro_boyshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	62 HydroCatlam *int64 `json:"hydro_catlam,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	63 IENCCatlam *int64 `json:"ienc_catlam,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	64 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	65
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	66 boycarProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	67 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	68 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	69 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	70 Conrad *int `json:"hydro_conrad"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	71 Marsys *int `json:"hydro_marsys"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	72 Boyshp *int `json:"hydro_boyshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	73 Catcam *int `json:"hydro_catcam"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	74 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	75
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	76 boysawProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	77 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	78 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	79 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	80 Conrad *int `json:"hydro_conrad"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	81 Marsys *int64 `json:"hydro_marsys"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	82 Boyshp *int `json:"hydro_boyshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	83 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	84
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	85 boysppProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	86 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	87 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	88 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	89 Conrad *int `json:"hydro_conrad"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	90 Marsys *int64 `json:"hydro_marsys"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	91 Boyshp *int `json:"hydro_boyshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	92 Catspm *string `json:"hydro_catspm"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	93 }
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	94
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	95 daymarProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	96 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	97 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	98 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	99 Condtn *int `json:"hydro_condtn"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	100 Dirimp *string `json:"ienc_dirimp,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	101 Topshp *int `json:"hydro_topshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	102 Orient *float64 `json:"hydro_orient,omitempty"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	103 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	104
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	105 lightsProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	106 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	107 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	108 Condtn *int `json:"hydro_condtn"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	109 Orient *float64 `json:"hydro_orient"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	110 Catlit *string `json:"hydro_catlit"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	111 Exclit *int `json:"hydro_exclit"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	112 Litchr *int `json:"hydro_litchr"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	113 Litvis *string `json:"hydro_litvis"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	114 Mltylt *int `json:"hydro_mltylt"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	115 Sectr1 *float64 `json:"hydro_sectr1"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	116 Sectr2 *float64 `json:"hydro_sectr2"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	117 Siggrp *string `json:"hydro_siggrp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	118 Sigper *float64 `json:"hydro_sigper"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	119 Sigseq *string `json:"hydro_sigseq"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	120 Status *string `json:"hydro_status"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	121 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	122
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	123 notmrkProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	124 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	125 Condtn *int `json:"hydro_condtn"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	126 Marsys *int `json:"hydro_bcnshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	127 Dirimp *string `json:"ienc_dirimp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	128 Orient *float64 `json:"hydro_orient"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	129 Status *string `json:"hydro_status"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	130 Addmrk *string `json:"ienc_addmrk"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	131 Catnmk *int `json:"ienc_catnmk"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	132 Disipd *float64 `json:"ienc_disipd"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	133 Disipu *float64 `json:"ienc_disipu"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	134 Disbk1 *float64 `json:"ienc_disbk1"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	135 Disbk2 *float64 `json:"ienc_disbk2"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	136 Fnctnm *int `json:"ienc_fnctnm"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	137 Bnkwtw *int `json:"ienc_bnkwtw"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	138 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	139
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	140 rtpbcnProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	141 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	142 Condtn *int `json:"hydro_condtn"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	143 Siggrp *string `json:"hydro_siggrp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	144 Catrtb *int `json:"hydro_catrtb"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	145 Radwal *string `json:"hydro_radwal"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	146 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	147
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	148 topmarProperties struct {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	149 fairwayMarksProperties
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	150 Colour *string `json:"hydro_colour"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	151 Colpat *string `json:"hydro_colpat"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	152 Condtn *int `json:"hydro_condtn"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	153 Topshp *int `json:"hydro_topshp"`
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	154 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	155 )
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	156
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	157 const (
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	158 BCNLATJobKind JobKind = "fm_bcnlat"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	159 BOYLATJobKind JobKind = "fm_boylat"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	160 BOYCARJobKind JobKind = "fm_boycar"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	161 BOYSAWJobKind JobKind = "fm_boysaw"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	162 BOYSPPJobKind JobKind = "fm_boyspp"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	163 DAYMARJobKind JobKind = "fm_daymar"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	164 LIGHTSJobKind JobKind = "fm_lights"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	165 NOTMRKJobKind JobKind = "fm_notmrk"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	166 RTPBCNJobKind JobKind = "fm_rtpbcn"
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	167 TOPMARJobKind JobKind = "fm_topmar"
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	168 )
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	169
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	170 func init() {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	171 RegisterJobCreator(BCNLATJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	172 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	173 description: "fairway marks bcnlat",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	174 depends: [2][]string{{"fairway_marks_bcnlat"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	175 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	176 prepareStmnts(
4952 73652819c56e Fix table name suffix Tom Gottfried <tom@intevation.de> parents: 4948 diff changeset	177 createInsertFMSQL("bcnlat",
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	178 "colour", "colpat", "condtn", "bcnshp", "catlam"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	179 insertBcnlatDirimpSQL,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	180 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	181 consumeBCNLAT,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	182 createInvalidation("bcnlat"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	183 func() interface{} { return new(bcnlatProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	184 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	185 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	186
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	187 RegisterJobCreator(BOYLATJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	188 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	189 description: "fairway marks boylat",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	190 depends: [2][]string{{"fairway_marks_boylat"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	191 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	192 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	193 createInsertFMSQL("boylat",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	194 "colour", "colpat", "conrad",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	195 "marsys", "boyshp", "catlam"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	196 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	197 consumeBOYLAT,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	198 createInvalidation("boylat"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	199 func() interface{} { return new(boylatProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	200 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	201 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	202
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	203 RegisterJobCreator(BOYCARJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	204 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	205 description: "fairway marks boycar",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	206 depends: [2][]string{{"fairway_marks_boycar"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	207 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	208 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	209 createInsertFMSQL("boycar",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	210 "colour", "colpat", "conrad",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	211 "marsys", "boyshp", "catcam"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	212 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	213 consumeBOYCAR,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	214 createInvalidation("boycar"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	215 func() interface{} { return new(boycarProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	216 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	217 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	218
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	219 RegisterJobCreator(BOYSAWJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	220 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	221 description: "fairway marks boysaw",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	222 depends: [2][]string{{"fairway_marks_boysaw"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	223 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	224 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	225 createInsertFMSQL("boysaw",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	226 "colour", "colpat", "conrad", "marsys", "boyshp"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	227 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	228 consumeBOYSAW,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	229 createInvalidation("boysaw"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	230 func() interface{} { return new(boysawProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	231 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	232 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	233
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	234 RegisterJobCreator(BOYSPPJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	235 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	236 description: "fairway marks boyspp",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	237 depends: [2][]string{{"fairway_marks_boyspp"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	238 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	239 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	240 createInsertFMSQL("boyspp",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	241 "colour", "colpat", "conrad",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	242 "marsys", "boyshp", "catspm"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	243 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	244 consumeBOYSPP,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	245 createInvalidation("boyspp"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	246 func() interface{} { return new(boysppProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	247 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	248 })
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	249
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	250 RegisterJobCreator(DAYMARJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	251 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	252 description: "fairway marks daymar",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	253 depends: [2][]string{{"fairway_marks_daymar"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	254 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	255 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	256 createInsertFMSQL("daymar",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	257 "colour", "colpat", "condtn", "topshp", "orient"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	258 insertDaymarDirimpSQL,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	259 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	260 consumeDAYMAR,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	261 createInvalidation("daymar"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	262 func() interface{} { return new(daymarProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	263 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	264 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	265
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	266 RegisterJobCreator(LIGHTSJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	267 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	268 description: "fairway marks lights",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	269 depends: [2][]string{{"fairway_marks_lights"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	270 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	271 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	272 createInsertFMSQL("lights",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	273 "colour", "condtn", "orient",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	274 "catlit", "exclit", "litchr",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	275 "litvis", "mltylt", "sectr1",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	276 "sectr2", "siggrp", "sigper",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	277 "sigseq", "status"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	278 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	279 consumeLIGHTS,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	280 createInvalidation("lights"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	281 func() interface{} { return new(lightsProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	282 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	283 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	284
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	285 RegisterJobCreator(NOTMRKJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	286 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	287 description: "fairway marks notmrk",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	288 depends: [2][]string{{"fairway_marks_lights"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	289 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	290 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	291 createInsertFMSQL("notmrk",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	292 "condtn", "marsys", "orient",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	293 "status", "addmrk", "catnmk",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	294 "disipd", "disipu", "disbk1",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	295 "disbk2", "fnctnm", "bnkwtw"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	296 insertNotmrkDirimpSQL,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	297 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	298 consumeNOTMRK,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	299 createInvalidation("notmark"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	300 func() interface{} { return new(notmrkProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	301 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	302 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	303
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	304 RegisterJobCreator(RTPBCNJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	305 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	306 description: "fairway marks rtpbcn",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	307 depends: [2][]string{{"fairway_marks_rtpbcn"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	308 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	309 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	310 createInsertFMSQL("rtpbcn",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	311 "condtn", "siggrp", "catrtb", "radwal"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	312 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	313 consumeRTPBCN,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	314 createInvalidation("rtpbcn"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	315 func() interface{} { return new(rtpbcnProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	316 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	317 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	318
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	319 RegisterJobCreator(TOPMARJobKind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	320 &PointWFSJobCreator{
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	321 description: "fairway marks topmar",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	322 depends: [2][]string{{"fairway_marks_topmar"}, {}},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	323 newConsumer: newSQLConsumer(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	324 prepareStmnts(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	325 createInsertFMSQL("topmar",
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	326 "colour", "colpat", "condtn", "topshp"),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	327 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	328 consumeTOPMAR,
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	329 createInvalidation("topmar"),
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	330 func() interface{} { return new(topmarProperties) },
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	331 ),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	332 })
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	333 }
8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	334
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	335 const (
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	336 // Format string to be completed with type and additional attributes
4956 7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	337 /* Instead of the row comparisons in the WHERE clauses
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	338 of the CTE with the UPDATE and the INSERT ... SELECT, we could have
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	339 used the row-based UNIQUE indexes as arbiter indexes
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	340 in an INSERT ... ON CONFLICT ... DO UPDATE, but that turned out
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	341 to be able to bypass the UNIQUE index in some cases.
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	342 */
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	343 insertFMSQLtmpl = `
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	344 WITH a AS (
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	345 SELECT users.current_user_area_utm() AS a
4956 7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	346 ),
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	347 g AS (
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	348 SELECT newfm
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	349 FROM ST_Transform(ST_GeomFromWKB($1, $2::integer), 4326) AS newfm (newfm)
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	350 WHERE pg_has_role('sys_admin', 'MEMBER')
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	351 OR ST_Intersects((select a from a),
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	352 ST_Transform(newfm, (select ST_SRID(a) from a)))
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	353 ),
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	354 t AS (
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	355 -- Currently valid and otherwise identical entry's validity.
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	356 /* If there are no intermittent updates of validity,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	357 there will always be only one currently valid and
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	358 otherwise identical entry. */
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	359 UPDATE waterway.fairway_marks_%[1]s SET last_found = current_timestamp
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	360 WHERE validity @> current_timestamp
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	361 AND (geom,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	362 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	363 scamin, picrep, txtdsc, sordat, sorind,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	364 %[2]s
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	365 ) IS NOT DISTINCT FROM (
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	366 (SELECT newfm FROM g),
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	367 $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	368 %[3]s)
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	369 RETURNING validity
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	370 )
4956 7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	371 INSERT INTO waterway.fairway_marks_%[1]s (
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	372 geom,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	373 datsta,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	374 datend,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	375 persta,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	376 perend,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	377 objnam,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	378 nobjnm,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	379 inform,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	380 ninfom,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	381 scamin,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	382 picrep,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	383 txtdsc,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	384 sordat,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	385 sorind,
4956 7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	386 %[2]s
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	387 )
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	388 SELECT newfm, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
4956 7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	389 %[3]s
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	390 FROM g
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	391 WHERE NOT EXISTS(SELECT 1 FROM waterway.fairway_marks_%[1]s
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	392 WHERE (
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	393 validity, geom,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	394 datsta, datend, persta, perend, objnam, nobjnm, inform, ninfom,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	395 scamin, picrep, txtdsc, sordat, sorind,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	396 %[2]s
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	397 ) IS NOT DISTINCT FROM (
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	398 (SELECT validity FROM t), newfm,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	399 $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15,
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	400 %[3]s
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	401 )
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	402 )
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	403 RETURNING id
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	404 `
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	405
4956 7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	406 // Assume validity ended for all entries not found in data source
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	407 // TODO: Apply this query after looping over all entries in data source
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	408 invalidateFairwayMarksSQLtmpl = `
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	409 WITH
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	410 a AS (
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	411 SELECT users.current_user_area_utm() AS a
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	412 )
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	413 UPDATE waterway.fairway_marks_%s
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	414 SET validity = tstzrange(lower(validity), current_timestamp)
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	415 WHERE validity @> current_timestamp
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	416 AND last_found < current_timestamp
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	417 AND (pg_has_role('sys_admin', 'MEMBER')
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	418 OR ST_Intersects((select a from a),
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	419 ST_Transform(CAST(geom AS geometry), (select ST_SRID(a) from a))))
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	420 `
7cc79c65a9e5 Keep the history of fairway marks Tom Gottfried <tom@intevation.de> parents: 4952 diff changeset	421
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	422 insertBcnlatDirimpSQL = `
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	423 INSERT INTO waterway.fairway_marks_bcnlat_dirimps (fm_bcnlat_id, dirimp)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	424 VALUES ($1, $2)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	425 `
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	426
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	427 insertDaymarDirimpSQL = `
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	428 INSERT INTO waterway.fairway_marks_daymar_dirimps (fm_daymar_id, dirimp)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	429 VALUES ($1, $2)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	430 `
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	431
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	432 insertNotmrkDirimpSQL = `
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	433 INSERT INTO waterway.fairway_marks_notmrk_dirimps (fm_notmrk_id, dirimp)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	434 VALUES ($1, $2)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	435 `
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	436 )
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	437
4958 6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	438 func createInvalidation(fmType string) func(*SQLPointConsumer) error {
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	439
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	440 invalidateFairwayMarksSQL := fmt.Sprintf(invalidateFairwayMarksSQLtmpl, fmType)
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	441
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	442 return func(spc *SQLPointConsumer) error {
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	443 res, err := spc.tx.ExecContext(spc.ctx, invalidateFairwayMarksSQL)
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	444 if err != nil {
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	445 return err
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	446 }
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	447 nOld, err := res.RowsAffected()
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	448 if err != nil {
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	449 return err
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	450 }
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	451 spc.feedback.Info("Number of features removed from data source: %d", nOld)
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	452 return nil
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	453 }
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	454 }
6d5d6b27c3c3 Added pre commit hooks before commiting fairway marks to invalidate old. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4956 diff changeset	455
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	456 // Create INSERT statement for specific fairway marks type
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	457 func createInsertFMSQL(fmType string, attributes ...string) string {
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	458 attNums := "$16"
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	459 for i := 1; i < len(attributes); i++ {
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	460 attNums += fmt.Sprintf(",$%d", 16+i)
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	461 }
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	462
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	463 return fmt.Sprintf(
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	464 insertFMSQLtmpl,
4938 9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	465 fmType,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	466 strings.Join(attributes, ","),
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	467 attNums,
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	468 )
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	469 }
9f9d72a1d398 Save some typos and wrong parameter counts when adding new fairway mark types Tom Gottfried <tom@intevation.de> parents: 4931 diff changeset	470
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	471 func coalesceInt64(ints ...*int64) sql.NullInt64 {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	472 for _, i := range ints {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	473 if i != nil {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	474 return sql.NullInt64{Int64: *i, Valid: true}
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	475 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	476 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	477 return sql.NullInt64{}
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	478 }
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	479
4947 407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	480 func storeAttribs(spc SQLPointConsumer, id int64, attrs string) {
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	481 if attrs == nil \|\| *attrs == "" {
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	482 return
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	483 }
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	484 dirimps := strings.Split(*attrs, ",")
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	485 for _, dirimp := range dirimps {
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	486 if err := spc.savepoint(func() error {
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	487 _, err := spc.stmts[1].ExecContext(
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	488 spc.ctx, id, dirimp)
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	489 return err
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	490 }); err != nil {
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	491 spc.feedback.Warn(
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	492 pgxutils.ReadableError{Err: err}.Error())
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	493 spc.feedback.Info(
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	494 "Tried to import '%s' as dirimp value",
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	495 dirimp)
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	496 }
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	497 }
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	498 }
407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	499
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	500 func consumeBCNLAT(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	501 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	502 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	503 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	504 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	505 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	506 props := properties.(*bcnlatProperties)
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	507
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	508 catlam := coalesceInt64(props.HydroCatlam, props.IENCCatlam)
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	509
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	510 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	511 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	512 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	513 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	514 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	515 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	516 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	517 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	518 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	519 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	520 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	521 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	522 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	523 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	524 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	525 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	526 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	527 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	528 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	529 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	530 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	531 props.Condtn,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	532 props.Bcnshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	533 catlam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	534 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	535 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	536 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	537 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	538 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	539 // ignore -> filtered by responsibility area or a duplicate
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	540 // TODO: handle eventual changes to dirimp
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	541 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	542 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	543 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	544 default:
4947 407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	545 storeAttribs(spc, fmid, props.Dirimp)
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	546 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	547 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	548 }
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	549
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	550 func consumeBOYLAT(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	551 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	552 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	553 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	554 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	555 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	556 props := properties.(*boylatProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	557
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	558 marsys := coalesceInt64(props.HydroMarsys, props.IENCMarsys)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	559 catlam := coalesceInt64(props.HydroCatlam, props.IENCCatlam)
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	560
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	561 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	562 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	563 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	564 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	565 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	566 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	567 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	568 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	569 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	570 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	571 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	572 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	573 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	574 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	575 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	576 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	577 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	578 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	579 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	580 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	581 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	582 props.Conrad,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	583 marsys,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	584 props.Boyshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	585 catlam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	586 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	587 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	588 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	589 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	590 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	591 // ignore -> filtered by responsibility_areas
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	592 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	593 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	594 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	595 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	596 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	597 }
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	598
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	599 func consumeBOYCAR(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	600 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	601 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	602 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	603 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	604 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	605 props := properties.(*boycarProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	606 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	607 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	608 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	609 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	610 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	611 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	612 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	613 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	614 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	615 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	616 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	617 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	618 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	619 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	620 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	621 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	622 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	623 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	624 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	625 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	626 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	627 props.Conrad,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	628 props.Marsys,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	629 props.Boyshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	630 props.Catcam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	631 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	632 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	633 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	634 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	635 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	636 // ignore -> filtered by responsibility_areas
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	637 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	638 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	639 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	640 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	641 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	642 }
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	643
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	644 func consumeBOYSAW(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	645 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	646 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	647 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	648 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	649 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	650 props := properties.(*boysawProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	651 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	652 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	653 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	654 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	655 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	656 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	657 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	658 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	659 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	660 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	661 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	662 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	663 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	664 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	665 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	666 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	667 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	668 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	669 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	670 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	671 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	672 props.Conrad,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	673 props.Marsys,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	674 props.Boyshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	675 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	676 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	677 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	678 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	679 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	680 // ignore -> filtered by responsibility_areas
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	681 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	682 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	683 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	684 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	685 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	686 }
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	687
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	688 func consumeBOYSPP(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	689 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	690 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	691 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	692 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	693 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	694 props := properties.(*boysppProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	695 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	696 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	697 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	698 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	699 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	700 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	701 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	702 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	703 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	704 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	705 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	706 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	707 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	708 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	709 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	710 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	711 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	712 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	713 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	714 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	715 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	716 props.Conrad,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	717 props.Marsys,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	718 props.Boyshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	719 props.Catspm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	720 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	721 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	722 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	723 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	724 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	725 // ignore -> filtered by responsibility_areas
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	726 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	727 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	728 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	729 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	730 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	731 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	732
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	733 func consumeDAYMAR(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	734 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	735 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	736 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	737 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	738 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	739 props := properties.(*daymarProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	740
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	741 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	742 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	743 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	744 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	745 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	746 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	747 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	748 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	749 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	750 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	751 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	752 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	753 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	754 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	755 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	756 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	757 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	758 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	759 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	760 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	761 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	762 props.Condtn,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	763 props.Topshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	764 props.Orient,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	765 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	766 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	767 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	768 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	769 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	770 // ignore -> filtered by responsibility area or a duplicate
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	771 // TODO: handle eventual changes to dirimp
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	772 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	773 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	774 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	775 default:
4947 407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	776 storeAttribs(spc, fmid, props.Dirimp)
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	777 }
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	778 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	779 }
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	780
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	781 func consumeLIGHTS(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	782 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	783 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	784 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	785 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	786 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	787 props := properties.(*lightsProperties)
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	788
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	789 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	790 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	791 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	792 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	793 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	794 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	795 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	796 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	797 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	798 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	799 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	800 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	801 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	802 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	803 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	804 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	805 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	806 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	807 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	808 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	809 props.Condtn,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	810 props.Orient,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	811 props.Catlit,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	812 props.Exclit,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	813 props.Litchr,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	814 props.Litvis,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	815 props.Mltylt,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	816 props.Sectr1,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	817 props.Sectr2,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	818 props.Siggrp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	819 props.Sigper,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	820 props.Sigseq,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	821 props.Status,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	822 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	823 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	824 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	825 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	826 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	827 // ignore -> filtered by responsibility area or a duplicate
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	828 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	829 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	830 return ErrFeatureIgnored
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	831 }
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	832 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	833 }
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	834
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	835 func consumeNOTMRK(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	836 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	837 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	838 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	839 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	840 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	841 props := properties.(*notmrkProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	842 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	843 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	844 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	845 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	846 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	847 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	848 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	849 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	850 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	851 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	852 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	853 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	854 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	855 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	856 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	857 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	858 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	859 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	860 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	861 props.Condtn,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	862 props.Marsys,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	863 props.Orient,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	864 props.Status,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	865 props.Addmrk,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	866 props.Catnmk,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	867 props.Disipd,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	868 props.Disipu,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	869 props.Disbk1,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	870 props.Disbk2,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	871 props.Fnctnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	872 props.Bnkwtw,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	873 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	874 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	875 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	876 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	877 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	878 // ignore -> filtered by responsibility area or a duplicate
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	879 // TODO: handle eventual changes to dirimp
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	880 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	881 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	882 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	883 default:
4947 407103c299a0 De-duped some attribute storing code in FM imports. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4946 diff changeset	884 storeAttribs(spc, fmid, props.Dirimp)
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	885 }
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	886 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	887 }
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	888
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	889 func consumeRTPBCN(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	890 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	891 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	892 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	893 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	894 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	895 props := properties.(*rtpbcnProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	896 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	897 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	898 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	899 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	900 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	901 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	902 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	903 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	904 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	905 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	906 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	907 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	908 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	909 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	910 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	911 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	912 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	913 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	914 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	915 props.Condtn,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	916 props.Siggrp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	917 props.Catrtb,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	918 props.Radwal,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	919 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	920 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	921 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	922 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	923 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	924 // ignore -> filtered by responsibility area or a duplicate
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	925 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	926 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	927 return ErrFeatureIgnored
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	928 }
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	929 return nil
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	930 }
4931 e41d42be0e13 One more callback to avoid code duplication more consequently Tom Gottfried <tom@intevation.de> parents: 4907 diff changeset	931
4946 b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	932 func consumeTOPMAR(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	933 spc *SQLPointConsumer,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	934 points pointSlice,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	935 properties interface{},
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	936 epsg int,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	937 ) error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	938 props := properties.(*topmarProperties)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	939 var fmid int64
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	940 err := spc.savepoint(func() error {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	941 return spc.stmts[0].QueryRowContext(
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	942 spc.ctx,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	943 points.asWKB(),
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	944 epsg,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	945 props.Datsta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	946 props.Datend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	947 props.Persta,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	948 props.Perend,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	949 props.Objnam,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	950 props.Nobjnm,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	951 props.Inform,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	952 props.Ninfom,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	953 props.Scamin,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	954 props.Picrep,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	955 props.Txtdsc,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	956 props.Sordat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	957 props.Sorind,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	958 props.Colour,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	959 props.Colpat,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	960 props.Condtn,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	961 props.Topshp,
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	962 ).Scan(&fmid)
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	963 })
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	964 switch {
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	965 case err == sql.ErrNoRows:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	966 return ErrFeatureDuplicated
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	967 // ignore -> filtered by responsibility area or a duplicate
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	968 case err != nil:
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	969 spc.feedback.Error(pgxutils.ReadableError{Err: err}.Error())
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	970 return ErrFeatureIgnored
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	971 }
b0dbc0f2c748 Simplified importing of fairway marks. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4939 diff changeset	972 return nil
4894 8eb36d0d5bdf Draft implementation of fairway marks import Tom Gottfried <tom@intevation.de> parents: diff changeset	973 }

Mercurial > gemma

annotate pkg/imports/fm.go @ 4958:6d5d6b27c3c3 fairway-marks-import