django - List all users of every group self is in, excluding self -
i trying print out list of groups user belongs to. nested in each grouping list of other users in group.
user = self.request.user groups = group.objects.filter(user=user) people = user.objects.filter(groups__in=groups).exclude(pk=user.pk)
but gives me list of users, them grouped group, efficiently possible.
i do:
groups = group.objects.filter(user=user) grouping in groups: people = group.user_set.exclude(pk=user.pk)
but sense making many queries, (one each group?)
so, seems might way it:
groups = self.user.groups.prefetch_related('user_set') grouping in groups: print(group) print(group.user_set.exclude(pk=user.pk)
i want create sure exclude statement isn't doing query, , if can add together prefetch.
hmm, after looking in db.connection.queries
see queries exclude. possible prefetch somehow?
django
No comments:
Post a Comment