python - 从 ORM 中提取数据并按日期分组

Question

我有一个函数，其数据如下:

my_workouts = Workouts.objects.groupby('my_date').filter(
    my_date__year=year, my_date__month=month)

我想对另一个模型执行相同的操作，我想按日期对权重进行分组:

模型.py

class Quiz(models.Model):
    owner = models.ForeignKey(User, on_delete=models.CASCADE, related_name='quizzes')
    scheduled_date = models.DateTimeField(max_length=255, default=0)
    weight = models.IntegerField(default=0)

我尝试过的:

data = Quiz.objects.orderby('scheduled_date').
       filter(owner_id=request.user.pk,my_date__year=year, my_date__month=month).
       annotate(c=Sum('weight')).values('c')

但这不起作用，请帮忙!

Answer 1

检查你的语法

orderby 必须是 order_by

data = Quiz.objects.order_by('scheduled_date').
       filter(owner_id=request.user.pk,my_date__year=year, my_date__month=month).
       annotate(c=Sum('weight')).values('c')

引用this