You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
34 lines
976 B
34 lines
976 B
import connexion
|
|
import sqlite3
|
|
|
|
|
|
|
|
app = connexion.FlaskApp(__name__, specification_dir='./')
|
|
app.add_api('cloud.yml')
|
|
|
|
|
|
|
|
@app.route('/')
|
|
def index():
|
|
|
|
conn = sqlite3.connect('light.db')
|
|
|
|
c = conn.cursor()
|
|
c.execute('SELECT id, devicename, light, timestamp FROM light ORDER BY id DESC')
|
|
results = c.fetchall()
|
|
|
|
html = '<html><head><title>Cloud Server</title><meta http-equiv="refresh" content="5" /></head><body><h1>Global Lights</h1><table cellspacing="1" cellpadding="3" border="1"><tr><th>ID</th><th>Device Name</th><th>Light</th><th>Timestamp</th></tr>'
|
|
for result in results:
|
|
|
|
html += '<tr><td>' + str(result[0]) + '</td><td>' + str(result[1]) + '</td><td>' + str(result[2]) + '</td><td>' + str(result[3]) + '</td></tr>'
|
|
|
|
html += '</body></html>'
|
|
|
|
conn.close()
|
|
|
|
return html
|
|
|
|
# If we're running in stand alone mode, run the application
|
|
if __name__ == '__main__':
|
|
# app.run(host='0.0.0.0', port=5000, debug=True)
|
|
app.run(host='0.0.0.0', port=5000)
|
|
|