django.core.exceptions.FieldError：无法将关键字'students'解析为字段。选择包括：考试、身份证、学生、student_id、科目、测试

Question

我正在建立一个在线课程，学生可以在登录帐户时查看他们的结果，我不知道如何从数据库中查询结果，以便能够生成老师为每个学生发布的结果。请问我怎么写 views.py？

我做了一些事情，但有一个错误。这是我的代码：

class Result(models.Model):
student = models.ForeignKey(Students, on_delete=models.CASCADE)
test = models.FloatField(null=True, blank=True)
exam = models.FloatField(null=True, blank= True)
subject = models.CharField(max_length=3, choices=SUBJECT, null=True)
class Meta:
ordering = ["-student"]
def get_total(self):
return self.exam + self.test
def __str__(self):
return self.student.first_name

class Students(models.Model):
first_name = models.CharField(max_length=15, default='top')
last_name = models.CharField(max_length=15, default='top')
phone_number = models.IntegerField(default=0)
email = models.EmailField()
class_choice = models.CharField(max_length=3, choices=CLASS)
last_accessed = models.DateTimeField(null=True, blank=True)
user = models.ForeignKey(User, on_delete=models.CASCADE, null=True, blank=True)
class Meta:
ordering = ["last_name"]
def __str__(self):
return self.last_name
def get_absolute_url(self):
return reverse('students-detail', kwargs={'pk': self.pk})

Answer 1

通常，我们这样做

class Result(models.Model):
student = models.ForeignKey(Students, related_name='results')
class Student(models.Model):
name = models.CharField(max_length=15, default='top')

s1 = Student.objects.get(id=1)
res = s1.results.all()