From bd7839a643c44ae5d550c3f738e43712356e40e9 Mon Sep 17 00:00:00 2001 From: Pablo Nicolas Estevez Date: Sat, 7 Dec 2024 16:02:12 -0300 Subject: [PATCH] add changeog and PR corrections --- doc/build/changelog/unreleased_21/11764.rst | 9 +++++++++ lib/sqlalchemy/dialects/mysql/base.py | 4 ++-- lib/sqlalchemy/orm/query.py | 2 -- 3 files changed, 11 insertions(+), 4 deletions(-) create mode 100644 doc/build/changelog/unreleased_21/11764.rst diff --git a/doc/build/changelog/unreleased_21/11764.rst b/doc/build/changelog/unreleased_21/11764.rst new file mode 100644 index 0000000000..63b4b5229e --- /dev/null +++ b/doc/build/changelog/unreleased_21/11764.rst @@ -0,0 +1,9 @@ +.. change:: + :tags: usecase, mysql, mariadb + :tickets: 11764 + + Added support for the `LIMIT` clause in the `DELETE` method for MySQL + and MariaDB backends. + The `delete()` construct now accepts the `mysql_limit` and + `mariadb_limit` parameters, allowing users to specify a limit on the + number of rows deleted. \ No newline at end of file diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py index 5bd9300b7a..2ec38c9362 100644 --- a/lib/sqlalchemy/dialects/mysql/base.py +++ b/lib/sqlalchemy/dialects/mysql/base.py @@ -473,12 +473,12 @@ available. update(..., mysql_limit=10, mariadb_limit=10) -.. versionadded:: 2.1 Added delete with limit - * DELETE with LIMIT:: delete(..., mysql_limit=10, mariadb_limit=10) +.. versionadded:: 2.1 Added delete with limit + * optimizer hints, use :meth:`_expression.Select.prefix_with` and :meth:`_query.Query.prefix_with`:: diff --git a/lib/sqlalchemy/orm/query.py b/lib/sqlalchemy/orm/query.py index 9d23decda6..41b0ff3baf 100644 --- a/lib/sqlalchemy/orm/query.py +++ b/lib/sqlalchemy/orm/query.py @@ -3177,8 +3177,6 @@ class Query( """ - delete_args = delete_args or {} - bulk_del = BulkDelete(self, delete_args) if self.dispatch.before_compile_delete: for fn in self.dispatch.before_compile_delete: -- 2.47.3