From 6ef9ae998a4750daf95dfcea1c4bfd195a0d3f39 Mon Sep 17 00:00:00 2001 From: Philipp Spitzer Date: Wed, 22 Aug 2018 23:29:59 +0200 Subject: [PATCH] Fix begin and end in select_openweatherdata_grouped. --- web/seepark_web.py | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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() -- 2.47.3