gistfile1.py

from takeoffgo import app
from takeoffgo.model import Session


@app.before_request
def before_request():
    g.db = Session()


@app.teardown_request
def teardown_request(exception):
    g.db.close()

gistfile2.py

from flask import render_template, g, abort
from takeoffgo.model import User
from takeoffgo.web.public import public


@public.route('/profile/<user_key>')
def profile(user_key):
    user = g.db.query(User).filter(User.key == user_key).first()

    if user is None:
        abort(404)
        
    return render_template('public/profile.html', user=user)