X-Git-Url: https://git.toastfreeware.priv.at/chrisu/seepark.git/blobdiff_plain/7157d90050101aa4149f126cccf275622d7a4e17..bc07cbc61c74ba84791b67b170b43b293aa7230e:/web/seepark_web.py diff --git a/web/seepark_web.py b/web/seepark_web.py index b132960..edde374 100644 --- a/web/seepark_web.py +++ b/web/seepark_web.py @@ -1,4 +1,3 @@ -from random import uniform import datetime import time import configparser @@ -86,16 +85,16 @@ def select_sensordata(sensor_id, sensor_type, begin, end, mode): ) 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() @@ -239,36 +238,6 @@ def openweathermap_city(version, cityid): return jsonify(result) -@app.route('/data/', defaults={'timespan': 1}) -@app.route("/data/", 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)