• Doc de SQLAlchemy 1.4 : https://docs.sqlalchemy.org/en/14/contents.html
• Doc de Flask-SQLAlchemy : https://flask-sqlalchemy.palletsprojects.com/en/3.0.x/

• Installation et Configuration
• Connexion
• Définition de modèles et Relations
• Requêtes SELECT

Source: https://flask-sqlalchemy.palletsprojects.com/en/3.0.x/queries/

SELECT selon un ID :

user = User.query.get(5)

SELECT selon le contenu d'un champ :

user = User.query.filter_by(name = 'Marc').first()
user = User.query.filter_by(name = 'Marc').one()

INSERT

user = User(name="Marc", ...)
db.session.add(user)
db.session.commit()

DELETE selon un ID :

user = User.query.get(5)
db.session.delete(user)
db.session.commit()

DELETE plusieurs ligne selon un critère :

users = User.query.filter_by(active = True).all()
for user in users:
    db.session.delete(user)
db.session.commit()