8.33. SQLAlchemy Query Limit

• First

• Last

• Limit

• Offset

• Slice

8.33.1. First

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.first

>>> results = Valuation.query.filter_by(..).order_by(sqlalchemy.desc(Valuation.date)).first()

8.33.2. Last

• No last method

>>> results = Valuation.query.filter_by(..).order_by(sqlalchemy.desc(Valuation.date)).all()
>>> first_valuation = results[0]
>>> last_valuation = results[-1]

8.33.3. Limit

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.limit

8.33.4. Offset

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.offset

8.33.5. Slice

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.slice