organization.py 文件源码

def get_queryset(self):
        return (
            Band.objects
            .annotate(
                user_joined=RawSQL(
                    'SELECT 1 FROM api_member '
                    'WHERE api_member.band_id = api_band.id AND api_member.user_id = %s '
                    'LIMIT 1',
                    (self.request.user.id,)
                )
            )
            .annotate(compositions_count=Count('compositions', distinct=True))
            .annotate(members_count=Count('members', distinct=True))
            .select_related('leader__member__user')
        )