board.wsgi

#!/usr/bin/python3

from flask import Flask, request, jsonify, render_template
from flask_restful import Resource, Api
import sqlalchemy as db
import json
import uptime
import datetime

engine       = db.create_engine('sqlite:///var/www/html/python/colour.db')
meta_data    = db.MetaData()
connection   = engine.connect()
create_table = db.Table('colour', meta_data,
                 db.Column('id',db.Integer, primary_key=True),
                 db.Column('background',db.String(255))
               )
meta_data.create_all(engine)

query  = connection.execute("SELECT background FROM colour WHERE id = 1")
row    = query.cursor.fetchone()

if row == None:
    push   = db.insert(create_table).values(id=1,background='green')
    result = connection.execute(push)
 
application = Flask(__name__)
api         = Api(application)

class Background(Resource):
    def get(self):
        conn  = engine.connect()
        query = conn.execute("SELECT background FROM colour WHERE id = 1")
        return { 'background': i[0] for i in query.cursor.fetchall()}

    def post(self):
        conn       = engine.connect()
        print(request.json)
        background = request.json['background']
        query      = conn.execute("UPDATE colour SET background = '{0}' WHERE id = 1".format(background))
        return { 'status': 'success'}

class Uptime(Resource):
    def get(self):
        up          = uptime.uptime()
        readable_up = str(datetime.timedelta(seconds=round(up)))
        return jsonify(up = readable_up)

class Boot(Resource):
    def get(self):
        boot = uptime.boottime()
        return jsonify(boot = boot)

api.add_resource(Background, '/background')
api.add_resource(Uptime, '/uptime')
api.add_resource(Boot, '/boot')

@application.route('/')
def index():
    conn  = engine.connect()
    query = conn.execute("SELECT * FROM colour ORDER BY id DESC LIMIT 1")
    bgc   = query.cursor.fetchall()
    for colour in bgc:
        c = colour[1]
        print(c)
    return render_template('index.html', background=c)

if __name__ == "__main__":
    application.run()