From 614562bf2cf048b049af5304fead92a46f080d3e Mon Sep 17 00:00:00 2001
From: Matt Kohls <mattkohls13@gmail.com>
Date: Mon, 11 Apr 2016 23:53:38 -0400
Subject: Initial Commit. Basic webapp that can save/display weather data

---
 schema.sql                  |  8 ++++++
 sensor.py                   | 64 +++++++++++++++++++++++++++++++++++++++++++++
 static/style.css            | 18 +++++++++++++
 templates/layout.html       | 17 ++++++++++++
 templates/show_entries.html | 23 ++++++++++++++++
 5 files changed, 130 insertions(+)
 create mode 100644 schema.sql
 create mode 100644 sensor.py
 create mode 100644 static/style.css
 create mode 100644 templates/layout.html
 create mode 100644 templates/show_entries.html

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..a0123d0
--- /dev/null
+++ b/sensor.py
@@ -0,0 +1,64 @@
+# 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
+
+# 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)
+
+# adding entries to database
+@app.route('/data', methods=['POST'])
+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 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..0f32195
--- /dev/null
+++ b/templates/layout.html
@@ -0,0 +1,17 @@
+<!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>
+  {% if not session.logged_in %}
+    <a href="{{ url_for('login') }}">log in</a>
+  {% else %}
+    <a href="{{ url_for('logout') }}">log out</a>
+  {% endif %}
+  </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..5d9ff1a
--- /dev/null
+++ b/templates/show_entries.html
@@ -0,0 +1,23 @@
+{% extends "layout.html" %}
+{% block body %}
+  {% if session.logged_in %}
+    <form action="{{ url_for('add_entry') }}" method=post class=add-entry>
+      <dl>
+        <dt>Temperature:
+        <dd><input type=number size=30 name=temperature>
+	<dt>Humidity:
+        <dd><input type=number size=30 name=humidity>
+	<dt>Pressure:
+        <dd><input type=number size=30 name=pressure>
+	<dd><input type=submit value=Submit>
+      </dl>
+    </form>
+  {% endif %}
+  <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 %}
-- 
cgit v1.2.3