Menu
What is the proper way to execute a select statement with an "ORDER BY foo DESC" in SQLAlchemy core? (core, not ORM!)
I'm currently including the direction in the order_by directly:
mytable.select(order_by='name DESC')
...it works (although I don't like it since it's a little bit "hackish"), but SQLAlchemy gives me the following warning:
SAWarning: Can't resolve label reference 'name DESC'; converting to text() (this warning may be suppressed after 10 occurrences)
util.ellipses_string(element.element))
(I didn't find anything about in the doc)
455
all() method. The Query object, when asked to return full entities, will deduplicate entries based on primary key, meaning if the same primary key value would appear in the results more than once, only one object of that primary key would be present.
all() will return all records which match our query as a list of objects.
The statement ends by calling subquery() , which tells SQLAlchemy that our intention for this query is to use it inside a bigger query instead of on its own.
SQLAlchemy Core The already created students table is referred which contains 4 columns, namely, first_name, last_name, course, score. But we will be only selecting a specific column. In the example, we have referred to the first_name and last_name columns. Other columns can also be provided in the entities list.
From the SQLAlchemy docs:
from sqlalchemy import desc
stmt = select([users_table]).order_by(desc(users_table.c.name))
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
