Re: queryset.values() / GROUP BY

2020-07-21 Thread René Fleschenberg
Hi Shai, thanks! I need to look a bit deeper into this I guess. Just for completeness, I am looking at this code in one of my projects: ``` def get_all_colors(self, queryset): color_ids = queryset.order_by('color').values_list('color', flat=True).distinct() found_colors = Color.object

Re: queryset.values() / GROUP BY

2020-07-21 Thread Adam Johnson
I didn't look too deeply at the project, but after checking the readme and Shai's summary: - Sets the seclected fields as attributes on the object returned, > rather than as dict values > - Where the selected field is a FK, follows the relationship to get the > object > ...I think both of th

Re: queryset.values() / GROUP BY

2020-07-21 Thread Javier Buzzi
This looks like a cool little side project. I would keep it there, the use case is very limited. I've always seen the django ORM as a very basic > On Jul 21, 2020, at 12:46 PM, René Fleschenberg wrote: > > Hi, > > on IRC, someone hinted me at https://github.com/kako-nawao/django-group-by > to

Re: queryset.values() / GROUP BY

2020-07-21 Thread Shai Berger
Hi René, On Tue, 21 Jul 2020 18:46:12 +0200 René Fleschenberg wrote: > https://github.com/kako-nawao/django-group-by > It doesn't actually aggregate, so the name "group-by" seems unwarranted. What it does, as the README explains, is replace "values" by something which does two things: - Sets