from flask import Flask, render_template, jsonify, request
import flask.json
from sqlalchemy import create_engine
+import requests
class JSONEncoder(flask.json.JSONEncoder):
config = configparser.ConfigParser()
config.read(os.environ['SEEPARKINI'])
apikey = config.get('openweathermap', 'apikey')
+cityid = config.get('openweathermap', 'cityid')
def open_engine(config):
return result
+def currentairtemperature(apikey, cityid):
+ baseurl = 'http://api.openweathermap.org/data/2.5/weather'
+ query = baseurl + '?units=metric&APPID={}&id={}&lang=de'.format(apikey, cityid)
+ try:
+ response = requests.get(query)
+ if response.status_code != 200:
+ response = 'N/A'
+ return response, datetime.datetime.now().strftime('%Y-%m-%d %H:%M')
+ else:
+ weatherdata = response.json()
+ return weatherdata['main']['temp'], datetime.datetime.fromtimestamp(weatherdata['dt']).strftime('%Y-%m-%d %H:%M')
+ except requests.exceptions.RequestException as error:
+ print (error)
+
+
+def currentwatertemperature(sensorid):
+ engine = open_engine(config)
+ with engine.connect() as conn:
+ cursor = conn.execute('select value, timestamp from sensors where sensor_id=%s order by timestamp desc limit 1', sensorid)
+ result = [dict(row) for row in cursor]
+ return result[0]['value'], result[0]['timestamp'].strftime('%Y-%m-%d %H:%M')
+
+
@app.route('/api/<version>/sensors/')
def sensors(version):
"""List all sensors found in the database"""
@app.route("/")
def index():
- return render_template('seepark_web.html', apikey=apikey)
-
+ airvalue, airtime = currentairtemperature(apikey, cityid)
+ airvalue = "{:.1f}".format(airvalue) if isinstance(airvalue, float) else airvalue
+ watervalue, watertime = currentwatertemperature('0316a21383ff') # config? mainwatertemp?
+ watervalue = "{:.1f}".format(watervalue) if isinstance(watervalue, float) else watervalue
+
+ return render_template(
+ 'seepark_web.html',
+ apikey=apikey,
+ watervalue=watervalue,
+ watertime=watertime,
+ airvalue=airvalue,
+ airtime=airtime,
+ )