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