如何在M2M django模型中得到对称自引用的另一面?
假设我们正在制作一个部件目录,我们有大量的Part,我们希望有一个Interchange来显示哪些部件可以用来代替其他部件:
class Part(models.Model):
name = models.CharField(max_length=300)
number = models.CharField(max_length=200, default 'because numberphiles like more ids')
…
interchanges = models.ManyToManyField("self",
through='Interchange',
symmetrical=False,
# + sign per http://charlesleifer.com/blog/self-referencing-many-many-through/
# I have tried without the plus t omaintain the references as well, but can't seem to understand the difference(s)
related_name="interchanges_to+",
# through_fields per docs
through_fields=('reference', 'interchange')
)
# per this http://charlesleifer.com/blog/self-referencing-many-many-through/
def add_interchange(self, part, symm=True):
interchange = models.Interchange.objects.get_or_create(
reference_part=self,
interchange_part=part)
if symm:
# avoid recursion by passing `symm=False`
part.add_interchange(self, False)
return interchange
def remove_interchange(self, part, symm=True):
models.Interchange.objects.filter(
reference_part=self,
interchange_part=part).delete()
if symm:
# avoid recursion by passing `symm=False`
part.remove_interchange(self, False)
def get_interchanges(self):
return ", ".join([str(p) for p in self.interchanges.filter(interchange_part__reference=self)])
def get_references(self):
return …?
# This is where I don't know how to get the Parts that are referring to it as being an interchange
class Interchange(models.Model):
reference = models.ForeignKey(Part, related_name="reference_part")
interchange = models.ForeignKey(Part, related_name="interchange_part")
# just to confirm we have a M2M table, we will add a foregin key to a User if this interchange has been personally verified
confirmed_by = models.ForeignKey(User, null=True, blank=True)
# … others if needed
class Meta:
# because self-referencing, in this case, is silly, we make sure each part references another part
unique_together = ('reference', 'interchange')在Django管理中,我有:
@admin.register(app.Part)
class PartAdmin(admin.ModelAdmin):
list_display = ['name',
'number',
# ▼ I can see the Parts itself Interchanges to
'get_interchanges',
# ▼ I can not see the Parts that reference itself as being an Interchange
'get_references'] 管理中的部件模型以供参考..。
以下是我所拥有的:

以下是我想要得到的:

作为确认,管理中的交换模型:

如何得到对称自引用的M2M django模型的另一面?
如何返回位于交换表中但在引用(第一)列**中的Part**s
备注:
发布于 2018-07-10 00:26:20
如果manytomany有一个带有related_name参数的直通表,并且不包括+,那么您可以直接访问该集合:
def get_references(self):
return ", ".join([str(p) for p in self.interchanges_to.all()])注意,我不确定性能/复杂性。
https://stackoverflow.com/questions/51255253
复制相似问题