As i am trying to make the "transition" from Flask-SQLAlchemy to your fork i found thi

Flask debug toolbar doesnt show queries(shows unavailable) about sqla-wrapper HOT 2 CLOSED

jpsca commented on June 5, 2024

Flask debug toolbar doesnt show queries(shows unavailable)

from sqla-wrapper.

Comments (2)

commented on June 5, 2024 1

I'm sorry, this should be on the documentation.

In order to see the queries on the Flask debug toolbar, you must activate first the query recording using the argument record_queries:

db = SQLAlchemy(SQLALCHEMY_URI, app=app, record_queries=True)

(In Flask-SQLAlchemy this is done automatically if DEBUG is True... I'll probably do something similar soon)
Here is a functional (but boring) example:

"""
    pip install flask, sqlalchemy_wrapper, flask_debugtoolbar
"""
from flask import Flask
from sqlalchemy_wrapper import SQLAlchemy

app = Flask(__name__)
app.config['DEBUG'] = True
app.config['SECRET_KEY'] = 'loremipsumsitamet'
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///test.db'
app.config['DEBUG_TB_INTERCEPT_REDIRECTS'] = False

db = SQLAlchemy(
    app.config['SQLALCHEMY_DATABASE_URI'],
    record_queries=app.config['DEBUG'],
    app=app
)


class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.Unicode)


@app.route("/")
def hello():
    db.query(User).all()
    return "<html><body>Hello World!</body></html>"

db.create_all()
db.add(User(name=u'Test'))
db.commit()

if __name__ == "__main__":

    if app.config['DEBUG']:
        import flask_debugtoolbar
        flask_debugtoolbar.DebugToolbarExtension(app)
    app.run()