gemma: pkg/controllers/gauges.go annotate

annotate pkg/controllers/gauges.go @ 2783:2806821cfd63

Added min and max values to CSV output of /api/data/waterlevels/{gauge} .

author	Sascha L. Teichmann <sascha.teichmann@intevation.de>
date	Fri, 22 Mar 2019 21:55:30 +0100
parents	1f173d1a731d
children	db1052bc162a

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,
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	61 value_min,
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	62 value_max,
2766 1f173d1a731d Fixed broken SQL statement. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2763 diff changeset	63 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	64 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	65 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	66 `
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	67 selectWaterlevelsMeasuredSQL = `
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	68 SELECT
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	69 measure_date,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	70 water_level
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	71 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	72 WHERE
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	73 NOT predicted
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	74 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	75 $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	76 $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	77 $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	78 $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	79 $5::int
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	80 )
2763 a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	81 AND measure_date BETWEEN
a06d11d1f0b3 Fixed gauge selection in Nash Sutcliffe calculation. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2762 diff changeset	82 $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	83 $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	84 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	85 `
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	86 )
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	87
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	88 func float64format(v float64) string {
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	89 return strconv.FormatFloat(v, 'f', -1, 64)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	90 }
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	91
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	92 func nullFloat64format(v sql.NullFloat64) string {
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	93 if v.Valid {
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	94 return float64format(v.Float64)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	95 }
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	96 return ""
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	97 }
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	98
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	99 func boolFormat(b bool) string {
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	100 if b {
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	101 return "t"
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	102 }
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	103 return "f"
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	104 }
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	105
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	106 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	107 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	108
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	109 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	110 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	111 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	112 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	113 http.StatusBadRequest)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	114 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	115 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	116
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	117 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	118
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	119 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	120 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	121 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	122 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	123 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	124 http.StatusBadRequest)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	125 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	126 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	127 } else {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	128 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	129 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	130 }
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 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	133 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	134 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	135 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	136 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	137 http.StatusBadRequest)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	138 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	139 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	140 } else {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	141 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	142 }
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 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	145
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	146 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	147 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	148 }
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 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	151
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	152 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	153
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	154 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	155 ctx,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	156 selectWaterlevelsMeasuredSQL,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	157 isrs.CountryCode,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	158 isrs.LoCode,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	159 isrs.FairwaySection,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	160 isrs.Orc,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	161 isrs.Hectometre,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	162 from, to,
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	163 )
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	164 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	165 http.Error(
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	166 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	167 http.StatusInternalServerError)
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	168 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	169 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	170 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	171
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	172 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	173
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	174 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	175
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	176 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	177 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	178
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	179 record := []string{
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	180 "#date",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	181 "#min",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	182 "#max",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	183 "#mean",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	184 "#median",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	185 "#q25",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	186 "#q75",
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	187 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	188
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	189 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	190 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	191 // 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	192 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	193 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	194
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	195 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	196 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	197 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	198 // date
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	199 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	200 // min
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	201 record[1] = float64format(values[0])
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	202 // max
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	203 record[2] = float64format(values[len(values)-1])
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	204 // mean
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	205 record[3] = float64format(stat.Mean(values, nil))
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	206 // median
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	207 record[4] = float64format(values[len(values)/2])
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	208 // Q25
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	209 record[5] = float64format(
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	210 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	211 // Q75
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	212 record[6] = float64format(
2762 f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	213 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	214
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	215 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	216 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	217 return err
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	218 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	219 return nil
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	220 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	221
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	222 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	223 var (
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	224 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	225 value float64
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	226 )
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	227 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	228 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	229 // 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	230 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	231 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	232 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	233 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	234 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	235 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	236 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	237 // 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	238 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	239 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	240 last = date
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	241 } else {
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	242 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	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 write()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	246
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	247 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	248 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	249 // 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	250 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	251 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	252
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	253 out.Flush()
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	254 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	255 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	256 // 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	257 return
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	258 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	259
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	260 }
f95ec0bb565c Added endpoint to deliver average waterlevels for a given gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2741 diff changeset	261
2741 87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	262 func nashSutcliffe(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	263 _ interface{},
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	264 req *http.Request,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	265 conn *sql.Conn,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	266 ) (jr JSONResult, err error) {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	267 gauge := mux.Vars(req)["gauge"]
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 var isrs *models.Isrs
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	270 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	271 err = JSONError{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	272 Code: http.StatusBadRequest,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	273 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	274 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	275 return
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
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	278 var when time.Time
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	279 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	280 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	281 err = JSONError{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	282 Code: http.StatusBadRequest,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	283 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	284 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	285 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	286 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	287 } else {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	288 when = time.Now()
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
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	291 ctx := req.Context()
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	292
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	293 var rows *sql.Rows
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	294 if rows, err = conn.QueryContext(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	295 ctx,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	296 selectPredictedObserveredSQL,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	297 isrs.CountryCode,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	298 isrs.LoCode,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	299 isrs.FairwaySection,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	300 isrs.Orc,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	301 isrs.Hectometre,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	302 when,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	303 ); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	304 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	305 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	306 defer rows.Close()
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 var measurements []common.NSMeasurement
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	309
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	310 for rows.Next() {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	311 var m common.NSMeasurement
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	312 if err = rows.Scan(
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	313 &m.When,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	314 &m.Predicted,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	315 &m.Observed,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	316 ); err != nil {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	317 return
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 measurements = append(measurements, m)
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	320 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	321 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	322 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	323 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	324
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	325 type coeff struct {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	326 Value float64 `json:"value"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	327 Samples int `json:"samples"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	328 Hours int `json:"hours"`
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
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	331 type coeffs struct {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	332 When models.ImportTime `json:"when"`
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	333 Coeffs []coeff `json:"coeffs"`
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 cs := make([]coeff, 3)
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	337 for i := range cs {
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	338 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	339 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	340 measurements,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	341 when,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	342 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	343 )
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	344 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	345
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	346 jr = JSONResult{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	347 Result: &coeffs{
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	348 When: models.ImportTime{when},
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	349 Coeffs: cs,
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	350 },
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	351 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	352 return
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	353 }
87aed4f9b1b8 Added calculation of Nash Sutcliffe efficiency coefficents. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2694 diff changeset	354
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	355 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	356 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	357
0d7a4fdb9e12 Added GET /api/data/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, 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	359 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	360 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	361 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	362 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	363 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	364 }
0d7a4fdb9e12 Added GET /api/data/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
0d7a4fdb9e12 Added GET /api/data/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 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	367 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	368
0d7a4fdb9e12 Added GET /api/data/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 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	370 " 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	371 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	372 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	373 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	374 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	375 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	376 )
0d7a4fdb9e12 Added GET /api/data/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
0d7a4fdb9e12 Added GET /api/data/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 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	379 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	380 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	381 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	382 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	383 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	384 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	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 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	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
0d7a4fdb9e12 Added GET /api/data/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 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	390 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	391 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	392 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	393 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	394 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	395 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	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 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	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
0d7a4fdb9e12 Added GET /api/data/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 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	401
0d7a4fdb9e12 Added GET /api/data/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 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	403
0d7a4fdb9e12 Added GET /api/data/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 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	405 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	406 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	407 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	408 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	409 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	410 }
0d7a4fdb9e12 Added GET /api/data/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 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	412
0d7a4fdb9e12 Added GET /api/data/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 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	414
0d7a4fdb9e12 Added GET /api/data/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 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	416
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	417 record := []string{
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	418 "#date",
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	419 "#water_level",
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	420 "#value_min",
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	421 "#value_max",
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	422 "#predicted",
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	423 }
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	424
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	425 if err := out.Write(record); err != nil {
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	426 log.Printf("error: %v", err)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	427 // Too late for an HTTP error code.
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	428 return
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	429 }
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	430
0d7a4fdb9e12 Added GET /api/data/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 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	432 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	433 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	434 waterlevel float64
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	435 valueMin sql.NullFloat64
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	436 valueMax sql.NullFloat64
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	437 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	438 )
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	439 if err := rows.Scan(
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	440 &measureDate,
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	441 &waterlevel,
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	442 &valueMin,
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	443 &valueMax,
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	444 &predicted,
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	445 ); err != nil {
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	446 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	447 // 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	448 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	449 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	450 record[0] = measureDate.Format(models.ImportTimeFormat)
2783 2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	451 record[1] = float64format(waterlevel)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	452 record[2] = nullFloat64format(valueMin)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	453 record[3] = nullFloat64format(valueMax)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	454 record[4] = boolFormat(predicted)
2806821cfd63 Added min and max values to CSV output of /api/data/waterlevels/{gauge} . Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2766 diff changeset	455
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	456 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	457 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	458 // 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	459 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	460 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	461 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	462
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	463 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	464 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	465 // 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	466 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	467 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	468
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	469 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	470 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	471 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	472 // 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	473 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	474 }
0d7a4fdb9e12 Added GET /api/data/waterlevels/{gauge isrs}?from={time_a}&to={time_b} to fetch waterlevels of gauge. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	475 }

Mercurial > gemma

annotate pkg/controllers/gauges.go @ 2783:2806821cfd63