dpaste/muLD (Python)

# currently doing
a = CustomUser.objects.annotate(list_rank=Window(expression=RowNumber(), order_by=(
Subquery(UserScore.objects.filter(user_id=OuterRef('id')).values('total_points')).desc(),
F('date_joined')))).values('id', 'list_rank')
for i in a:
UserScore.objects.filter(user_id=i['id']).update(rank=i['list_rank'])

Edit this Snippet

Syntax

Expires

Content # currently doing a = CustomUser.objects.annotate(list_rank=Window(expression=RowNumber(), order_by=( Subquery(UserScore.objects.filter(user_id=OuterRef('id')).values('total_points')).desc(), F('date_joined')))).values('id', 'list_rank') for i in a: UserScore.objects.filter(user_id=i['id']).update(rank=i['list_rank'])