flask_sqlalchemy_sqlite_user_model_quickstart.py

1from flask import Flask
2from flask_sqlalchemy import SQLAlchemy
3from sqlalchemy.orm import DeclarativeBase, Mapped, mapped_column
4
5class Base(DeclarativeBase):
6  pass
7
8db = SQLAlchemy(model_class=Base)
9
10# create the app
11app = Flask(__name__)
12# configure the SQLite database, relative to the app instance folder
13app.config["SQLALCHEMY_DATABASE_URI"] = "sqlite:///project.db"
14# initialize the app with the extension
15db.init_app(app)
16
17class User(db.Model):
18    id: Mapped[int] = mapped_column(primary_key=True)
19    username: Mapped[str] = mapped_column(unique=True)
20    email: Mapped[str]
21
22with app.app_context():
23    db.create_all()