====== Requêtes SELECT ======

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

===== query.get() =====

**SELECT** selon un ID :

<code python>
user = User.query.get(5)
</code>

===== query.filter_by() =====

**SELECT** selon le contenu d'un champ :

<code python>
user = User.query.filter_by(name = 'Marc').first()
user = User.query.filter_by(name = 'Marc').one()
</code>

===== query.filter() =====

StackOverflow: [[https://stackoverflow.com/questions/2128505/difference-between-filter-and-filter-by-in-sqlalchemy|filter_by vs filter]]

<code python>
users = User.query.filter(User.name.startswith('Al')).all()
users = User.query.filter(User.name.endswith('bert')).all()
</code>

<code python>
users = User.query.filter(User.age.between(20, 30)).all()
</code>

<code python>
users = User.query.filter(User.country_id == 2).all()
</code>

<code python>
users = User.query.filter(User.age >= 50).all()
</code>

===== query.order_by() =====

<code python>
# du plus petit au plus grand
users = User.query.order_by(User.age).all()

# du plus grand au plus petit
users = User.query.order_by(User.age.desc()).all()

# les 7 plus grands
users = User.query.order_by(User.age.desc()).limit(7).all()
</code>

===== Combiner filter_by et order_by =====

<code python>
users = User.query.filter(User.age.between(20, 30)).order_by(User.age).all()
</code>

===== query.limit() =====

<code python>
user = User.query.limit(1).all()
</code>