-from random import uniform
import datetime
import time
import configparser
)
duration = (end - begin).total_seconds()
day = 60 * 60 * 24
- if duration < day:
+ if duration <= day:
resolution = resolutions['day']
- elif duration < 7 * day:
+ elif duration <= 7 * day:
resolution = resolutions['week']
- elif duration < 31 * day:
+ elif duration <= 31 * day:
resolution = resolutions['month']
else:
resolution = resolutions['year']
# TODO: filter out samples from 'result'
- # something like
+ # 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;
return query.all()
return jsonify(result)
-@app.route('/data/', defaults={'timespan': 1})
-@app.route("/data/<int:timespan>", methods=['GET'])
-def data(timespan):
- granularity = 5 * timespan # (every) minute(s) per day
- samples = 60/granularity * 24 * timespan # per hour over whole timespan
- s4m = []
- s4m_x = []
- s5m = []
- s5m_x = []
- end = time.time()
- start = end - samples * granularity * 60
-
- for i in range(int(samples)):
- s4m.append(uniform(-10,30))
- s5m.append(uniform(-10,30))
- s4mt = uniform(start, end)
- s5mt = uniform(start, end)
- s4m_x.append(time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(s4mt)))
- s5m_x.append(time.strftime('%Y-%m-%d %H:%M:%S', time.localtime(s5mt)))
-
- data = {
- '0316a2193bff': s4m,
- '0316a2193bff_x': s4m_x,
- '0316a21383ff': s5m,
- '0316a21383ff_x': s5m_x,
- }
-
- return jsonify(data)
-
-
@app.route("/")
def index():
airvalue, airtime = currentairtemperature(cityid)