What will be the replacement for .extra()?

[Luis Masuelli]

When I see the docs (https://docs.djangoproject.com/en/1.8/ref/models/querysets/#extra), I notice .extra will be deprecated and removed. Is there a plan for the replacement? As I see it, limiting ourselves to using Manager.raw() is not a good idea, since you cannot work anymore on a RawQueryset object (as you can work on any Queryset object you called .extra). So my question is: Is there a good replacement for .extra being planned?

[Russell Keith-Magee]

Hi Luis,

On Thu, Dec 10, 2015 at 7:10 AM, Luis Masuelli <luisfm...@gmail.com> wrote:

When I see the docs (https://docs.djangoproject.com/en/1.8/ref/models/querysets/#extra), I notice .extra will be deprecated and removed. Is there a plan for the replacement? As I see it, limiting ourselves to using Manager.raw() is not a good idea, since you cannot work anymore on a RawQueryset object (as you can work on any Queryset object you called .extra). So my question is: Is there a good replacement for .extra being planned?

Yes - the Query Expression API.

https://docs.djangoproject.com/en/1.9/ref/models/expressions/

Yours,

Russ Magee %-)

[thinkwell]

So how would an query like this be written, with the new Query Expression API? Where a count of events by day is required but the date column is datetime?

Triggers.objects.all().extra({"day": "date_trunc('day', date)"}).values_list('name', 'severity', 'day').annotate(total=Count('severity'))

[Dan Stephenson]

Following is worth a watch

https://opbeat.com/events/duth/#expressions