1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
from __future__ import annotations
from flask import Flask
from flask import render_template
from flask_sqlalchemy import SQLAlchemy
from flask_debugtoolbar import DebugToolbarExtension
app = Flask("basic_app")
app.config["DEBUG"] = True
app.config["SECRET_KEY"] = "abc123"
app.config["SQLALCHEMY_RECORD_QUERIES"] = True
app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///:memory:"
# This is no longer needed for Flask-SQLAlchemy 3.0+,
# if you're using 2.X you'll want to define this:
# app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
# make sure these are printable in the config panel
app.config["BYTES_VALUE"] = b"\x00"
app.config["UNICODE_VALUE"] = "\uffff"
toolbar = DebugToolbarExtension(app)
db = SQLAlchemy(app)
class Foo(db.Model): # type: ignore[name-defined, misc]
__tablename__ = "foo"
id = db.Column(db.Integer, primary_key=True)
@app.route("/")
def index() -> str:
Foo.query.filter_by(id=1).all()
return render_template("basic_app.html")
with app.app_context():
db.create_all()
|
