Add a sqlalchemy group by/having example

[chrisu/seepark.git] / web / seepark_web.py

diff --git a/web/seepark_web.py b/web/seepark_web.py
index 72c74e7e6573f44999957daa382926aa2afa4676..9871b040d87bbca510124decb3f2b42e9fd15c8e 100644 (file)
--- a/web/seepark_web.py
+++ b/web/seepark_web.py
@@ -9,12 +9,6 @@ import flask.json
 from flask_sqlalchemy import SQLAlchemy, inspect
 
 
-app_path = os.path.dirname(os.path.realpath(__file__))
-lib_path = os.path.join(app_path, '..')
-sys.path.append(lib_path)
-from seeparklib.openweathermap import openweathermap_json, OpenWeatherMapError
-
-
 # https://stackoverflow.com/a/37350445
 def sqlalchemy_model_to_dict(model):
     return {c.key: getattr(model, c.key)
@@ -96,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()