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

User · Accepted Answer

from sqlalchemy import desc someselect order by desc table1 mycol     Usage from  jpmc26

User · Answer

You can use  desc   function in your query just like this  query    model Session query model Entry           join model ClassificationItem           join model EnumerationValue           filter by id c row id           order by model Entry amount desc                This will order by amount in descending order or   query   session query      model Entry   join      model ClassificationItem   join      model EnumerationValue   filter by      id c row id   order by      model Entry amount desc         Use of desc function of SQLAlchemy  from sqlalchemy import desc query   session query      model Entry   join      model ClassificationItem   join      model EnumerationValue   filter by      id c row id   order by      desc model Entry amount        For official docs please use the link or check below snippet     sqlalchemy sql expression desc column  Produce a descending ORDER BY   clause element       e g    from sqlalchemy import desc  stmt   select  users table   order by desc users table c name         will produce SQL as   SELECT id  name FROM user ORDER BY name DESC       The desc   function is a standalone version of the   ColumnElement desc   method available on all SQL expressions  e g    stmt   select  users table   order by users table c name desc          Parameters column     A ColumnElement  e g  scalar SQL expression  with   which to apply the desc   operation       See also      asc        nullsfirst        nullslast        Select order by

User · Answer

Complementary at  Radu answer  As in SQL  you can add the table name in the parameter if you have many table with the same attribute    order by  TableName name desc

User · Answer

You can try   order by ClientTotal id desc     session   Session   auth client name    client3   result by auth client   session query ClientTotal  filter ClientTotal client    auth client name  order by ClientTotal id desc    all    for rbac in result by auth client      print rbac id   session close

User · Answer

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

User · Answer

One other thing you might do is    order by  name desc     This will result in  ORDER BY name desc  The disadvantage here is the explicit column name used in order by

[python] SQLAlchemy ORDER BY DESCENDING?

Examples related to python

Examples related to sqlalchemy