gemma: pkg/controllers/gauges.go annotate

annotate pkg/controllers/gauges.go @ 2741:87aed4f9b1b8

Added calculation of Nash Sutcliffe efficiency coefficents. GET /api/data/nash-sutcliffe/{gauge}?when={WHEN} 'when' is optional in form of "2006-01-02T15:04:05.000" and defaults to current server time. curl -H "X-Gemma-Auth:$KEY" http://${server}:${port}/api/data/nash-sutcliffe/${gauge} | jq . { "when": "2019-03-20T10:38:05.687", "coeffs": [ { "value": 0, "samples": 0, "hours": 24 }, { "value": 0, "samples": 0, "hours": 48 }, { "value": 0, "samples": 0, "hours": 72 } ] }

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Wed, 20 Mar 2019 10:47:01 +0100
parents	0d7a4fdb9e12
children	f95ec0bb565c

rev	line source
2694 0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 // This is Free Software under GNU Affero General Public License v >= 3.0
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2 // without warranty, see README.md and license for details.
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	3 //
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	4 // SPDX-License-Identifier: AGPL-3.0-or-later
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	5 // License-Filename: LICENSES/AGPL-3.0.txt
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	6 //
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	7 // Copyright (C) 2019 by via donau
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	8 // – Österreichische Wasserstraßen-Gesellschaft mbH
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 // Software engineering by Intevation GmbH
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10 //
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	11 // Author(s):
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	12 // * Sascha L. Teichmann <sascha.teichmann@intevation.de>
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	14 package controllers
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	15
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	16 import (
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	17 "database/sql"
2694 0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18 "encoding/csv"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	19 "fmt"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 "log"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	21 "net/http"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	22 "strconv"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	23 "time"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	24
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	25 "github.com/gorilla/mux"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	26
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	27 "gemma.intevation.de/gemma/pkg/common"
2694 0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	28 "gemma.intevation.de/gemma/pkg/middleware"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	29 "gemma.intevation.de/gemma/pkg/models"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	30 )
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	31
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	32 const (
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	33 selectPredictedObserveredSQL = `
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	34 SELECT
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	35 a.measure_date AS measure_date,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	36 a.water_level AS predicted,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	37 b.water_level AS observed
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	38 FROM waterway.gauge_measurements a JOIN waterway.gauge_measurements b
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	39 ON a.fk_gauge_id = b.fk_gauge_id AND
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	40 a.measure_date = b.measure_date AND
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	41 a.predicted AND NOT b.predicted
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	42 WHERE
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	43 a.fk_gauge_id = (
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	44 $1::char(1),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	45 $2::char(2),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	46 $3::char(3),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	47 $4::char(4),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	48 $5::int
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	49 ) AND
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	50 a.measure_date BETWEEN
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	51 $6::timestamp AND $6::timestamp - '72hours'::interval
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	52 ORDER BY a.measure_date
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	53 `
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	54
2694 0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	55 selectWaterlevelsSQL = `
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	56 SELECT
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	57 measure_date,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	58 water_level,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	59 predicted
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	60 FROM waterway.gauge_measurements
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61 WHERE
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62 `
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 )
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	65 func nashSutcliffe(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	66 _ interface{},
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	67 req *http.Request,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	68 conn *sql.Conn,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	69 ) (jr JSONResult, err error) {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	70 gauge := mux.Vars(req)["gauge"]
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	71
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	72 var isrs *models.Isrs
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	73 if isrs, err = models.IsrsFromString(gauge); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	74 err = JSONError{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	75 Code: http.StatusBadRequest,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	76 Message: fmt.Sprintf("error: Invalid ISRS code: %v", err),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	77 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	78 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	79 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	80
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	81 var when time.Time
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	82 if w := req.FormValue("when"); w != "" {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	83 if when, err = time.Parse(models.ImportTimeFormat, w); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	84 err = JSONError{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	85 Code: http.StatusBadRequest,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	86 Message: fmt.Sprintf("error: wrong time format: %v", err),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	87 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	88 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	89 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	90 } else {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	91 when = time.Now()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	92 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	93
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	94 ctx := req.Context()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	95
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	96 var rows *sql.Rows
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	97 if rows, err = conn.QueryContext(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	98 ctx,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	99 selectPredictedObserveredSQL,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	100 isrs.CountryCode,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	101 isrs.LoCode,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	102 isrs.FairwaySection,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	103 isrs.Orc,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	104 isrs.Hectometre,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	105 when,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	106 ); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	107 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	108 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	109 defer rows.Close()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	110
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	111 var measurements []common.NSMeasurement
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	112
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	113 for rows.Next() {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	114 var m common.NSMeasurement
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	115 if err = rows.Scan(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	116 &m.When,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	117 &m.Predicted,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	118 &m.Observed,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	119 ); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	120 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	121 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	122 measurements = append(measurements, m)
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	123 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	124 if err = rows.Err(); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	125 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	126 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	127
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	128 type coeff struct {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	129 Value float64 `json:"value"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	130 Samples int `json:"samples"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	131 Hours int `json:"hours"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	132 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	133
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	134 type coeffs struct {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	135 When models.ImportTime `json:"when"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	136 Coeffs []coeff `json:"coeffs"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	137 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	138
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	139 cs := make([]coeff, 3)
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	140 for i := range cs {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	141 cs[i].Hours = (i + 1) * 24
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	142 cs[i].Value, cs[i].Samples = common.NashSutcliffe(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	143 measurements,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	144 when,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	145 when.Add(time.Duration(-cs[i].Hours)*time.Hour),
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	146 )
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	147 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	148
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	149 jr = JSONResult{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	150 Result: &coeffs{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	151 When: models.ImportTime{when},
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	152 Coeffs: cs,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	153 },
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	154 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	155 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	156 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	157
2694 0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158 func waterlevels(rw http.ResponseWriter, req *http.Request) {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 gauge := mux.Vars(req)["gauge"]
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	161 isrs, err := models.IsrsFromString(gauge)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	162 if err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	163 http.Error(
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	164 rw, fmt.Sprintf("error: Invalid ISRS code: %v", err),
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	165 http.StatusBadRequest)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	166 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	167 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	168
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	169 var fb filterBuilder
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	170 fb.stmt.WriteString(selectWaterlevelsSQL)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	171
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	172 fb.cond(
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	173 " fk_gauge_id = ($%d::char(2), $%d::char(3), $%d::char(5), $%d::char(5), $%d::int) ",
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	174 isrs.CountryCode,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	175 isrs.LoCode,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	176 isrs.FairwaySection,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	177 isrs.Orc,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	178 isrs.Hectometre,
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	179 )
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	180
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	181 if from := req.FormValue("from"); from != "" {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	182 fromTime, err := time.Parse(models.ImportTimeFormat, from)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	183 if err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	184 http.Error(
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	185 rw, fmt.Sprintf("error: Invalid from time: %v", err),
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	186 http.StatusBadRequest)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	187 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	188 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	189 fb.cond("measure_date >= $%d", fromTime)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	190 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	191
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	192 if to := req.FormValue("to"); to != "" {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	193 toTime, err := time.Parse(models.ImportTimeFormat, to)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	194 if err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	195 http.Error(
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	196 rw, fmt.Sprintf("error: Invalid from time: %v", err),
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	197 http.StatusBadRequest)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	198 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	199 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	200 fb.cond("measure_date <= $%d", toTime)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	201 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	202
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	203 conn := middleware.GetDBConn(req)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	204
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	205 ctx := req.Context()
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	206
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	207 rows, err := conn.QueryContext(ctx, fb.stmt.String(), fb.args...)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	208 if err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	209 http.Error(
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	210 rw, fmt.Sprintf("error: %v", err),
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	211 http.StatusInternalServerError)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	212 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	213 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	214 defer rows.Close()
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	215
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	216 rw.Header().Add("Content-Type", "text/csv")
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	217
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	218 out := csv.NewWriter(rw)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	219
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	220 record := make([]string, 3)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	221
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	222 for rows.Next() {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	223 var (
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	224 measureDate time.Time
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	225 waterlevel float64
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	226 predicted bool
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	227 )
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	228 if err := rows.Scan(&measureDate, &waterlevel, &predicted); err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	229 log.Printf("error: %v\n", err)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	230 // Too late for an HTTP error code.
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	231 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	232 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	233 record[0] = measureDate.Format(models.ImportTimeFormat)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	234 record[1] = strconv.FormatFloat(waterlevel, 'f', -1, 64)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	235 if predicted {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	236 record[2] = "t"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	237 } else {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	238 record[2] = "f"
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	239 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	240 if err := out.Write(record); err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	241 log.Printf("error: %v", err)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	242 // Too late for an HTTP error code.
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	243 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	244 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	245 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	246
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	247 if err := rows.Err(); err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	248 log.Printf("error: %v", err)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	249 // Too late for an HTTP error code.
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	250 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	251 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	252
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	253 out.Flush()
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	254 if err := out.Error(); err != nil {
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	255 log.Printf("error: %v", err)
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	256 // Too late for an HTTP error code.
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	257 return
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	258 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	259 }

Mercurial > gemma

annotate pkg/controllers/gauges.go @ 2741:87aed4f9b1b8