Mercurial > gemma

annotate pkg/controllers/fwa.go @ 5239:158a26bcb2af new-fwa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Write the data out!
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 12 May 2020 15:58:19 +0200
parents b47a041e03c4
children 98ad96446d37
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 // This is Free Software under GNU Affero General Public License v >= 3.0
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 // without warranty, see README.md and license for details.
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 //
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 // SPDX-License-Identifier: AGPL-3.0-or-later
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
5 // License-Filename: LICENSES/AGPL-3.0.txt
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
6 //
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
7 // Copyright (C) 2018, 2019, 2020 by via donau
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
8 // – Österreichische Wasserstraßen-Gesellschaft mbH
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
9 // Software engineering by Intevation GmbH
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
10 //
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
11 // Author(s):
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
12 // * Sascha L. Teichmann <sascha.teichmann@intevation.de>
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
13
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
14 package controllers
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
15
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
16 import (
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
17 "context"
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
18 "database/sql"
5221
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
19 "encoding/csv"
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
20 "fmt"
5195
d6710d29516b Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5184
diff changeset
21 "log"
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
22 "net/http"
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
23 "sort"
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
24 "strconv"
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
25 "strings"
5196
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
26 "time"
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
27
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
28 "github.com/gorilla/mux"
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
29
5196
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
30 "gemma.intevation.de/gemma/pkg/common"
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
31 "gemma.intevation.de/gemma/pkg/middleware"
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
32 )
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
33
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
34 const (
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
35 selectBottlenecksLimitingSQL = `
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
36 SELECT
5233
d6374435111a Fixed order of parameters in SQL result.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5232
diff changeset
37 lower(validity),
d6374435111a Fixed order of parameters in SQL result.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5232
diff changeset
38 upper(validity),
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
39 limiting
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
40 FROM
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
41 waterway.bottlenecks
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
42 WHERE
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
43 bottleneck_id = $1 AND
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
44 validity && tstzrange($2, $3)`
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
45
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
46 selectSymbolBottlenecksSQL = `
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
47 SELECT
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
48 distinct(b.bottleneck_id)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
49 FROM
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
50 users.%s s, waterway.bottlenecks b
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
51 WHERE
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
52 ST_Intersects(b.area, s.area)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
53 AND s.name = $1
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
54 AND b.validity && tstzrange($2, $3)`
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
55
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
56 selectLDCsSQL = `
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
57 SELECT
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
58 lower(grwl.validity),
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
59 upper(grwl.validity),
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
60 grwl.value
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
61 FROM
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
62 waterway.gauges_reference_water_levels grwl
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
63 JOIN waterway.bottlenecks bns
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
64 ON grwl.location = bns.gauge_location
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
65 WHERE
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
66 grwl.depth_reference like 'LDC%'
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
67 AND bns.bottleneck_id = $1
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
68 AND grwl.validity && tstzrange($2, $3)`
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
69
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
70 selectMeasurementsSQL = `
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
71 WITH data AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
72 SELECT
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
73 efa.measure_date,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
74 efa.available_depth_value,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
75 efa.available_width_value,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
76 efa.water_level_value
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
77 FROM waterway.effective_fairway_availability efa
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
78 JOIN waterway.fairway_availability fa
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
79 ON efa.fairway_availability_id = fa.id
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
80 JOIN waterway.bottlenecks bn
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
81 ON fa.bottleneck_id = bn.bottleneck_id
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
82 WHERE
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
83 bn.bottleneck_id = $1 AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
84 efa.level_of_service = $2 AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
85 efa.measure_type = 'Measured' AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
86 (efa.available_depth_value IS NOT NULL OR
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
87 efa.available_width_value IS NOT NULL) AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
88 efa.water_level_value IS NOT NULL
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
89 ),
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
90 before AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
91 SELECT * FROM data WHERE measure_date < $3
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
92 ORDER BY measure_date DESC LIMIT 1
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
93 ),
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
94 inside AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
95 SELECT * FROM data WHERE measure_date BETWEEN $3 AND $4
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
96 ),
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
97 after AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
98 SELECT * FROM data WHERE measure_date > $4
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
99 ORDER BY measure_date LIMIT 1
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
100 )
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
101 SELECT * FROM before
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
102 UNION ALL
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
103 SELECT * FROM inside
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
104 UNION ALL
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
105 SELECT * FROM after
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
106 ORDER BY measure_date`
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
107 )
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
108
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
109 type (
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
110 timeRange struct {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
111 lower time.Time
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
112 upper time.Time
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
113 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
114
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
115 ldc struct {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
116 timeRange
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
117 value []float64
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
118 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
119
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
120 ldcs []*ldc
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
121
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
122 limitingFactor int
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
123
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
124 limitingValidity struct {
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
125 timeRange
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
126 limiting limitingFactor
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
127 ldcs ldcs
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
128 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
129
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
130 limitingValidities []limitingValidity
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
131
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
132 availMeasurement struct {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
133 when time.Time
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
134 depth int16
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
135 width int16
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
136 value int16
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
137 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
138
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
139 availMeasurements []availMeasurement
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
140
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
141 bottleneck struct {
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
142 id string
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
143 validities limitingValidities
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
144 measurements availMeasurements
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
145 }
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
146
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
147 bottlenecks []bottleneck
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
148
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
149 fwaMode int
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
150 )
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
151
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
152 const (
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
153 fwaMonthly fwaMode = iota
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
154 fwaQuarterly
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
155 fwaYearly
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
156 )
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
157
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
158 const (
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
159 limitingDepth limitingFactor = iota
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
160 limitingWidth
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
161 )
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
162
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
163 var limitingAccess = [...]func(*availMeasurement) float64{
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
164 limitingDepth: (*availMeasurement).getDepth,
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
165 limitingWidth: (*availMeasurement).getWidth,
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
166 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
167
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
168 // afdRefs are the typical available fairway depth reference values.
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
169 var afdRefs = []float64{
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
170 230,
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
171 250,
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
172 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
173
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
174 func (ls ldcs) find(from, to time.Time) *ldc {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
175 for _, l := range ls {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
176 if l.intersects(from, to) {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
177 return l
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
178 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
179 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
180 return nil
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
181 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
182
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
183 func fairwayAvailability(rw http.ResponseWriter, req *http.Request) {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
184
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
185 from, to, ok := parseFromTo(rw, req)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
186 if !ok {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
187 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
188 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
189
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
190 vars := mux.Vars(req)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
191 name := vars["name"]
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
192 if name == "" {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
193 http.Error(rw, "missing 'name' parameter.", http.StatusBadRequest)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
194 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
195 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
196
5226
755d54cd7fd0 Use LOS 3 as a default.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5225
diff changeset
197 los, ok := parseFormInt(rw, req, "los", 3)
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
198 if !ok {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
199 return
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
200 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
201
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
202 ctx := req.Context()
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
203 conn := middleware.GetDBConn(req)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
204
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
205 // Function to extract the bottleneck_id's from the query.
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
206 var extract func(context.Context, *sql.Conn, string, time.Time, time.Time) (bottlenecks, error)
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
207
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
208 switch vars["kind"] {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
209 case "bottleneck":
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
210 extract = extractBottleneck
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
211 case "stretch":
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
212 extract = extractStretch
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
213 case "section":
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
214 extract = extractSection
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
215 default:
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
216 http.Error(rw, "Invalid kind type.", http.StatusBadRequest)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
217 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
218 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
219
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
220 bottlenecks, err := extract(ctx, conn, name, from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
221 if err != nil {
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
222 log.Printf("error: %v\n", err)
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
223 http.Error(rw, "cannot extract bottlenecks", http.StatusBadRequest)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
224 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
225 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
226
5211
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
227 // If there are no bottlenecks there is nothing to do.
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
228 if len(bottlenecks) == 0 {
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
229 http.Error(rw, "No bottlenecks found.", http.StatusNotFound)
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
230 return
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
231 }
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
232
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
233 // load validities and limiting factors
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
234 for i := range bottlenecks {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
235 if err := bottlenecks[i].loadLimitingValidities(ctx, conn, from, to); err != nil {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
236 log.Printf("error: %v\n", err)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
237 http.Error(rw, "cannot load validities", http.StatusInternalServerError)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
238 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
239 }
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
240 // load LCDs
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
241 if err := bottlenecks[i].loadLDCs(ctx, conn, from, to); err != nil {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
242 log.Printf("error: %v\n", err)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
243 http.Error(rw, "cannot load LDCs", http.StatusInternalServerError)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
244 return
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
245 }
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
246 // load values
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
247 if err := bottlenecks[i].loadValues(ctx, conn, from, to, los); err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
248 log.Printf("error: %v\n", err)
5230
40c9acd114cd Added missing parameter to SQL query.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5228
diff changeset
249 http.Error(rw, "cannot load values", http.StatusInternalServerError)
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
250 return
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
251 }
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
252 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
253
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
254 // separate breaks for depth and width
5212
6c316a4d3386 Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5211
diff changeset
255 var (
5214
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
256 breaks = parseBreaks(req.FormValue("breaks"), afdRefs)
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
257 depthBreaks = parseBreaks(req.FormValue("depthbreaks"), breaks)
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
258 widthBreaks = parseBreaks(req.FormValue("widthbreaks"), breaks)
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
259 chooseBreaks = [...][]float64{
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
260 limitingDepth: depthBreaks,
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
261 limitingWidth: widthBreaks,
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
262 }
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
263
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
264 useDepth = bottlenecks.hasLimiting(limitingDepth, from, to)
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
265 useWidth = bottlenecks.hasLimiting(limitingWidth, from, to)
5212
6c316a4d3386 Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5211
diff changeset
266 )
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
267
5212
6c316a4d3386 Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5211
diff changeset
268 if useDepth && useWidth && len(widthBreaks) != len(depthBreaks) {
5211
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
269 http.Error(
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
270 rw,
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
271 fmt.Sprintf("class breaks lengths differ: %d != %d",
5212
6c316a4d3386 Pull breaks from the request parameters.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5211
diff changeset
272 len(widthBreaks), len(depthBreaks)),
5211
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
273 http.StatusBadRequest,
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
274 )
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
275 return
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
276 }
8d582b5ff71e Some checks to prevent trivial errors.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5210
diff changeset
277
5221
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
278 availability := vars["type"] == "availability"
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
279
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
280 var record []string
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
281 if availability {
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
282 // in days
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
283 record = makeHeader(useDepth && useWidth, 1, breaks, 'd')
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
284 } else {
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
285 // percentage
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
286 record = makeHeader(useDepth && useWidth, 3, breaks, '%')
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
287 }
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
288
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
289 rw.Header().Add("Content-Type", "text/csv")
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
290
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
291 out := csv.NewWriter(rw)
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
292
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
293 if err := out.Write(record); err != nil {
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
294 // Too late for HTTP status message.
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
295 log.Printf("error: %v\n", err)
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
296 return
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
297 }
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
298
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
299 for i := range record[1:] {
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
300 record[i+1] = "0.0"
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
301 }
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
302
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
303 // For every day on every bottleneck we need to find out if this day is valid.
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
304 validities := make([]func(time.Time, time.Time) *limitingValidity, len(bottlenecks))
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
305 for i := range bottlenecks {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
306 validities[i] = bottlenecks[i].validities.find()
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
307 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
308
5227
fa55f403985b Added a comment about the mode.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5226
diff changeset
309 // Mode reflects if we use monthly, quarterly od yearly intervals.
5208
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
310 mode := parseFWAMode(req.FormValue("mode"))
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
311
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
312 label, finish := interval(mode, from)
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
313
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
314 var (
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
315 totalDays, overLDCDays int
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
316 missingLDCs = make([]int, len(validities))
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
317 counters = make([]int, len(validities))
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
318 )
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
319
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
320 // We step through the time in steps of one day.
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
321 for current := from; current.Before(to); {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
322
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
323 next := current.AddDate(0, 0, 1)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
324
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
325 // Assume that a bottleneck is over LDC.
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
326 overLDC := true
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
327 highest := -1
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
328
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
329 // check all bottlenecks
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
330 for i, validity := range validities {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
331
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
332 // Check if bottleneck is available for this day.
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
333 vs := validity(current, next)
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
334 if vs == nil {
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
335 continue
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
336 }
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
337
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
338 // Let's see if we have a LDC for this day.
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
339 ldc := vs.ldcs.find(current, next)
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
340 if ldc == nil {
5217
70d83b7d36ef Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5216
diff changeset
341 missingLDCs[i]++
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
342 continue
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
343 }
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
344
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
345 if overLDC { // If its already not shipable we need no further tests.
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
346 result := bottlenecks[i].measurements.classify(
5214
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
347 current, next,
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
348 ldc.value,
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
349 (*availMeasurement).getValue)
5214
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
350
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
351 if result[1] < 12*time.Hour {
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
352 overLDC = false
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
353 }
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
354 }
5214
ebcf33d79d2e Use breaks to classfify.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5213
diff changeset
355
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
356 if min := minClass(bottlenecks[i].measurements.classify(
5216
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
357 current, next,
91feaf7ac486 Started to accumulate time segments.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5215
diff changeset
358 chooseBreaks[vs.limiting],
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
359 limitingAccess[vs.limiting]),
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
360 12*time.Hour,
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
361 ); min > highest {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
362 highest = min
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
363 }
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
364 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
365
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
366 if overLDC {
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
367 overLDCDays++
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
368 }
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
369 if highest > -1 {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
370 counters[highest]++
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
371 }
5224
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
372 totalDays++
5208
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
373
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
374 if finish(next) {
5224
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
375 record[0] = label(current)
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
376
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
377 if availability {
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
378 record[1] = strconv.Itoa(totalDays - overLDCDays)
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
379 record[2] = strconv.Itoa(overLDCDays)
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
380 for i, c := range counters {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
381 record[3+i] = strconv.Itoa(c)
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
382 }
5224
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
383 } else {
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
384 overPerc := float64(overLDCDays) * 100 / float64(totalDays)
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
385 record[1] = fmt.Sprintf("%.3f", 100-overPerc)
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
386 record[2] = fmt.Sprintf("%.3f", overPerc)
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
387 for i, c := range counters {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
388 perc := float64(c) * 100 / float64(totalDays)
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
389 record[3+i] = fmt.Sprintf("%.3f", perc)
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
390 }
5224
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
391 }
fc999a902d87 Write LCD columns.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5223
diff changeset
392
5239
158a26bcb2af Write the data out!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5236
diff changeset
393 if err := out.Write(record); err != nil {
158a26bcb2af Write the data out!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5236
diff changeset
394 // Too late for HTTP status message.
158a26bcb2af Write the data out!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5236
diff changeset
395 log.Printf("error: %v\n", err)
158a26bcb2af Write the data out!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5236
diff changeset
396 return
158a26bcb2af Write the data out!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5236
diff changeset
397 }
158a26bcb2af Write the data out!
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5236
diff changeset
398
5208
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
399 // Reset counters
5228
f3a88039d822 Renamed variable shipable to overLDC to remove implicit semantics.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5227
diff changeset
400 overLDCDays, totalDays = 0, 0
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
401 for i := range counters {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
402 counters[i] = 0
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
403 }
5208
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
404 }
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
405
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
406 current = next
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
407 }
5217
70d83b7d36ef Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5216
diff changeset
408
70d83b7d36ef Track the number days LDCs are not available at bottlenecks.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5216
diff changeset
409 // TODO: Log missing LDCs
5221
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
410
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
411 out.Flush()
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
412 if err := out.Error(); err != nil {
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
413 // Too late for HTTP status message.
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
414 log.Printf("error: %v\n", err)
6794e85dc2dd Write headers.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5220
diff changeset
415 }
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
416 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
417
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
418 func minClass(classes []time.Duration, threshold time.Duration) int {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
419 var sum time.Duration
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
420 for i, v := range classes {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
421 if sum += v; sum >= threshold {
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
422 return i
5225
c5599966befe find minima of each class.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5224
diff changeset
423 }
c5599966befe find minima of each class.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5224
diff changeset
424 }
5236
b47a041e03c4 Fill classification columns in CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5234
diff changeset
425 return -1
5225
c5599966befe find minima of each class.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5224
diff changeset
426 }
c5599966befe find minima of each class.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5224
diff changeset
427
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
428 func dusk(t time.Time) time.Time {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
429 return time.Date(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
430 t.Year(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
431 t.Month(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
432 t.Day(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
433 0, 0, 0, 0,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
434 t.Location())
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
435 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
436
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
437 func dawn(t time.Time) time.Time {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
438 return time.Date(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
439 t.Year(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
440 t.Month(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
441 t.Day(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
442 23, 59, 59, 999999999,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
443 t.Location())
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
444 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
445
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
446 func parseFromTo(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
447 rw http.ResponseWriter,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
448 req *http.Request,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
449 ) (time.Time, time.Time, bool) {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
450 from, ok := parseFormTime(rw, req, "from", time.Now().AddDate(-1, 0, 0))
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
451 if !ok {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
452 return time.Time{}, time.Time{}, false
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
453 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
454
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
455 to, ok := parseFormTime(rw, req, "to", from.AddDate(1, 0, 0))
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
456 if !ok {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
457 return time.Time{}, time.Time{}, false
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
458 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
459
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
460 from, to = common.OrderTime(from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
461 // Operate on daily basis so go to full days.
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
462 return dusk(from), dawn(to), true
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
463 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
464
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
465 func parseFWAMode(mode string) fwaMode {
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
466 switch strings.ToLower(mode) {
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
467 case "monthly":
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
468 return fwaMonthly
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
469 case "quarterly":
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
470 return fwaQuarterly
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
471 case "yearly":
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
472 return fwaYearly
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
473 default:
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
474 return fwaMonthly
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
475 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
476 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
477
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
478 func breaksToReferenceValue(breaks string) []float64 {
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
479 parts := strings.Split(breaks, ",")
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
480 var values []float64
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
481
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
482 for _, part := range parts {
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
483 part = strings.TrimSpace(part)
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
484 if v, err := strconv.ParseFloat(part, 64); err == nil {
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
485 values = append(values, v)
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
486 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
487 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
488
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
489 return common.DedupFloat64s(values)
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
490 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
491
5213
de417840dfee Made breaks defaults more sensible
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5212
diff changeset
492 func parseBreaks(breaks string, defaults []float64) []float64 {
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
493 if breaks != "" {
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
494 return breaksToReferenceValue(breaks)
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
495 }
5213
de417840dfee Made breaks defaults more sensible
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5212
diff changeset
496 return defaults
5204
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
497 }
7ca9e6c9a203 Introduced type for mode (monthly, quarterly, yearly).
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5203
diff changeset
498
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
499 func (tr *timeRange) intersects(from, to time.Time) bool {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
500 return !(to.Before(tr.lower) || from.After(tr.upper))
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
501 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
502
5201
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
503 func (tr *timeRange) toUTC() {
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
504 tr.lower = tr.lower.UTC()
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
505 tr.upper = tr.upper.UTC()
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
506 }
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
507
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
508 func (lvs limitingValidities) find() func(from, to time.Time) *limitingValidity {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
509
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
510 var last *limitingValidity
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
511
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
512 return func(from, to time.Time) *limitingValidity {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
513 if last != nil && last.intersects(from, to) {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
514 return last
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
515 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
516 for i := range lvs {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
517 if lv := &lvs[i]; lv.intersects(from, to) {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
518 last = lv
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
519 return lv
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
520 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
521 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
522 return nil
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
523 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
524 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
525
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
526 func (lvs limitingValidities) hasLimiting(limiting limitingFactor, from, to time.Time) bool {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
527 for i := range lvs {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
528 if lvs[i].limiting == limiting && lvs[i].intersects(from, to) {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
529 return true
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
530 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
531 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
532 return false
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
533 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
534
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
535 func (bns bottlenecks) hasLimiting(limiting limitingFactor, from, to time.Time) bool {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
536 for i := range bns {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
537 if bns[i].validities.hasLimiting(limiting, from, to) {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
538 return true
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
539 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
540 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
541 return false
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
542 }
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
543
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
544 func parseLimitingFactor(limiting string) limitingFactor {
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
545 switch limiting {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
546 case "depth":
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
547 return limitingDepth
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
548 case "width":
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
549 return limitingWidth
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
550 default:
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
551 log.Printf("warn: unknown limitation '%s'. default to 'depth'\n", limiting)
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
552 return limitingDepth
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
553 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
554 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
555
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
556 func loadLimitingValidities(
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
557 ctx context.Context,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
558 conn *sql.Conn,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
559 bottleneckID string,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
560 from, to time.Time,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
561 ) (limitingValidities, error) {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
562
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
563 var lvs limitingValidities
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
564
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
565 rows, err := conn.QueryContext(
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
566 ctx,
5223
d4e4f7232513 Removed old bottlenecks controller.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5221
diff changeset
567 selectBottlenecksLimitingSQL,
5230
40c9acd114cd Added missing parameter to SQL query.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5228
diff changeset
568 bottleneckID,
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
569 from, to)
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
570
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
571 if err != nil {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
572 return nil, err
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
573 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
574 defer rows.Close()
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
575
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
576 for rows.Next() {
5231
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
577 var (
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
578 lv limitingValidity
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
579 limiting string
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
580 upper sql.NullTime
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
581 )
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
582 if err := rows.Scan(
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
583 &lv.lower,
5231
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
584 &upper,
5233
d6374435111a Fixed order of parameters in SQL result.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5232
diff changeset
585 &limiting,
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
586 ); err != nil {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
587 return nil, err
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
588 }
5231
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
589 if upper.Valid {
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
590 lv.upper = upper.Time
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
591 } else {
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
592 lv.upper = to.Add(24 * time.Hour)
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
593 }
5201
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
594 lv.toUTC()
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
595 lv.limiting = parseLimitingFactor(limiting)
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
596 lvs = append(lvs, lv)
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
597 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
598
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
599 return lvs, rows.Err()
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
600 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
601
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
602 func loadSymbolBottlenecksFromTo(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
603 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
604 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
605 what, name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
606 from, to time.Time,
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
607 ) (bottlenecks, error) {
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
608
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
609 rows, err := conn.QueryContext(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
610 ctx,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
611 fmt.Sprintf(selectSymbolBottlenecksSQL, what),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
612 name,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
613 from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
614 if err != nil {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
615 return nil, err
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
616 }
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
617 defer rows.Close()
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
618
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
619 var bns bottlenecks
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
620
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
621 for rows.Next() {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
622 var b bottleneck
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
623 if err := rows.Scan(&b.id); err != nil {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
624 return nil, err
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
625 }
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
626 bns = append(bns, b)
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
627 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
628
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
629 return bns, rows.Err()
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
630 }
5195
d6710d29516b Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5184
diff changeset
631
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
632 func extractBottleneck(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
633 _ context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
634 _ *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
635 name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
636 _, _ time.Time,
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
637 ) (bottlenecks, error) {
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
638 return bottlenecks{{id: name}}, nil
5196
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
639 }
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
640
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
641 func extractStretch(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
642 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
643 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
644 name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
645 from, to time.Time,
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
646 ) (bottlenecks, error) {
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
647 return loadSymbolBottlenecksFromTo(
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
648 ctx,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
649 conn,
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
650 "stretches", name,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
651 from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
652 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
653
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
654 func extractSection(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
655 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
656 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
657 name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
658 from, to time.Time,
5210
da6eb8073f77 Introduce separate breaks from depths and widths.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5209
diff changeset
659 ) (bottlenecks, error) {
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
660 return loadSymbolBottlenecksFromTo(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
661 ctx,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
662 conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
663 "sections", name,
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
664 from, to)
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
665 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
666
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
667 func (bn *bottleneck) loadLimitingValidities(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
668 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
669 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
670 from, to time.Time,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
671 ) error {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
672 vs, err := loadLimitingValidities(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
673 ctx,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
674 conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
675 bn.id,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
676 from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
677 if err == nil {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
678 bn.validities = vs
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
679 }
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
680 return err
5195
d6710d29516b Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5184
diff changeset
681 }
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
682
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
683 func (bn *bottleneck) loadLDCs(
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
684 ctx context.Context,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
685 conn *sql.Conn,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
686 from, to time.Time,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
687 ) error {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
688 rows, err := conn.QueryContext(
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
689 ctx, selectLDCsSQL,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
690 bn.id,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
691 from, to)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
692 if err != nil {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
693 return err
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
694 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
695 defer rows.Close()
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
696 for rows.Next() {
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
697 l := ldc{value: []float64{0}}
5231
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
698 var upper sql.NullTime
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
699 if err := rows.Scan(&l.lower, &upper, &l.value[0]); err != nil {
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
700 return err
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
701 }
5231
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
702 if upper.Valid {
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
703 l.upper = upper.Time
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
704 } else {
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
705 l.upper = to.Add(24 * time.Hour)
225b2d0a1824 Validities may have an NULL upper bound.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5230
diff changeset
706 }
5201
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
707 l.toUTC()
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
708 for i := range bn.validities {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
709 vs := bn.validities[i]
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
710 if vs.intersects(l.lower, l.upper) {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
711 vs.ldcs = append(vs.ldcs, &l)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
712 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
713 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
714 }
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
715 return rows.Err()
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
716 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
717
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
718 func (bn *bottleneck) loadValues(
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
719 ctx context.Context,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
720 conn *sql.Conn,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
721 from, to time.Time,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
722 los int,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
723 ) error {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
724 rows, err := conn.QueryContext(
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
725 ctx, selectMeasurementsSQL,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
726 bn.id,
5234
30a55f46996f Another swapped sql parameter.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5233
diff changeset
727 los,
30a55f46996f Another swapped sql parameter.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5233
diff changeset
728 from, to)
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
729 if err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
730 return err
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
731 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
732 defer rows.Close()
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
733
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
734 var ms availMeasurements
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
735
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
736 for rows.Next() {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
737 var m availMeasurement
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
738 if err := rows.Scan(
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
739 &m.when,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
740 &m.depth,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
741 &m.width,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
742 &m.value,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
743 ); err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
744 return err
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
745 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
746 m.when = m.when.UTC()
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
747 ms = append(ms, m)
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
748 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
749 if err := rows.Err(); err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
750 return err
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
751 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
752 bn.measurements = ms
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
753 return nil
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
754 }
5203
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
755
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
756 func (measurement *availMeasurement) getDepth() float64 {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
757 return float64(measurement.depth)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
758 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
759
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
760 func (measurement *availMeasurement) getValue() float64 {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
761 return float64(measurement.value)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
762 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
763
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
764 func (measurement *availMeasurement) getWidth() float64 {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
765 return float64(measurement.width)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
766 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
767
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
768 func (measurements availMeasurements) classify(
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
769 from, to time.Time,
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
770 breaks []float64,
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
771 access func(*availMeasurement) float64,
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
772 ) []time.Duration {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
773
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
774 if len(breaks) == 0 {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
775 return []time.Duration{}
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
776 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
777
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
778 result := make([]time.Duration, len(breaks)+1)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
779 classes := make([]float64, len(breaks)+2)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
780 values := make([]time.Time, len(classes))
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
781
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
782 // Add sentinels
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
783 classes[0] = breaks[0] - 9999
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
784 classes[len(classes)-1] = breaks[len(breaks)-1] + 9999
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
785 for i := range breaks {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
786 classes[i+1] = breaks[i]
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
787 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
788
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
789 idx := sort.Search(len(measurements), func(i int) bool {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
790 // All values before from can be ignored.
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
791 return !measurements[i].when.Before(from)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
792 })
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
793
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
794 if idx >= len(measurements) {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
795 return result
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
796 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
797
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
798 // Be safe for interpolation.
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
799 if idx > 0 {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
800 idx--
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
801 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
802
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
803 measurements = measurements[idx:]
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
804
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
805 for i := 0; i < len(measurements)-1; i++ {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
806 p1 := &measurements[i]
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
807 p2 := &measurements[i+1]
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
808
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
809 if p1.when.After(to) {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
810 return result
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
811 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
812
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
813 if p2.when.Before(from) {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
814 continue
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
815 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
816
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
817 if p2.when.Sub(p1.when).Hours() > 1.5 {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
818 // Don't interpolate ranges bigger then one and a half hour
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
819 continue
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
820 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
821
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
822 lo, hi := common.MaxTime(p1.when, from), common.MinTime(p2.when, to)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
823
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
824 m1, m2 := access(p1), access(p2)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
825 if m1 == m2 { // The whole interval is in only one class.
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
826 for j := 0; j < len(classes)-1; j++ {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
827 if classes[j] <= m1 && m1 <= classes[j+1] {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
828 result[j] += hi.Sub(lo)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
829 break
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
830 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
831 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
832 continue
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
833 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
834
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
835 f := common.InterpolateTime(
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
836 p1.when, m1,
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
837 p2.when, m2,
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
838 )
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
839
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
840 for j, c := range classes {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
841 values[j] = f(c)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
842 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
843
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
844 for j := 0; j < len(values)-1; j++ {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
845 start, end := common.OrderTime(values[j], values[j+1])
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
846
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
847 if start.After(hi) || end.Before(lo) {
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
848 continue
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
849 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
850
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
851 start, end = common.MaxTime(start, lo), common.MinTime(end, hi)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
852 result[j] += end.Sub(start)
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
853 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
854 }
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
855
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
856 return result
355195a90298 Start calculting the navigability. TODO: accumulate and do output.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5202
diff changeset
857 }
5208
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
858
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
859 func interval(mode fwaMode, t time.Time) (
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
860 label func(time.Time) string,
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
861 finish func(time.Time) bool,
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
862 ) {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
863 switch mode {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
864 case fwaMonthly:
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
865 label, finish = monthLabel, otherMonth(t)
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
866 case fwaQuarterly:
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
867 label, finish = quarterLabel, otherQuarter(t)
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
868 case fwaYearly:
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
869 label, finish = yearLabel, otherYear(t)
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
870 default:
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
871 panic("Unknown mode")
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
872 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
873 return
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
874 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
875
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
876 func monthLabel(t time.Time) string {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
877 return fmt.Sprintf("%02d-%d", t.Month(), t.Year())
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
878 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
879
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
880 func quarterLabel(t time.Time) string {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
881 return fmt.Sprintf("Q%d-%d", (int(t.Month())-1)/3+1, t.Year())
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
882 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
883
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
884 func yearLabel(t time.Time) string {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
885 return strconv.Itoa(t.Year())
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
886 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
887
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
888 func otherMonth(t time.Time) func(time.Time) bool {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
889 return func(x time.Time) bool {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
890 flag := t.Day() == x.Day()
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
891 if flag {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
892 t = x
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
893 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
894 return flag
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
895 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
896 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
897
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
898 func otherQuarter(t time.Time) func(time.Time) bool {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
899 return func(x time.Time) bool {
5209
32eb35699bd3 Fixed bug in quarter detection.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5208
diff changeset
900 flag := (t.Month()-1)/3 != (x.Month()-1)/3
5208
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
901 if flag {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
902 t = x
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
903 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
904 return flag
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
905 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
906 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
907
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
908 func otherYear(t time.Time) func(time.Time) bool {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
909 return func(x time.Time) bool {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
910 flag := t.Year() != x.Year()
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
911 if flag {
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
912 t = x
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
913 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
914 return flag
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
915 }
defca5418446 Define how modes work.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5205
diff changeset
916 }
5220
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
917
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
918 func makeHeader(flag bool, prec int, breaks []float64, unit rune) []string {
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
919 record := make([]string, 1+2+len(breaks)+1)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
920 record[0] = "# time"
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
921 record[1] = fmt.Sprintf("# < LDC [%c]", unit)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
922 record[2] = fmt.Sprintf("# >= LDC [%c]", unit)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
923 for i, v := range breaks {
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
924 if flag {
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
925 if i == 0 {
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
926 record[3] = fmt.Sprintf("# < break_1 [%c]", unit)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
927 }
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
928 record[i+4] = fmt.Sprintf("# >= break_%d [%c]", i+1, unit)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
929 } else {
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
930 if i == 0 {
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
931 record[3] = fmt.Sprintf("# < %.*f [%c]", prec, v, unit)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
932 }
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
933 record[i+4] = fmt.Sprintf("# >= %.*f [%c]", prec, v, unit)
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
934 }
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
935 }
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
936 return record
142ac550bd9a Unify headers for CSV export.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5218
diff changeset
937 }