Python - Flask and SQLAlchemy database setup for LTI Xblock local development

flask_sqlalchemy_initilize.py

from flask import Flask
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Xblock, CaliperItem
app = Flask(__name__)


engine = create_engine('sqlite:///lti_compliance.db')
Base.metadata.bind = engine

DBSession = sessionmaker(bind=engine)
session = DBSession()


@app.route('/')
@app.route('/construct')
def Structure():
    xblock = session.query(Xblock).first()
    items = session.query(CaliperItem).filter_by(xblock_id=xblock.id)
    output = ''
    for i in items:
        output += i.name
        output += '</br>'
    return output

if __name__ == '__main__':
    app.debug = True
    app.run(host='0.0.0.0', port=8000)