From: Philipp Spitzer <philipp@spitzer.priv.at>
Date: Wed, 22 Aug 2018 19:33:41 +0000 (+0200)
Subject: Add a sqlalchemy group by/having example
X-Git-Url: https://git.toastfreeware.priv.at/chrisu/seepark.git/commitdiff_plain/b44534d53c10d7c9a4462e9b20b420c00152331b

Add a sqlalchemy group by/having example
---

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()