X-Git-Url: https://git.toastfreeware.priv.at/chrisu/seepark.git/blobdiff_plain/4e2a6e018609488515cc81942a46254e33f06a7c..a61d8c6406e1a7724c8c55e96f0e372eaea86b20:/web/seepark_web.py diff --git a/web/seepark_web.py b/web/seepark_web.py index 42bbf30..0870a12 100644 --- a/web/seepark_web.py +++ b/web/seepark_web.py @@ -134,8 +134,8 @@ def select_openweatherdata_grouped(cityid, begin, end): func.avg(OpenWeatherMap.temp).label('temp'), OpenWeatherMap.cityid) OpenWeatherMap.query.filter(OpenWeatherMap.cityid == cityid) - query = query.filter(Sensors.timestamp >= begin) - query = query.filter(Sensors.timestamp <= end) + query = query.filter(OpenWeatherMap.datetime >= begin) + query = query.filter(OpenWeatherMap.datetime <= end) query = query.group_by('g', OpenWeatherMap.cityid) return query.all()