-
-
Notifications
You must be signed in to change notification settings - Fork 1.7k
ORM Bulk UPDATE by Primary Key - WHERE statement not supported #9595
Copy link
Copy link
Closed
Labels
duplicateThis issue or pull request already existsThis issue or pull request already existsexpected behaviorthat's how it's meant to work. consider the "documentation" label in additionthat's how it's meant to work. consider the "documentation" label in additionormuse casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated
Metadata
Metadata
Assignees
Labels
duplicateThis issue or pull request already existsThis issue or pull request already existsexpected behaviorthat's how it's meant to work. consider the "documentation" label in additionthat's how it's meant to work. consider the "documentation" label in additionormuse casenot really a feature or a bug; can be support for new DB features or user use cases not anticipatednot really a feature or a bug; can be support for new DB features or user use cases not anticipated
Describe the use case
As part of updating bulk data in the Sqlalchemy query, I would like to add a condition that updates bulk of students.
I would like to update all the students over the age of 20.
Something like(the example not working):
Databases / Backends / Drivers targeted
Postgres with asyncpg driver
Example Use
Model:
Students:
Query:
Additional context
During running the query we get this message:
WHERE clause with bulk ORM UPDATE not supported right now. Statement may be invoked at the Core level using session.connection().execute(stmt, parameters)