From b44534d53c10d7c9a4462e9b20b420c00152331b Mon Sep 17 00:00:00 2001 From: Philipp Spitzer Date: Wed, 22 Aug 2018 21:33:41 +0200 Subject: [PATCH] Add a sqlalchemy group by/having example --- web/seepark_web.py | 1 + 1 file changed, 1 insertion(+) diff --git a/web/seepark_web.py b/web/seepark_web.py index 00d122f..9871b04 100644 --- a/web/seepark_web.py +++ b/web/seepark_web.py @@ -90,6 +90,7 @@ def select_sensordata(sensor_id, sensor_type, begin, end, mode): # TODO: filter out samples from 'result' # something like # 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; + # seepark_web.db.session.query(func.to_seconds(Sensors.timestamp).op('div')(60*60*24).label('g'), func.min(Sensors.timestamp), func.min(Sensors.value)).group_by('g').all() return query.all() -- 2.47.3