summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/mssql/base.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2022-12-08 19:31:37 -0500
committerMike Bayer <mike_mp@zzzcomputing.com>2022-12-15 12:59:35 -0500
commit8e4e325319eaadb81cc1b6e8c8db7cc1a6b920bd (patch)
tree848d4716a1388e22e19314bf29d0acf1efc83038 /lib/sqlalchemy/dialects/mssql/base.py
parente0eea374c2df82f879d69b99ba2230c743bbae27 (diff)
downloadsqlalchemy-8e4e325319eaadb81cc1b6e8c8db7cc1a6b920bd.tar.gz
add eager_defaults="auto" for inserts
Added a new default value for the :paramref:`.Mapper.eager_defaults` parameter "auto", which will automatically fetch table default values during a unit of work flush, if the dialect supports RETURNING for the INSERT being run, as well as :ref:`insertmanyvalues <engine_insertmanyvalues>` available. Eager fetches for server-side UPDATE defaults, which are very uncommon, continue to only take place if :paramref:`.Mapper.eager_defaults` is set to ``True``, as there is no batch-RETURNING form for UPDATE statements. Fixes: #8889 Change-Id: I84b91092a37c4cd216e060513acde3eb0298abe9
Diffstat (limited to 'lib/sqlalchemy/dialects/mssql/base.py')
-rw-r--r--lib/sqlalchemy/dialects/mssql/base.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/sqlalchemy/dialects/mssql/base.py b/lib/sqlalchemy/dialects/mssql/base.py
index a0049c361..aa640727f 100644
--- a/lib/sqlalchemy/dialects/mssql/base.py
+++ b/lib/sqlalchemy/dialects/mssql/base.py
@@ -232,6 +232,7 @@ integer values in Python 3), use :class:`_types.TypeDecorator` as follows::
)
name = Column(String)
+.. _mssql_insert_behavior:
INSERT behavior
^^^^^^^^^^^^^^^^