Mercurial > gemma

comparison pkg/controllers/gauges.go @ 2817:ff58440ce809

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added staging_done to the longterm waterlevels selections.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 27 Mar 2019 10:19:31 +0100
parents 6f435a9558f2
children f7ae108c2838
comparison
equal deleted inserted replaced
2816:c02cebff3f16 2817:ff58440ce809
83 percentile_disc(0.75) within group (order by water_level) AS q75, 83 percentile_disc(0.75) within group (order by water_level) AS q75,
84 avg(water_level) AS mean, 84 avg(water_level) AS mean,
85 min(water_level) AS min, 85 min(water_level) AS min,
86 max(water_level) AS max 86 max(water_level) AS max
87 FROM waterway.gauge_measurements, g 87 FROM waterway.gauge_measurements, g
88 WHERE fk_gauge_id = g.loc AND NOT predicted 88 WHERE fk_gauge_id = g.loc AND NOT predicted AND staging_done
89 GROUP BY extract(day from measure_date)::varchar || ':' || 89 GROUP BY extract(day from measure_date)::varchar || ':' ||
90 extract(month from measure_date)::varchar; 90 extract(month from measure_date)::varchar;
91 ` 91 `
92 selectYearWaterlevelsMeasuredSQL = ` 92 selectYearWaterlevelsMeasuredSQL = `
93 SELECT 93 SELECT
94 measure_date, 94 measure_date,
95 water_level 95 water_level
96 FROM waterway.gauge_measurements 96 FROM waterway.gauge_measurements
97 WHERE 97 WHERE
98 NOT predicted 98 NOT predicted AND
99 AND fk_gauge_id = ( 99 staging_done AND
100 fk_gauge_id = (
100 $1::char(2), 101 $1::char(2),
101 $2::char(3), 102 $2::char(3),
102 $3::char(5), 103 $3::char(5),
103 $4::char(5), 104 $4::char(5),
104 $5::int 105 $5::int