diff options
| -rw-r--r-- | schema.sql | 8 | ||||
| -rw-r--r-- | sensor.py | 104 | ||||
| -rw-r--r-- | static/style.css | 18 | ||||
| -rw-r--r-- | templates/layout.html | 12 | ||||
| -rw-r--r-- | templates/show_entries.html | 19 |
5 files changed, 161 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql new file mode 100644 index 0000000..7652fe8 --- /dev/null +++ b/schema.sql @@ -0,0 +1,8 @@ +drop table if exists weather; +create table weather ( + id integer primary key autoincrement, + date timestamp, + temperature float, + humidity float, + pressure float +); diff --git a/sensor.py b/sensor.py new file mode 100644 index 0000000..b21d51f --- /dev/null +++ b/sensor.py @@ -0,0 +1,104 @@ +# imports +import sqlite3 +from flask import Flask, request, session, g, redirect, url_for, abort, render_template, flash +from contextlib import closing +from datetime import datetime +import pygal + +# configuration +DATABASE = '/tmp/sensors.db' +DEBUG = True +SECRET_KEY = 'development_key' + +# app creation +app = Flask(__name__) +app.config.from_object(__name__) +# To read from settings file, set SENSOR_SETTINGS in envvar +#app.config.from_envvar('SENSOR_SETTINGS', slient=True) + +# initialize database +def init_db(): + with closing(connect_db()) as db: + with app.open_resource('schema.sql', mode='r') as f: + db.cursor().executescript(f.read()) + db.commit() + +# connect to database +def connect_db(): + return sqlite3.connect(app.config['DATABASE']) + +# handle requests +@app.before_request +def before_request(): + g.db = connect_db() + +@app.teardown_request +def teardown_request(exception): + db = getattr(g, 'bd', None) + if db is not None: + db.close() + +# viewing database +@app.route('/') +def show_entries(): + cur = g.db.execute('SELECT date, temperature, humidity, pressure FROM weather ORDER BY id desc') + entries = [dict(date=row[0], temperature=row[1], humidity=row[2], pressure=row[3]) for row in cur.fetchall()] + + return render_template('show_entries.html', weather=entries) + +# drawing graphs +@app.route('/tgraph.svg') +def draw_t_graph(): + cur = g.db.execute('SELECT date, temperature, humidity, pressure FROM weather ORDER BY id desc') + + datetimeline = pygal.DateTimeLine( + x_label_rotation=30, truncate_label=-1, + x_value_formatter=lambda dt: dt.strftime('%d, %b %Y %I:%M %p') + ) + datetimeline.add("Temp", [(datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S.%f'), float(row[1])) for row in cur.fetchall()]) + + return datetimeline.render_response() + +@app.route('/hgraph.svg') +def draw_h_graph(): + cur = g.db.execute('SELECT date, temperature, humidity, pressure FROM weather ORDER BY id desc') + + datetimeline = pygal.DateTimeLine( + x_label_rotation=30, truncate_label=-1, + x_value_formatter=lambda dt: dt.strftime('%d, %b %Y %I:%M %p') + ) + datetimeline.add("Humidity", [(datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S.%f'), float(row[2])) for row in cur.fetchall()]) + + return datetimeline.render_response() + +@app.route('/pgraph.svg') +def draw_p_graph(): + cur = g.db.execute('SELECT date, temperature, humidity, pressure FROM weather ORDER BY id desc') + + datetimeline = pygal.DateTimeLine( + x_label_rotation=30, truncate_label=-1, + x_value_formatter=lambda dt: dt.strftime('%d, %b %Y %I:%M %p') + ) + datetimeline.add("Pressure", [(datetime.strptime(row[0], '%Y-%m-%d %H:%M:%S.%f'), float(row[3])) for row in cur.fetchall()]) + + return datetimeline.render_response() + + +# adding entries to database +@app.route('/data', methods=['POST', 'GET']) +def add_data(): + mkey = request.args.get('key') + if mkey != SECRET_KEY: + abort(401) + temp = request.args.get('temp') + humidity = request.args.get('humidity') + pressure = request.args.get('pressure') + now = datetime.now() + g.db.execute('INSERT INTO weather (date, temperature, humidity, pressure) VALUES (?, ?, ?, ?)', \ + [now, temp, humidity, pressure]) + g.db.commit() + return render_template('show_entries.html'), 200 + + +if __name__ == '__main__': + app.run() diff --git a/static/style.css b/static/style.css new file mode 100644 index 0000000..da1cb34 --- /dev/null +++ b/static/style.css @@ -0,0 +1,18 @@ +body { font-family: sans-serif; background: #eee; } +a, h1, h2 { color: #377ba8; } +h1, h2 { font-family: 'Georgia', serif; margin: 0; } +h1 { border-bottom: 2px solid #eee; } +h2 { font-size: 1.2em; } + +.page { margin: 2em auto; width: 35em; border: 5px solid #ccc; + padding: 0.8em; background: white; } +.weather { list-style: none; margin: 0; padding: 0; } +.weather li { margin: 0.8em 1.2em; } +.weather li h2 { margin-left: -1em; } +.add-entry { font-size: 0.9em; border-bottom: 1px solid #ccc; } +.add-entry dl { font-weight: bold; } +.metanav { text-align: right; font-size: 0.8em; padding: 0.3em; + margin-bottom: 1em; background: #fafafa; } +.flash { background: #cee5F5; padding: 0.5em; + border: 1px solid #aacbe2; } +.error { background: #f0d6d6; padding: 0.5em; } diff --git a/templates/layout.html b/templates/layout.html new file mode 100644 index 0000000..2a06690 --- /dev/null +++ b/templates/layout.html @@ -0,0 +1,12 @@ +<!doctype html> +<title>Weather</title> +<link rel=stylesheet type=text/css href="{{ url_for('static', filename='style.css') }}"> +<div class=page> + <h1>Weather</h1> + <div class=metanav> + </div> + {% for message in get_flashed_messages() %} + <div class=flash>{{ message }}</div> + {% endfor %} + {% block body %}{% endblock %} +</div> diff --git a/templates/show_entries.html b/templates/show_entries.html new file mode 100644 index 0000000..572f360 --- /dev/null +++ b/templates/show_entries.html @@ -0,0 +1,19 @@ +{% extends "layout.html" %} +{% block body %} + <figure> + <embed type="image/svg+xml" src="/tgraph.svg" /> + </figure> + <figure> + <embed type="image/svg+xml" src="/hgraph.svg" /> + </figure> + <figure> + <embed type="image/svg+xml" src="/pgraph.svg" /> + </figure> + <ul class=weather> + {% for entry in weather %} + <li><h2>{{ entry.date }}</h2>Temp: {{ entry.temperature }}, Humidity: {{ entry.humidity }}, Pressure: {{ entry.pressure }} + {% else %} + <li><em>No entries here so far</em> + {% endfor %} + </ul> +{% endblock %} |