开发者

django - get all objects in one table which do not have a foreignkey in another table

I have 2 models:

class Friend(models.Model):
    person1 = models.ForeignKey("Person", related_name="friend1")
    person2 = models.ForeignKey("Person", related_name="friend2")
    created = models.DateTimeField(auto_now=True, auto_now_add=True, editable=False)

class Person(models.Model):
    firstname = models.CharField(max_length=100)
    surname = models.CharField(max_length=100)
    created = models.DateTimeField(auto_now=True, auto_now_add=True, editable=False)

I want a list of Person objects which do not have any entries in the Friend object. e.g.

no_friends = Person.objects.filter(????)
开发者_运维百科

but I'm not sure what the filter should be.


Try to use the related manager.

no_friends = Person.objects.filter(friend1=None,friend2=None)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜