Mercurial > gemma

annotate pkg/controllers/statsupdates.go @ 5591:0011f50cf216 surveysperbottleneckid

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Removed no longer used alternative api for surveys/ endpoint. As bottlenecks in the summary for SR imports are now identified by their id and no longer by the (not guarantied to be unique!) name, there is no longer the need to request survey data by the name+date tuple (which isn't reliable anyway). So the workaround was now reversed.
author Sascha Wilde <wilde@sha-bang.de>
date Wed, 06 Apr 2022 13:30:29 +0200
parents 5f47eeea988d
children 6270951dda28
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 // This is Free Software under GNU Affero General Public License v >= 3.0
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 // without warranty, see README.md and license for details.
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 //
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 // SPDX-License-Identifier: AGPL-3.0-or-later
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 // License-Filename: LICENSES/AGPL-3.0.txt
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 //
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7 // Copyright (C) 2021 by via donau
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
8 // – Österreichische Wasserstraßen-Gesellschaft mbH
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
9 // Software engineering by Intevation GmbH
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10 //
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
11 // Author(s):
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
12 // * Sascha L. Teichmann <sascha.teichmann@intevation.de>
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
13
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
14 package controllers
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
15
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
16 import (
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
17 "database/sql"
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
18 "net/http"
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
19
5490
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
20 "github.com/gorilla/mux"
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
21
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
22 "gemma.intevation.de/gemma/pkg/log"
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
23 mw "gemma.intevation.de/gemma/pkg/middleware"
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
24 )
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
25
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
26 const (
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
27 listStatsUpdatesSQL = `SELECT name FROM sys_admin.stats_updates ORDER BY name`
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
28 statsUpdatesScriptSQL = `SELECT script FROM sys_admin.stats_updates WHERE name = $1`
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
29 )
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
30
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
31 func listStatsUpdates(req *http.Request) (jr mw.JSONResult, err error) {
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
32
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
33 ctx := req.Context()
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
34 conn := mw.JSONConn(req)
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
35
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
36 rows, err2 := conn.QueryContext(ctx, listStatsUpdatesSQL)
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
37 if err2 != nil {
5490
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
38 log.Errorf("%v\n", err2)
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
39 err = mw.JSONError{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
40 Code: http.StatusInternalServerError,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
41 Message: "Listing stats update failed.",
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
42 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
43 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
44 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
45 defer rows.Close()
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
46
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
47 names := []string{}
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
48
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
49 for rows.Next() {
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
50 var name string
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
51 if err2 := rows.Scan(&name); err2 != nil {
5490
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
52 log.Errorf("%v\n", err2)
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
53 err = mw.JSONError{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
54 Code: http.StatusInternalServerError,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
55 Message: "Fetching stats update names failed.",
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
56 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
57 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
58 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
59 names = append(names, name)
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
60 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
61
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
62 if err2 := rows.Err(); err2 != nil {
5490
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
63 log.Errorf("%v\n", err2)
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
64 err = mw.JSONError{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
65 Code: http.StatusInternalServerError,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
66 Message: "Fetching stats update names failed.",
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
67 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
68 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
69 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
70
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
71 out := struct {
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
72 StatsUpdates []string `json:"stats-updates"`
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
73 }{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
74 StatsUpdates: names,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
75 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
76 jr = mw.JSONResult{Result: out}
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
77 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
78 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
79
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
80 func statsUpdates(req *http.Request) (jr mw.JSONResult, err error) {
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
81 name := mux.Vars(req)["name"]
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
82
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
83 ctx := req.Context()
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
84 conn := mw.JSONConn(req)
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
85
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
86 var script string
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
87 err2 := conn.QueryRowContext(ctx, statsUpdatesScriptSQL, name).Scan(&script)
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
88 switch {
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
89 case err2 == sql.ErrNoRows:
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
90 err = mw.JSONError{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
91 Code: http.StatusNotFound,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
92 Message: "No such update script.",
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
93 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
94 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
95 case err2 != nil:
5490
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
96 log.Errorf("%v\n", err2)
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
97 err = mw.JSONError{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
98 Code: http.StatusInternalServerError,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
99 Message: "Loading update script failed.",
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
100 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
101 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
102 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
103
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
104 if _, err2 := conn.ExecContext(ctx, script); err2 != nil {
5490
5f47eeea988d Use own logging package.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5386
diff changeset
105 log.Errorf("%v\n", err2)
5386
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
106 err = mw.JSONError{
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
107 Code: http.StatusInternalServerError,
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
108 Message: "Loading update script failed.",
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
109 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
110 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
111 }
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
112
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
113 jr = mw.JSONResult{Result: map[string]interface{}{}}
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
114 return
fc3a5345b0fd Added enpoint /api/data/stats-updates to list and trigger the stats update scripts. sys_admin only.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
115 }