Mercurial > gemma

annotate pkg/controllers/fwa.go @ 5202:fbc79c8459b4 new-fwa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Load water values, too.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 08 May 2020 15:59:44 +0200
parents 40daecc6f552
children 355195a90298
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"
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
19 "fmt"
5195
d6710d29516b Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5184
diff changeset
20 "log"
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
21 "net/http"
5196
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
22 "time"
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
23
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
24 "github.com/gorilla/mux"
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
25
5196
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
26 "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
27 "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
28 )
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
29
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
30 const (
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
31 selectBottlenecksLimitingSQL = `
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
32 SELECT
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
33 lower(validity),
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
34 upper(validity),
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
35 limiting
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
36 FROM
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
37 waterway.bottlenecks
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
38 WHERE
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
39 bottleneck_id = $1 AND
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
40 validity && tstzrange($2, $3)`
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
41
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
42 selectSymbolBottlenecksSQL = `
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
43 SELECT
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
44 distinct(b.bottleneck_id)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
45 FROM
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
46 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
47 WHERE
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
48 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
49 AND s.name = $1
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
50 AND b.validity && tstzrange($2, $3)`
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
51
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
52 selectLDCsSQL = `
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
53 SELECT
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
54 lower(grwl.validity),
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
55 upper(grwl.validity),
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
56 grwl.value
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
57 FROM
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
58 waterway.gauges_reference_water_levels grwl
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
59 JOIN waterway.bottlenecks bns
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
60 ON grwl.location = bns.gauge_location
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
61 WHERE
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
62 grwl.depth_reference like 'LDC%'
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
63 AND bns.bottleneck_id = $1
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
64 AND grwl.validity && tstzrange($2, $3)`
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
65
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
66 selectMeasurementsSQL = `
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
67 WITH data AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
68 SELECT
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
69 efa.measure_date,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
70 efa.available_depth_value,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
71 efa.available_width_value,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
72 efa.water_level_value
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
73 FROM waterway.effective_fairway_availability efa
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
74 JOIN waterway.fairway_availability fa
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
75 ON efa.fairway_availability_id = fa.id
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
76 JOIN waterway.bottlenecks bn
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
77 ON fa.bottleneck_id = bn.bottleneck_id
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
78 WHERE
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
79 bn.bottleneck_id = $1 AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
80 efa.level_of_service = $2 AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
81 efa.measure_type = 'Measured' AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
82 (efa.available_depth_value IS NOT NULL OR
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
83 efa.available_width_value IS NOT NULL) AND
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
84 efa.water_level_value IS NOT NULL
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
85 ),
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
86 before AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
87 SELECT * FROM data WHERE measure_date < $3
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
88 ORDER BY measure_date DESC LIMIT 1
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 inside AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
91 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
92 ),
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
93 after AS (
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
94 SELECT * FROM data WHERE measure_date > $4
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
95 ORDER BY measure_date LIMIT 1
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 SELECT * FROM before
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
98 UNION ALL
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
99 SELECT * FROM inside
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
100 UNION ALL
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
101 SELECT * FROM after
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
102 ORDER BY measure_date`
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
103 )
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
104
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
105 type (
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
106 timeRange struct {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
107 lower time.Time
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
108 upper time.Time
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
109 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
110
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
111 ldc struct {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
112 timeRange
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
113 value float64
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
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
116 limitingValidity struct {
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
117 timeRange
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
118 limiting string
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
119 ldcs []*ldc
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
120 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
121
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
122 limitingValidities []limitingValidity
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
123
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
124 availMeasurement struct {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
125 when time.Time
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
126 depth int16
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
127 width int16
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
128 value int16
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
129 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
130
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
131 availMeasurements []availMeasurement
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
132
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
133 bottleneck struct {
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
134 id string
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
135 validities limitingValidities
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
136 measurements availMeasurements
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
137 }
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
138 )
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
139
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
140 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
141
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
142 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
143 if !ok {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
144 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
145 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
146
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
147 vars := mux.Vars(req)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
148 name := vars["name"]
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
149 if name == "" {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
150 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
151 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
152 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
153
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
154 los, ok := parseFormInt(rw, req, "los", 1)
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
155 if !ok {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
156 return
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
157 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
158
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
159 ctx := req.Context()
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
160 conn := middleware.GetDBConn(req)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
161
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
162 // Function to extract the bottleneck_id's from the query.
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
163 var extract func(context.Context, *sql.Conn, string, time.Time, time.Time) ([]bottleneck, error)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
164
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
165 switch vars["kind"] {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
166 case "bottleneck":
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
167 extract = extractBottleneck
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
168 case "stretch":
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
169 extract = extractStretch
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
170 case "section":
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
171 extract = extractSection
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
172 default:
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
173 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
174 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
175 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
176
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
177 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
178 if err != nil {
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
179 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
180 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
181 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
182 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
183
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
184 // load validities and limiting factors
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
185 for i := range bottlenecks {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
186 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
187 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
188 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
189 return
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
190 }
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
191 // load LCDs
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
192 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
193 log.Printf("error: %v\n", err)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
194 http.Error(rw, "cannot load LDCs", http.StatusInternalServerError)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
195 return
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
196 }
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
197 // load values
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
198 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
199 log.Printf("error: %v\n", err)
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
200 http.Error(rw, "cannot load LDCs", http.StatusInternalServerError)
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
201 return
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
202 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
203
5199
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
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
206 // TODO: Implement me!
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
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
209 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
210 return time.Date(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
211 t.Year(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
212 t.Month(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
213 t.Day(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
214 0, 0, 0, 0,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
215 t.Location())
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
216 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
217
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
218 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
219 return time.Date(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
220 t.Year(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
221 t.Month(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
222 t.Day(),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
223 23, 59, 59, 999999999,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
224 t.Location())
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
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
227 func parseFromTo(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
228 rw http.ResponseWriter,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
229 req *http.Request,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
230 ) (time.Time, time.Time, bool) {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
231 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
232 if !ok {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
233 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
234 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
235
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
236 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
237 if !ok {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
238 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
239 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
240
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
241 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
242 // 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
243 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
244 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
245
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
246 func (tr *timeRange) intersects(from, to time.Time) bool {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
247 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
248 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
249
5201
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
250 func (tr *timeRange) toUTC() {
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
251 tr.lower = tr.lower.UTC()
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
252 tr.upper = tr.upper.UTC()
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
253 }
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
254
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
255 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
256
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
257 var last *limitingValidity
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
258
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
259 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
260 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
261 return last
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
262 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
263 for i := range lvs {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
264 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
265 last = lv
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
266 return lv
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
267 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
268 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
269 return nil
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
270 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
271 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
272
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
273 func loadLimitingValidities(
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
274 ctx context.Context,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
275 conn *sql.Conn,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
276 bottleneckID string,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
277 from, to time.Time,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
278 ) (limitingValidities, error) {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
279
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
280 var lvs limitingValidities
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
281
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
282 rows, err := conn.QueryContext(
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
283 ctx,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
284 selectLimitingSQL,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
285 from, to)
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
286
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
287 if err != nil {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
288 return nil, err
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
289 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
290 defer rows.Close()
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
291
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
292 for rows.Next() {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
293 var lv limitingValidity
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
294 if err := rows.Scan(
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
295 &lv.limiting,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
296 &lv.lower,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
297 &lv.upper,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
298 ); err != nil {
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
299 return nil, err
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
300 }
5201
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
301 lv.toUTC()
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
302 lvs = append(lvs, lv)
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
303 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
304
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
305 return lvs, rows.Err()
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
306 }
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
307
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
308 func loadSymbolBottlenecksFromTo(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
309 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
310 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
311 what, name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
312 from, to time.Time,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
313 ) ([]bottleneck, error) {
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
314
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
315 rows, err := conn.QueryContext(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
316 ctx,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
317 fmt.Sprintf(selectSymbolBottlenecksSQL, what),
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
318 name,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
319 from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
320 if err != nil {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
321 return nil, err
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
322 }
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
323 defer rows.Close()
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
324
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
325 var bottlenecks []bottleneck
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
326
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
327 for rows.Next() {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
328 var b bottleneck
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
329 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
330 return nil, err
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
331 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
332 bottlenecks = append(bottlenecks, b)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
333 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
334
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
335 return bottlenecks, rows.Err()
5184
445daeefca7b Added controller stub for new fairway availability.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
336 }
5195
d6710d29516b Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5184
diff changeset
337
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
338 func extractBottleneck(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
339 _ context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
340 _ *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
341 name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
342 _, _ time.Time,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
343 ) ([]bottleneck, error) {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
344 return []bottleneck{{id: name}}, nil
5196
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
345 }
5bc8daa986d9 More code movement.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5195
diff changeset
346
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
347 func extractStretch(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
348 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
349 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
350 name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
351 from, to time.Time,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
352 ) ([]bottleneck, error) {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
353 return loadSymbolBottlenecksFromTo(
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
354 ctx,
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
355 conn,
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
356 "stretches", name,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
357 from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
358 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
359
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
360 func extractSection(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
361 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
362 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
363 name string,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
364 from, to time.Time,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
365 ) ([]bottleneck, error) {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
366 return loadSymbolBottlenecksFromTo(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
367 ctx,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
368 conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
369 "sections", name,
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
370 from, to)
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
371 }
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
372
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
373 func (bn *bottleneck) loadLimitingValidities(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
374 ctx context.Context,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
375 conn *sql.Conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
376 from, to time.Time,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
377 ) error {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
378 vs, err := loadLimitingValidities(
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
379 ctx,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
380 conn,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
381 bn.id,
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
382 from, to)
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
383 if err == nil {
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
384 bn.validities = vs
5197
c352dbbf2778 Started with loading limiting factors and validities.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5196
diff changeset
385 }
5199
5001582f2ee1 Prepare to treat stretches and sections, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5197
diff changeset
386 return err
5195
d6710d29516b Started to move code around.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5184
diff changeset
387 }
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
388
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
389 func (bn *bottleneck) loadLDCs(
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
390 ctx context.Context,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
391 conn *sql.Conn,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
392 from, to time.Time,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
393 ) error {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
394 rows, err := conn.QueryContext(
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
395 ctx, selectLDCsSQL,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
396 bn.id,
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
397 from, to)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
398 if err != nil {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
399 return err
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
400 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
401 defer rows.Close()
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
402 for rows.Next() {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
403 var l ldc
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
404 if err := rows.Scan(&l.lower, &l.upper, &l.value); err != nil {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
405 return err
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
406 }
5201
40daecc6f552 Made timeranges all UTC.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5200
diff changeset
407 l.toUTC()
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
408 for i := range bn.validities {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
409 vs := bn.validities[i]
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
410 if vs.intersects(l.lower, l.upper) {
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
411 vs.ldcs = append(vs.ldcs, &l)
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
412 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
413 }
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
414 }
5202
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
415 return rows.Err()
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
416 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
417
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
418 func (bn *bottleneck) loadValues(
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
419 ctx context.Context,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
420 conn *sql.Conn,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
421 from, to time.Time,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
422 los int,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
423 ) error {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
424 rows, err := conn.QueryContext(
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
425 ctx, selectMeasurementsSQL,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
426 bn.id,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
427 from, to,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
428 los)
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
429 if err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
430 return err
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
431 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
432 defer rows.Close()
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
433
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
434 var ms availMeasurements
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
435
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
436 for rows.Next() {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
437 var m availMeasurement
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
438 if err := rows.Scan(
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
439 &m.when,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
440 &m.depth,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
441 &m.width,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
442 &m.value,
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
443 ); err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
444 return err
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
445 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
446 m.when = m.when.UTC()
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
447 ms = append(ms, m)
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
448 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
449 if err := rows.Err(); err != nil {
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
450 return err
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
451 }
fbc79c8459b4 Load water values, too.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5201
diff changeset
452 bn.measurements = ms
5200
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
453 return nil
5572da077c89 Load LDCs.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 5199
diff changeset
454 }