From 997f4b5f2b3b4725de0960824e95fcb1150ff215 Mon Sep 17 00:00:00 2001 From: lizraeli Date: Mon, 28 Oct 2019 15:33:41 -0400 Subject: Correctly interpret None passed to query.get(); warn for empty PK values A warning is emitted if a primary key value is passed to :meth:`.Query.get` that consists of None for all primary key column positions. Previously, passing a single None outside of a tuple would raise a ``TypeError`` and passing a composite None (tuple of None values) would silently pass through. The fix now coerces the single None into a tuple where it is handled consistently with the other None conditions. Thanks to Lev Izraelit for the help with this. Fixes #4915 Closes: #4917 Pull-request: https://github.com/sqlalchemy/sqlalchemy/pull/4917 Pull-request-sha: b388343c7cabeecf8c779689b78e638c23f9af40 Change-Id: Ibc6c27ccf50dfd4adbf15b6dbd393115c30d44fb --- lib/sqlalchemy/orm/loading.py | 6 ++++++ lib/sqlalchemy/orm/query.py | 4 +++- 2 files changed, 9 insertions(+), 1 deletion(-) (limited to 'lib/sqlalchemy') diff --git a/lib/sqlalchemy/orm/loading.py b/lib/sqlalchemy/orm/loading.py index 25ba8a398..189da78bc 100644 --- a/lib/sqlalchemy/orm/loading.py +++ b/lib/sqlalchemy/orm/loading.py @@ -243,6 +243,12 @@ def load_on_pk_identity( ) _get_clause = sql_util.adapt_criterion_to_null(_get_clause, nones) + if len(nones) == len(primary_key_identity): + util.warn( + "fully NULL primary key identity cannot load any " + "object. This condition may raise an error in a future " + "release." + ) _get_clause = q._adapt_clause(_get_clause, True, False) q._criterion = _get_clause diff --git a/lib/sqlalchemy/orm/query.py b/lib/sqlalchemy/orm/query.py index d515fa83a..80d544068 100644 --- a/lib/sqlalchemy/orm/query.py +++ b/lib/sqlalchemy/orm/query.py @@ -977,7 +977,9 @@ class Query(Generative): is_dict = isinstance(primary_key_identity, dict) if not is_dict: - primary_key_identity = util.to_list(primary_key_identity) + primary_key_identity = util.to_list( + primary_key_identity, default=(None,) + ) if len(primary_key_identity) != len(mapper.primary_key): raise sa_exc.InvalidRequestError( -- cgit v1.2.1