#31877 closed Bug (fixed)
TemplateView.get_context_data()'s kwargs returns SimpleLazyObjects that causes a crash when filtering.
Reported by: | Tim L. White | Owned by: | Adam Johnson |
---|---|---|---|
Component: | Generic views | Version: | 3.1 |
Severity: | Release blocker | Keywords: | |
Cc: | Adam Johnson, Tom Forbes | Triage Stage: | Accepted |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Example Code that works in 3.0, but not in 3.1:
class OfferView(TemplateView): template_name = "offers/offer.html" def get_context_data(self, **kwargs): offer_slug = kwargs.get("offer_slug", "") offer = get_object_or_404(Account, slug=offer_slug) return {"offer": offer, "offer_slug": offer_slug}
In order to make this work in 3.1, you have to explicitly convert the result of kwargs.get() to a string to get the SimpleLazyObject to resolve:
class OfferView(TemplateView): template_name = "offers/offer.html" def get_context_data(self, **kwargs): offer_slug = kwargs.get("offer_slug", "") offer = get_object_or_404(Account, slug=str(offer_slug)) return {"offer": offer, "offer_slug": offer_slug}
The error generated if you don't is:
Error binding parameter 0 - probably unsupported type
from django/db/backends/sqlite3/operations.py, line 144, in _quote_params_for_last_executed_query
In both cases, the urls.py looks like:
path( "/offers/<slug:offer_slug>/", OfferView.as_view(), name="offer_view", ),
When debugging, I found that offer_slug (coming in from kwargs.get) was of type 'SimpleLazyObject' in Django 3.1, and when I explicitly converted it to a string, get_object_or_404 behaved as expected.
This is using Python 3.7.8 with SQLite.
Change History (19)
comment:1 by , 4 years ago
Summary: | In Django 3.1, get_object_or_404 does not resolve SimpleLazyObjects, and throws Error binding parameter 0 - probably unsupported type from SQLite → In Django 3.1, get_object_or_404 does not resolve SimpleLazyObjects, and throws "Error binding parameter 0 - probably unsupported type" from SQLite |
---|
comment:2 by , 4 years ago
Cc: | added |
---|---|
Component: | Database layer (models, ORM) → Generic views |
Keywords: | SQLite removed |
Severity: | Normal → Release blocker |
Summary: | In Django 3.1, get_object_or_404 does not resolve SimpleLazyObjects, and throws "Error binding parameter 0 - probably unsupported type" from SQLite → TemplateView.get_context_data()'s kwargs returns SimpleLazyObjects that causes a crash when filtering. |
Triage Stage: | Unreviewed → Accepted |
comment:3 by , 4 years ago
Owner: | changed from | to
---|---|
Status: | new → assigned |
comment:6 by , 4 years ago
Triage Stage: | Accepted → Ready for checkin |
---|
comment:9 by , 4 years ago
Resolution: | fixed |
---|---|
Status: | closed → new |
Passing deprecated keyword arguments to a queryset with lookups, e.g. Artist.objects.get(name__iexact=artist_name)
, still crashes on PostgreSQL:
django.db.utils.ProgrammingError: can't adapt type '__proxy__'
Thanks Mohit Solanki for the report.
comment:10 by , 4 years ago
😟 Hmm this is a tough one.
psycopg2 uses type(obj)
to look for its "adapter" - in its C extension: https://github.com/psycopg/psycopg2/blob/e14e3385b4809ec4223894f8c7a009b1560eb41d/psycopg/microprotocols.c#L151 . So this "proxy" approach may not be feasible.
I know of a more accurate proxy wrapper that proxies more attributes than Django's lazy objects - wrapt.ObjectProxy - https://wrapt.readthedocs.io/en/latest/wrappers.html#object-proxy. But docs there acknowledge that it can't even make type()
work, whilst it makes isinstance()
work.
Any ideas of alternative approaches?
comment:11 by , 4 years ago
Has patch: | unset |
---|---|
Triage Stage: | Ready for checkin → Accepted |
comment:12 by , 4 years ago
There isn't really a general purpose way of wrapping primitive/arbitrary types like this in Python that won't hit some corner cases. You can make an object appear to be a duck by adapting it's quacking dynamically (i.e wrapt.ObjectProxy
), but if someone looks close enough they can always see that it's actually dog. And on the whole that's a good thing, IMO.
Our use of kwargs
makes this harder as we lose the ability to construct a container that can trigger the deprecation warning which would be the typical easy approach. There is no way to control what lands on the other side of get_context_data()
(it's always a plain kwargs dict), and there is no way to construct a wrapper value that looks _exactly_ like the value it's wrapping.
That basically leaves only "crazy" approaches, some of which are fun to consider but none of which are suitable. Here's one that uses settrace()
to do what we need:
import sys class DeprecatedWrapper(dict): def __getitem__(self, key): warnings.warn("stop right there, scoundrel!") return super().__getitem__(key) def wrap_kwargs(frame, *args): frame['kwargs'] = DeprecatedWrapper(frame['kwargs']) sys.settrace(None) class TemplateView(...): def get(...): ... sys.settrace(wrap_kwargs) context = self.get_context_data(**context_kwargs) return self.render_to_response(context)
Given these issues, I'm not sure if we can go ahead with deprecating this.
comment:13 by , 4 years ago
Cc: | added |
---|
comment:14 by , 4 years ago
Has patch: | set |
---|
Agreed, we should revert it since we don't have a clear deprecation path.
Thanks for the report.
get_object_or_404()
andQuerySet.filter()
withSimpleLazyObject
throw the same exception in Django 2.2 or 3.0.TemplateView.get_context_data()
'skwargs
returnsSimpleLazyObjects
in Django 3.1 which causes a crash. Passing URL kwargs into context is deprecated (see #19878) but should still work in Django 3.1 and 3.2.Regression in 4ed534758cb6a11df9f49baddecca5a6cdda9311.
Reproduced at 60626162f76f26d32a38d18151700cb041201fb3.