gemma: pkg/controllers/system.go annotate

annotate pkg/controllers/system.go @ 4214:49564382ffff

Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed.

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Fri, 16 Aug 2019 13:15:34 +0200
parents	45be361f2d48
children	8aff98c84a5a

rev	line source
1017 a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	1 // This is Free Software under GNU Affero General Public License v >= 3.0
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	2 // without warranty, see README.md and license for details.
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	3 //
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	4 // SPDX-License-Identifier: AGPL-3.0-or-later
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	5 // License-Filename: LICENSES/AGPL-3.0.txt
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	6 //
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	7 // Copyright (C) 2018 by via donau
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	8 // – Österreichische Wasserstraßen-Gesellschaft mbH
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	9 // Software engineering by Intevation GmbH
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	10 //
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	11 // Author(s):
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	12 // * Sascha Wilde <sascha.wilde@intevation.de>
a244b18cb916 Added GNU Affero General Public License. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 854 diff changeset	13
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	14 package controllers
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	15
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	16 import (
3104 19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	17 "bytes"
3929 45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	18 "context"
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	19 "database/sql"
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	20 "fmt"
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	21 "io/ioutil"
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	22 "log"
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	23 "net/http"
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	24 "strings"
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	25 "sync"
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	26 "time"
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	27
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	28 "github.com/gorilla/mux"
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	29
3929 45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	30 "gemma.intevation.de/gemma/pkg/auth"
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	31 "gemma.intevation.de/gemma/pkg/common"
3104 19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	32 "gemma.intevation.de/gemma/pkg/config"
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	33 "gemma.intevation.de/gemma/pkg/geoserver"
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	34 "gemma.intevation.de/gemma/pkg/imports"
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	35 "gemma.intevation.de/gemma/pkg/models"
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	36 )
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	37
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	38 const (
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	39 getFeatureColourSQL = `SELECT r,g,b,a
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	40 FROM systemconf.feature_colours
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	41 WHERE feature_name = $1 AND style_attr = $2`
846 6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	42 setFeatureColourSQL = `UPDATE systemconf.feature_colours
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	43 SET (r, g, b, a) = ($3, $4, $5, $6)
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	44 WHERE feature_name = $1 AND style_attr = $2`
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	45
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	46 getSettingsSQL = `
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	47 SELECT config_key, config_val
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	48 FROM sys_admin.system_config`
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	49
3834 d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	50 getConfigSQL = `
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	51 SELECT config_val
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	52 FROM sys_admin.system_config
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	53 WHERE config_key = $1`
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	54
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	55 updateSettingSQL = `
3630 2467e619cf67 Fixed more SQL typos. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3629 diff changeset	56 INSERT INTO sys_admin.system_config (config_key, config_val)
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	57 VALUES ($1, $2)
3629 1825a1bc9fb1 Fixed typo in SQL statement. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3628 diff changeset	58 ON CONFLICT (config_key) DO UPDATE SET config_val = $2`
3929 45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	59
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	60 deleteSoundingDiffsSQL = `
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	61 DELETE FROM caching.sounding_differences`
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	62 )
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	63
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	64 // System status end points
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	65
722 815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	66 func showSystemLog(
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	67 _ interface{}, req *http.Request,
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	68 _ *sql.Conn,
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	69 ) (jr JSONResult, err error) {
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	70
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	71 serviceName := mux.Vars(req)["service"]
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	72 fileName := mux.Vars(req)["file"]
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	73
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	74 // The following check is currently most likely unnecessary as I wasn't
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	75 // able to inject a verbatim '/' via the middleware, but better be on
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	76 // the safe site...
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	77 if strings.Contains(fileName, "/") {
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	78 err = JSONError{http.StatusBadRequest,
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	79 "error: no slashes allowed in file name"}
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	80 return
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	81 }
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	82
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	83 var path string
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	84
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	85 switch serviceName {
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	86 case "apache2", "postgresql":
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	87 path = "/var/log/" + serviceName + "/" + fileName
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	88 default:
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	89 err = JSONError{http.StatusBadRequest,
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	90 "error: invalid service: " + serviceName}
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	91 return
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	92 }
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	93
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	94 var txt []byte
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	95
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	96 if txt, err = ioutil.ReadFile(path); err != nil {
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	97 return
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	98 }
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	99
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	100 jr = JSONResult{
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	101 Result: struct {
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	102 Path string `json:"path"`
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	103 Content string `json:"content"`
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	104 }{path, string(txt)},
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	105 }
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	106 return
815f5e2ed974 Added simple endpoint to view system logs. Sascha Wilde <wilde@intevation.de> parents: diff changeset	107 }
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	108
3104 19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	109 func getSystemConfig(
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	110 _ interface{}, req *http.Request,
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	111 _ *sql.Conn,
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	112 ) (jr JSONResult, err error) {
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	113
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	114 cfg := config.PublishedConfig()
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	115 if cfg == "" {
3108 8a4fb02ee60a Send empty JSON document when calling GET /api/system/config and "published-config" is not configure. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3104 diff changeset	116 jr = JSONResult{Result: strings.NewReader("{}")}
3104 19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	117 return
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	118 }
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	119
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	120 var data []byte
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	121 if data, err = ioutil.ReadFile(cfg); err != nil {
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	122 return
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	123 }
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	124
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	125 jr = JSONResult{Result: bytes.NewReader(data)}
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	126 return
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	127 }
19fc84a98479 Added "published-config" field to configuration. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 1017 diff changeset	128
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	129 func getSystemSettings(
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	130 _ interface{},
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	131 req *http.Request,
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	132 conn *sql.Conn,
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	133 ) (jr JSONResult, err error) {
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	134
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	135 var rows *sql.Rows
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	136 if rows, err = conn.QueryContext(req.Context(), getSettingsSQL); err != nil {
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	137 return
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	138 }
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	139 defer rows.Close()
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	140
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	141 settings := map[string]string{}
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	142
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	143 for rows.Next() {
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	144 var key, val string
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	145 if err = rows.Scan(&key, &val); err != nil {
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	146 return
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	147 }
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	148 settings[key] = val
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	149 }
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	150 if err = rows.Err(); err != nil {
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	151 return
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	152 }
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	153
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	154 jr = JSONResult{Result: settings}
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	155 return
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	156 }
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	157
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	158 type reconfFunc func(sql.NullString, string) (func(*http.Request), error)
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	159
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	160 var (
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	161 reconfigureFuncsMu sync.Mutex
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	162 reconfigureFuncs = map[string]reconfFunc{}
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	163 )
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	164
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	165 func registerReconfigureFunc(key string, fn reconfFunc) {
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	166 reconfigureFuncsMu.Lock()
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	167 defer reconfigureFuncsMu.Unlock()
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	168 reconfigureFuncs[key] = fn
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	169 }
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	170
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	171 func reconfigureFunc(key string) reconfFunc {
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	172 reconfigureFuncsMu.Lock()
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	173 defer reconfigureFuncsMu.Unlock()
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	174 return reconfigureFuncs[key]
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	175 }
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	176
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	177 func reconfigureClassBreaks(
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	178 old sql.NullString, curr,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	179 which string,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	180 recalc func(*http.Request),
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	181 ) (func(*http.Request), error) {
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	182
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	183 // If new values are broken, don't proceed.
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	184 currCVs, err := models.ParseColorValues(curr)
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	185 if err != nil {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	186 return nil, err
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	187 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	188
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	189 doBoth := func(req *http.Request) {
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	190 log.Printf("info: Trigger re-calculation of %s.", which)
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	191 geoserver.ReconfigureStyle(which)
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	192 recalc(req)
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	193 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	194
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	195 if !old.Valid {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	196 return doBoth, nil
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	197 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	198
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	199 oldCVs, err := models.ParseColorValues(old.String)
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	200 if err != nil {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	201 log.Printf("warn: old config value is broken: %v\n", err)
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	202 return doBoth, nil
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	203 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	204
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	205 if len(currCVs) != len(oldCVs) {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	206 return doBoth, nil
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	207 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	208
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	209 colorChanged := false
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	210
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	211 for i := range currCVs {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	212 if currCVs[i].Value != oldCVs[i].Value {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	213 return doBoth, nil
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	214 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	215 if currCVs[i].Color != oldCVs[i].Color {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	216 colorChanged = true
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	217 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	218 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	219
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	220 // Only the color changed -> no expensive recalc needed.
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	221 if colorChanged {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	222 log.Println("info: Only colors changed.")
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	223 return func(*http.Request) { geoserver.ReconfigureStyle(which) }, nil
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	224 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	225
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	226 return nil, nil
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	227 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	228
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	229 func init() {
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	230 registerReconfigureFunc("morphology_classbreaks",
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	231 func(old sql.NullString, curr string) (func(*http.Request), error) {
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	232 return reconfigureClassBreaks(
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	233 old, curr,
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	234 "sounding_results_contour_lines_geoserver",
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	235 func(req *http.Request) {
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	236 if s, ok := auth.GetSession(req); ok {
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	237 triggerSoundingResultsContoursRecalc(s.User, curr)
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	238 }
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	239 })
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	240 })
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	241 registerReconfigureFunc("morphology_classbreaks_compare",
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	242 func(old sql.NullString, curr string) (func(*http.Request), error) {
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	243 return reconfigureClassBreaks(
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	244 old, curr,
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	245 "sounding_differences",
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	246 func(*http.Request) { go deleteSoundingDiffs() })
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	247 })
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	248 }
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	249
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	250 func triggerSoundingResultsContoursRecalc(who, breaks string) {
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	251 var serialized string
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	252 job := &imports.IsoRefresh{ClassBreaks: breaks}
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	253 serialized, err := common.ToJSONString(job)
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	254 if err != nil {
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	255 log.Printf("error: %v\n", err)
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	256 return
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	257 }
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	258 var jobID int64
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	259 if jobID, err = imports.AddJob(
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	260 imports.ISRJobKind,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	261 time.Time{},
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	262 nil,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	263 nil,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	264 who,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	265 false,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	266 serialized,
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	267 ); err != nil {
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	268 log.Printf("error: %v\n", err)
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	269 return
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	270 }
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	271 log.Printf(
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	272 "info: Recalculate sounding results contours in job %d.\n",
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	273 jobID)
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	274
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	275 }
49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	276
3929 45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	277 func deleteSoundingDiffs() {
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	278 // TODO: Better do that in import queue?
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	279 ctx := context.Background()
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	280
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	281 if err := auth.RunAs(ctx, "sys_admin",
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	282 func(conn *sql.Conn) error {
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	283 _, err := conn.ExecContext(ctx, deleteSoundingDiffsSQL)
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	284 return err
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	285 },
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	286 ); err != nil {
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	287 log.Printf("error: Cleaning sounding diffs cache failed: %v\n", err)
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	288 }
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	289 }
45be361f2d48 If the settings for sounding diffs are changed in a way that they need recalculation, flush the cache. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3854 diff changeset	290
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	291 func setSystemSettings(
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	292 input interface{},
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	293 req *http.Request,
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	294 conn *sql.Conn,
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	295 ) (jr JSONResult, err error) {
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	296
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	297 settings := input.(*map[string]string)
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	298
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	299 ctx := req.Context()
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	300 var tx *sql.Tx
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	301 if tx, err = conn.BeginTx(ctx, nil); err != nil {
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	302 return
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	303 }
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	304 defer tx.Rollback()
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	305
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	306 var setStmt *sql.Stmt
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	307 if setStmt, err = tx.PrepareContext(ctx, updateSettingSQL); err != nil {
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	308 return
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	309 }
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	310 defer setStmt.Close()
3834 d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	311 var getStmt *sql.Stmt
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	312 if getStmt, err = tx.PrepareContext(ctx, getConfigSQL); err != nil {
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	313 return
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	314 }
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	315 defer getStmt.Close()
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	316
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	317 reconfigure := map[string]func(*http.Request){}
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	318
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	319 for key, value := range *settings {
3834 d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	320 var old sql.NullString
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	321 err = getStmt.QueryRowContext(ctx, key).Scan(&old)
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	322 switch {
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	323 case err == sql.ErrNoRows:
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	324 old.Valid, err = false, nil
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	325 case err != nil:
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	326 return
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	327 }
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	328
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	329 if cmp := reconfigureFunc(key); cmp != nil {
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	330 var fn func(*http.Request)
3854 3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	331 if fn, err = cmp(old, value); err != nil {
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	332 return
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	333 }
3fcc4e11fc00 Validate the config values of the morpho classes when saving. Also don't trigger the expensive re-calculation of the contour lines if only the colors changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3834 diff changeset	334 if fn != nil {
3834 d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	335 reconfigure[key] = fn
d68c6be758b6 Only trigger the reconfiguation functions if the values have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3833 diff changeset	336 }
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	337 }
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	338
3630 2467e619cf67 Fixed more SQL typos. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3629 diff changeset	339 if _, err = setStmt.ExecContext(ctx, key, value); err != nil {
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	340 return
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	341 }
3628 6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	342 }
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	343
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	344 if err = tx.Commit(); err != nil {
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	345 return
6693be57b7a2 Re-worked the Go part a little bit. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3625 diff changeset	346 }
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	347
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	348 for _, fn := range reconfigure {
4214 49564382ffff Added a import queue job to recalculate the contour lines of the sounding results if the heights have changed. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3929 diff changeset	349 fn(req)
3833 70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	350 }
70a881045efd Trigger reconfiguration of GeoServer if the system settings were written. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3630 diff changeset	351
3625 a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	352 jr = JSONResult{
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	353 Code: http.StatusCreated,
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	354 Result: struct {
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	355 Result string `json:"result"`
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	356 }{"success"},
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	357 }
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	358 return
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	359 }
a688a478e35f implemented configuration backend and frontend Markus Kottlaender <markus@intevation.de> parents: 3108 diff changeset	360
840 0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	361 // Map/Feature style end points
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	362
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	363 func getFeatureStyle(
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	364 _ interface{},
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	365 req *http.Request,
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	366 db *sql.Conn,
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	367 ) (jr JSONResult, err error) {
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	368
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	369 feature := mux.Vars(req)["feature"]
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	370 attr := mux.Vars(req)["attr"]
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	371
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	372 c := models.Colour{}
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	373 err = db.QueryRowContext(
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	374 req.Context(),
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	375 getFeatureColourSQL,
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	376 feature, attr,
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	377 ).Scan(&c.R, &c.G, &c.B, &c.A)
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	378
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	379 switch {
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	380 case err == sql.ErrNoRows:
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	381 err = JSONError{
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	382 Code: http.StatusNotFound,
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	383 Message: "Requestes style not found.",
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	384 }
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	385 return
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	386 case err != nil:
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	387 return
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	388 }
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	389
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	390 jr.Result = &struct {
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	391 Colour models.Colour `json:"colour"`
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	392 Code string `json:"code"`
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	393 }{c, fmt.Sprintf("rgba(%d, %d, %d, %g)", c.R, c.G, c.B, c.A)}
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	394 return
0f61bfc21041 Added end point to get style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 722 diff changeset	395 }
846 6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	396
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	397 func setFeatureStyle(
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	398 input interface{},
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	399 req *http.Request,
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	400 db *sql.Conn,
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	401 ) (jr JSONResult, err error) {
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	402
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	403 feature := mux.Vars(req)["feature"]
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	404 attr := mux.Vars(req)["attr"]
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	405
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	406 c := input.(*models.Colour)
854 83c271cb2344 Reverted fcb38cedc680 (More tightened color model.) Sascha Wilde <wilde@intevation.de> parents: 850 diff changeset	407 if !c.IsValid() {
83c271cb2344 Reverted fcb38cedc680 (More tightened color model.) Sascha Wilde <wilde@intevation.de> parents: 850 diff changeset	408 err = JSONError{http.StatusBadRequest, "error: invalid colours"}
83c271cb2344 Reverted fcb38cedc680 (More tightened color model.) Sascha Wilde <wilde@intevation.de> parents: 850 diff changeset	409 return
83c271cb2344 Reverted fcb38cedc680 (More tightened color model.) Sascha Wilde <wilde@intevation.de> parents: 850 diff changeset	410 }
846 6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	411
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	412 var res sql.Result
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	413 res, err = db.ExecContext(
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	414 req.Context(),
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	415 setFeatureColourSQL,
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	416 feature, attr,
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	417 c.R, c.G, c.B, c.A)
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	418
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	419 if err != nil {
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	420 return
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	421 }
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	422
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	423 if n, err2 := res.RowsAffected(); err2 == nil && n == 0 {
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	424 err = JSONError{
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	425 Code: http.StatusNotFound,
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	426 Message: "Requestes style not found.",
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	427 }
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	428 return
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	429 }
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	430
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	431 jr = JSONResult{
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	432 Code: http.StatusCreated,
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	433 Result: struct {
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	434 Result string `json:"result"`
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	435 }{"success"},
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	436 }
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	437 return
6902032757e4 Added end point to set style (colour) information for feature. Sascha Wilde <wilde@intevation.de> parents: 840 diff changeset	438 }

Mercurial > gemma

annotate pkg/controllers/system.go @ 4214:49564382ffff