]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
implement render_nulls for new style bulk ORM INSERT
authorMike Bayer <mike_mp@zzzcomputing.com>
Wed, 1 Nov 2023 22:06:49 +0000 (18:06 -0400)
committerMike Bayer <mike_mp@zzzcomputing.com>
Thu, 2 Nov 2023 00:16:11 +0000 (20:16 -0400)
commit392cd0edb4822202fbd7203d52f640a7cbafb63b
tree3deef5c73c507b1df81504ad2e7c2e241dbcb5c9
parent7b711d08b6ecfe3f6da11d3178f7f815d7eb1e4f
implement render_nulls for new style bulk ORM INSERT

Implemented the :paramref:`_orm.Session.bulk_insert_mappings.render_nulls`
parameter for new style bulk ORM inserts, allowing ``render_nulls=True`` as
an execution option.   This allows for bulk ORM inserts with a mixture of
``None`` values in the parameter dictionaries to use a single batch of rows
for a given set of dicationary keys, rather than breaking up into batches
that omit the NULL columns from each INSERT.

Fixes: #10575
Change-Id: I47382bb586626e98d3964dfa8f55acb2c9c6d8d4
doc/build/changelog/unreleased_20/10575.rst [new file with mode: 0644]
doc/build/orm/queryguide/dml.rst
lib/sqlalchemy/orm/_typing.py
lib/sqlalchemy/orm/bulk_persistence.py
lib/sqlalchemy/sql/base.py
test/orm/dml/test_bulk_statements.py
test/typing/test_overloads.py