gemma: pkg/controllers/gauges.go annotate

annotate pkg/controllers/gauges.go @ 2766:1f173d1a731d

Fixed broken SQL statement.

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Thu, 21 Mar 2019 21:40:11 +0100
parents	a06d11d1f0b3
children	2806821cfd63

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"
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	22 "sort"
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	23 "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	24 "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	25
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 "github.com/gorilla/mux"
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	27 "gonum.org/v1/gonum/stat"
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
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	29 "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	30 "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	31 "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	32 )
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	33
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	34 const (
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	35 selectPredictedObserveredSQL = `
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	36 SELECT
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	37 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	38 a.water_level AS predicted,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	39 b.water_level AS observed
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	40 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	41 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	42 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	43 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	44 WHERE
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	45 a.fk_gauge_id = (
2763 a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	46 $1::char(2),
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	47 $2::char(3),
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	48 $3::char(5),
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	49 $4::char(5),
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	50 $5::int
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	51 ) AND
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	52 a.measure_date BETWEEN
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	53 $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	54 ORDER BY a.measure_date
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	55 `
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	56
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	57 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	58 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	59 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	60 water_level,
2766 1f173d1a731d Fixed broken SQL statement. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2763 diff changeset	61 predicted
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	62 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	63 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	64 `
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	65 selectWaterlevelsMeasuredSQL = `
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	66 SELECT
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	67 measure_date,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	68 water_level
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	69 FROM waterway.gauge_measurements
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	70 WHERE
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	71 NOT predicted
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	72 AND fk_gauge_id = (
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	73 $1::char(2),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	74 $2::char(3),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	75 $3::char(5),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	76 $4::char(5),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	77 $5::int
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	78 )
2763 a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	79 AND measure_date BETWEEN
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	80 $6::timestamp with time zone AND
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	81 $7::timestamp with time zone
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	82 ORDER BY measure_date
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	83 `
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	84 )
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	85
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	86 func averageWaterlevels(rw http.ResponseWriter, req *http.Request) {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	87 gauge := mux.Vars(req)["gauge"]
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	88
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	89 isrs, err := models.IsrsFromString(gauge)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	90 if err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	91 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	92 rw, fmt.Sprintf("error: Invalid ISRS code: %v", err),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	93 http.StatusBadRequest)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	94 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	95 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	96
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	97 var from, to time.Time
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	98
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	99 if t := req.FormValue("to"); t != "" {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	100 var err error
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	101 if to, err = time.ParseInLocation(common.DateFormat, t, time.UTC); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	102 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	103 rw, fmt.Sprintf("error: bad from date: %v", err),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	104 http.StatusBadRequest)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	105 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	106 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	107 } else {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	108 y, m, d := time.Now().Date()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	109 to = time.Date(y, m, d, 0, 0, 0, 0, time.UTC)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	110 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	111
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	112 if f := req.FormValue("from"); f != "" {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	113 var err error
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	114 if from, err = time.ParseInLocation(common.DateFormat, f, time.UTC); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	115 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	116 rw, fmt.Sprintf("error: bad from date: %v", err),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	117 http.StatusBadRequest)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	118 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	119 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	120 } else {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	121 from = to.AddDate(-1, 0, 0)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	122 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	123
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	124 to = to.AddDate(0, 0, 1).Add(-time.Nanosecond)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	125
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	126 if to.Before(from) {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	127 from, to = to, from
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	128 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	129
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	130 conn := middleware.GetDBConn(req)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	131
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	132 ctx := req.Context()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	133
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	134 rows, err := conn.QueryContext(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	135 ctx,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	136 selectWaterlevelsMeasuredSQL,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	137 isrs.CountryCode,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	138 isrs.LoCode,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	139 isrs.FairwaySection,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	140 isrs.Orc,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	141 isrs.Hectometre,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	142 from, to,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	143 )
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	144 if err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	145 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	146 rw, fmt.Sprintf("error: %v", err),
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	147 http.StatusInternalServerError)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	148 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	149 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	150 defer rows.Close()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	151
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	152 rw.Header().Add("Content-Type", "text/csv")
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	153
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	154 out := csv.NewWriter(rw)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	155
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	156 var last time.Time
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	157 var values []float64
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	158
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	159 record := []string{
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	160 "#date",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	161 "#min",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	162 "#max",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	163 "#mean",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	164 "#median",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	165 "#q25",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	166 "#q75",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	167 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	168
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	169 if err := out.Write(record); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	170 log.Printf("error: %v\n", err)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	171 // Too late for an HTTP error code.
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	172 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	173 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	174
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	175 format := func(v float64) string {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	176 return strconv.FormatFloat(v, 'f', -1, 64)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	177 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	178
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	179 write := func() error {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	180 if len(values) > 0 {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	181 sort.Float64s(values)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	182 // date
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	183 record[0] = last.Format(common.DateFormat)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	184 // min
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	185 record[1] = format(values[0])
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	186 // max
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	187 record[2] = format(values[len(values)-1])
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	188 // mean
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	189 record[3] = format(stat.Mean(values, nil))
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	190 // median
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	191 record[4] = format(values[len(values)/2])
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	192 // Q25
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	193 record[5] = format(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	194 stat.Quantile(0.25, stat.Empirical, values, nil))
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	195 // Q75
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	196 record[6] = format(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	197 stat.Quantile(0.75, stat.Empirical, values, nil))
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	198
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	199 err := out.Write(record)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	200 values = values[:0]
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	201 return err
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	202 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	203 return nil
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	204 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	205
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	206 for rows.Next() {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	207 var (
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	208 date time.Time
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	209 value float64
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	210 )
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	211 if err := rows.Scan(&date, &value); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	212 log.Printf("error: %v\n", err)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	213 // Too late for an HTTP error code.
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	214 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	215 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	216 oy, om, od := last.Date()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	217 ny, nm, nd := date.Date()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	218 if oy != ny \|\| om != nm \|\| od != nd {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	219 if err := write(); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	220 log.Printf("error: %v\n", err)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	221 // Too late for an HTTP error code.
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	222 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	223 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	224 last = date
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	225 } else {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	226 values = append(values, value)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	227 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	228 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	229 write()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	230
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	231 if err := rows.Err(); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	232 log.Printf("error: %v", err)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	233 // Too late for an HTTP error code.
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	234 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	235 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	236
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	237 out.Flush()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	238 if err := out.Error(); err != nil {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	239 log.Printf("error: %v", err)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	240 // Too late for an HTTP error code.
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	241 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	242 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	243
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	244 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	245
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	246 func nashSutcliffe(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	247 _ interface{},
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	248 req *http.Request,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	249 conn *sql.Conn,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	250 ) (jr JSONResult, err error) {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	251 gauge := mux.Vars(req)["gauge"]
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	252
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	253 var isrs *models.Isrs
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	254 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	255 err = JSONError{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	256 Code: http.StatusBadRequest,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	257 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	258 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	259 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	260 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	261
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	262 var when time.Time
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	263 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	264 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	265 err = JSONError{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	266 Code: http.StatusBadRequest,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	267 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	268 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	269 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	270 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	271 } else {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	272 when = time.Now()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	273 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	274
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	275 ctx := req.Context()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	276
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	277 var rows *sql.Rows
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	278 if rows, err = conn.QueryContext(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	279 ctx,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	280 selectPredictedObserveredSQL,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	281 isrs.CountryCode,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	282 isrs.LoCode,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	283 isrs.FairwaySection,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	284 isrs.Orc,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	285 isrs.Hectometre,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	286 when,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	287 ); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	288 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	289 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	290 defer rows.Close()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	291
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	292 var measurements []common.NSMeasurement
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	293
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	294 for rows.Next() {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	295 var m common.NSMeasurement
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	296 if err = rows.Scan(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	297 &m.When,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	298 &m.Predicted,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	299 &m.Observed,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	300 ); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	301 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	302 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	303 measurements = append(measurements, m)
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	304 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	305 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	306 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	307 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	308
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	309 type coeff struct {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	310 Value float64 `json:"value"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	311 Samples int `json:"samples"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	312 Hours int `json:"hours"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	313 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	314
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	315 type coeffs struct {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	316 When models.ImportTime `json:"when"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	317 Coeffs []coeff `json:"coeffs"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	318 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	319
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	320 cs := make([]coeff, 3)
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	321 for i := range cs {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	322 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	323 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	324 measurements,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	325 when,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	326 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	327 )
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	328 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	329
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	330 jr = JSONResult{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	331 Result: &coeffs{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	332 When: models.ImportTime{when},
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	333 Coeffs: cs,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	334 },
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	335 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	336 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	337 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	338
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	339 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	340 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	341
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	342 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	343 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	344 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	345 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	346 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	347 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	348 }
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	349
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	350 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	351 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	352
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	353 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	354 " 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	355 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	356 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	357 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	358 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	359 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	360 )
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	361
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	362 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	363 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	364 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	365 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	366 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	367 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	368 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	369 }
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	370 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	371 }
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	372
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	373 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	374 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	375 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	376 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	377 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	378 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	379 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	380 }
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	381 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	382 }
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	383
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	384 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	385
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	386 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	387
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	388 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	389 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	390 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	391 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	392 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	393 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	394 }
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	395 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	396
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	397 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	398
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	399 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	400
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	401 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	402
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	403 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	404 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	405 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	406 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	407 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	408 )
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	409 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	410 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	411 // 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	412 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	413 }
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	414 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	415 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	416 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	417 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	418 } 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	419 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	420 }
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	421 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	422 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	423 // 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	424 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	425 }
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	426 }
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	427
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	428 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	429 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	430 // 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	431 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	432 }
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	433
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	434 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	435 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	436 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	437 // 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	438 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	439 }
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	440 }

Mercurial > gemma

annotate pkg/controllers/gauges.go @ 2766:1f173d1a731d