Ceci est une ancienne révision du document !
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()
StackOverflow: filter_by vs filter
users = User.query.filter(User.name.startswith('Al')).all() users = User.query.filter(User.name.endswith('bert')).all()
users = User.query.filter(User.age.between(20, 30)).all()
users = User.query.filter(User.age >= 50).all()
users = User.query.order_by(User.name).all()
user = User.query.limit(1).all()