Django模型中的m2m“通过”字段引发此错误：“m2m字段”对象没有属性“\u m2m\u reverse\u name\u cache”

Question

嘿，伙计们，我正试图添加一个m2mthrough字段，以便让助手像department.assistants.all()一样调用我的“部门”模型，但在这样做时，我遇到了这个错误AttributeError: 'ManyToManyField' object has no attribute '_m2m_reverse_name_cache'

这是我的模型：

class Department(models.Model):
    id                  = models.BigAutoField(primary_key=True)
    user                = models.OneToOneField(settings.AUTH_USER_MODEL, on_delete=models.CASCADE)
    assistants          = models.ManyToManyField(settings.AUTH_USER_MODEL, through='Assistants', related_name='dep_assistants', 
                            symmetrical=False)

class Assistants(models.Model):
    id                  = models.BigAutoField(primary_key=True)
    department          = models.ForeignKey(Department, related_name='of_department', on_delete=models.CASCADE)
    assistant           = models.ForeignKey(settings.AUTH_USER_MODEL, related_name='dt_assistant', 
                            verbose_name="Department Assistant", on_delete=models.CASCADE)
    added               = models.DateTimeField(auto_now_add=True)

我对这个概念很陌生。有人能告诉我我做错了什么吗

谢谢

Answer 1

如果一个助理只涉及一个部门，这就是一对多的关系。（一个部门有许多助理）在代码中是：

class Assistant(models.Model):
    ...
    department = models.ForeignKey(Department)

不需要关于部门的特别参考资料。要获得所有助理：

assistants = models.Assistant.objects.filter(department=department)

或在类部门上创建属性：

@property
def assistants(self):
    return models.Assistant.objects.filter(department=self)

如果一个助理涉及多个部门（每个部门有多个助理），则是多对多关系，他们之间应该有额外的等级：

class Assignment(models.Model):
    assistant = models.ForeignKey(Assistant)
    department = models.ForeignKey(Department)

class Department(models.Model):
    ...
    assignment= models.ForeignKey(Assignment)

class Assistant(models.Model):
    ...
    assignment = models.ForeignKey(Assignment)

因此，在这里查询该部门的助理：

assistants = models.Assistant.objects.filter(
    assignment__in=models.Assignment.objects.filter(
        department=department
    )
)