SQLAlchemy ORDER BY DESCENDING?

Question

How can I use ORDER BY descending in a SQLAlchemy query like the following?

This query works, but returns them in ascending order:

query = (model.Session.query(model.Entry)         .join(model.ClassificationItem)         .join(model.EnumerationValue)         .filter_by(id=c.row.id)         .order_by(model.Entry.amount) # This row :)         ) 

If I try:

.order_by(desc(model.Entry.amount)) 

then I get: NameError: global name 'desc' is not defined.

Answer 1

Just as an FYI, you can also specify those things as column attributes. For instance, I might have done:

.order_by(model.Entry.amount.desc()) 

This is handy since it avoids an import, and you can use it on other places such as in a relation definition, etc.

For more information, you can refer this SQLAlchemy 1.4 Documentation