Django 'Query '对象没有属性' contains_column_references '

Question

我是Django的新手，我在如何配置此错误方面遇到了麻烦，这就是为什么我决定发布一些代码问题的原因，我希望你们能帮助我解决这个问题。我错过了代码还是做错了？请忍受我。谢谢。

错误“Query”对象没有属性“contains_column_references”

追踪：

追踪：

内部34.response=get_response（request）中的文件“/home/lib/python3.6/site-packages/django/core/handlers/exception.py”

文件“/home/lib/python 3.6/site-packages/django/core/handlers/base . py”in _ get _ response 115。response = self . process _ exception _ by _ middleware(e，请求)

_get_response 113中的文件“/home/lib/python3.6/site-packages/django/core/handlers/base.py”。响应=wrapped_callback（请求，*callback_args，**callback_kwargs）

updateperiod 2289.V_insert_data.save（）中的文件“/home/unidaweb/unidaproject/Homepage/views.py”

文件“/首页/库/python3.6/站点包/django/db/模型/基地.py”在保存741中。force_update=force_update，update_fields=update_fields）

save_base 779.force_update中的文件“/home/lib/python3.6/site-packages/django/db/models/base.py”，using，update_fields，

文件“/首页/库/python3.6/站点包/django/db/model/base.py”，_save_table 870。结果 = self._do_insert（cls._base_manager、使用、字段、update_pk、原始）

文件"/home/lib/python3.6/site-包/django/db/模型/base.py"在_do_insert908。

manager_method 82中的文件“/home/lib/python 3.6/site-packages/django/db/models/manager . py”。return getattr(self . get _ query set()，name)(*args，**kwargs)

文件“/home/lib/python 3.6/site-packages/django/db/models/query . py”in _ insert 1186。返回query.get_compiler(using=using)。执行sql(返回标识)

execute_sql 1334中的文件“/home/lib/python3.6/site-packages/django/db/models/sql/compiler.py”。对于sql，self.as_sql（）中的参数：

as_sql 1278.self.query.objs中obj的文件“/home/lib/python3.6/site-packages/django/db/models/sql/compiler.py”

文件“/首页/库/python3.6/site-packages/django/db/models/sql/编译器.py” in 1278.for obj in self.query.objs

文件"/home/lib/python3.6/site-pack/django/db/model/sql/compiler.py"在1277.[self.prepare_value（field，self.pre_save_val（field， obj））用于字段中的字段]

prepare_value 1208中的文件“/home/lib/python 3.6/site-packages/django/db/models/SQL/compiler . py”。如果值包含列引用:

异常类型：AttributeError at/updateperiod/Exception Value:“Query”对象没有属性“contains_column_references”

这是我的观点. py

id = request.POST.get('id')

if StudentPeriodSummary.objects.filter(id = id).exists():
    grade = request.POST.get('average')
    update = StudentPeriodSummary.objects.get(id = id)
    update.average = grade
    update.save()
    return render(request, 'Homepage/pending.html')
else:
    myperiod = request.POST.get('period')
    period = gradingPeriod(id=myperiod)
    sectionandgrade = request.POST.get('subjectsection')
    gradesSection = SubjectSectionTeacher.objects.filter(id=sectionandgrade).values('Sections')
    getsection = Section(id=gradesSection)
    gradeslevel = SubjectSectionTeacher.objects.filter(id=sectionandgrade).values('Education_Levels')
    grade = EducationLevel(id=gradeslevel)
    teacher_id = request.POST.get('teacher')

    teacher = EmployeeUser(id=teacher_id)
    averages = []
    for average in request.POST.getlist('average'):
        averages.append(average)
    for m, student in enumerate(request.POST.getlist('studentname')):
        students = StudentSubjectGrade(id=student)
        V_insert_data = StudentPeriodSummary(
            teacher=teacher,
            students_Enrollment_Records=students,
            gradeLevel=grade,
            average=averages[m],
            grading_Period=period,
            sections=getsection,
        )
        V_insert_data.save()
        m += 1

    return render(request, 'Homepage/pending.html')

我的模型.py

class StudentPeriodSummary(models.Model):
    teacher = models.ForeignKey(EmployeeUser, null=True, blank=True)
    students_Enrollment_Records = models.ForeignKey(StudentSubjectGrade, on_delete=models.CASCADE, null=True)
    gradeLevel = models.ForeignKey(EducationLevel,null=True, blank=True)
    sections = models.ForeignKey(Section, null=True)

    grading_Period = models.ForeignKey(gradingPeriod, null=True, blank=True)
    average = models.FloatField(null=True, blank=True)
    def __str__(self):
        suser = '{0.Students_Enrollment_Records}'
        return suser.format(self)

更新

当我试图注释掉views.py中的< code>#GradeLevel=grade，和< code>#Sections=getsection，时(插入数据)。它工作了。似乎是从那一行开始导致了错误，我应该做些什么来修复它？这是正确的吗？

    gradesSection = SubjectSectionTeacher.objects.filter(id=sectionandgrade).values('Sections')
    getsection = Section(id=gradesSection)
    gradeslevel = SubjectSectionTeacher.objects.filter(id=sectionandgrade).values('Education_Levels')
    grade = EducationLevel(id=gradeslevel)

Answer 1

尝试替换:

teacher = EmployeeUser(id=teacher_id)

与

teacher = get_object_or_404(EmployeeUser, id=teacher_id)

同样的事情

getsection = Section(id=gradesSection)

“常用”用户“和”部分“是对象，需要使用 get 或筛选器来获取对象。

另外：

gradesSection = SubjectSectionTeacher.objects.filter(id=sectionandgrade).values('Sections')
getsection = Section(id=gradesSection)

在这里，第一行，您使用values来获取值。这不是单个值。因此，您无法将其传递给id=gradesSection。