Order by descending records SQLAlchemy

python Share on :

If you are using SQLAlchemy and want to order your records in descending order by some column values then you can use the order_by() method.

#Direct apply on model property
.order_by(UserModel.id.desc())

#by importing desc() method
from sqlalchemy import desc
session.query(UserModel).order_by(desc(UserModel.id)).all()

There are two ways to order your records in descending order. First by using .desc directly apply to your column name.

self.session.query(
    UserModel
).filter(
    UserModel.role = 'simple'
).order_by(
    UserModel.id.desc()
).all()

If you want to wrap your Model Property inside the desc() method then you will have to import it first.

from sqlalchemy import desc 

self.session.query(
    UserModel
).filter(
    UserModel.role = 'simple'
).order_by(
    desc(UserModel.id)
).all()

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

0 Comments

Similar code snippets

Get all records Sqlalchemy
Delete records query in SQLAlchemy
SQLAlchemy query to get distinct records from table
Pandas - Change rows order of a DataFrame using index list
Sqlalchemy basic db migration commands Python
Basic types and relationship in SQLAlchemy
Filter query Sqlalchemy