From 7ca34f80f45e96873eca14f00a31d49f06bf31e1 Mon Sep 17 00:00:00 2001 From: Philipp Spitzer Date: Wed, 1 Aug 2018 21:30:34 +0200 Subject: [PATCH 1/1] Add a working SQL example to group measurements into time slots. --- web/seepark_web.py | 13 +------------ 1 file changed, 1 insertion(+), 12 deletions(-) diff --git a/web/seepark_web.py b/web/seepark_web.py index e8b9da1..7f39c15 100644 --- a/web/seepark_web.py +++ b/web/seepark_web.py @@ -92,18 +92,7 @@ def select_sensordata(sensor_id, sensor_type, begin, end, mode): resolution = resolutions['year'] # TODO: filter out samples from 'result' # something like - # select mean(temperature) from sensors where ... group by mod(timestamp, resolution) - # func.avg(...) - # - # from https://stackoverflow.com/questions/4342370/grouping-into-interval-of-5-minutes-within-a-time-range - # SELECT - # timestamp, -- not sure about that - # name, - # count(b.name) - # FROM time a, id - # WHERE … - # GROUP BY - # UNIX_TIMESTAMP(timestamp) DIV 300, name + # select to_seconds(datetime) DIV (60*60*24) as interval_id, min(datetime), max(datetime), min(temp), avg(temp), max(temp), count(temp) from openweathermap group by interval_id order by interval_id; return query.all() -- 2.47.3