Django:连接两个表

Question

这是我目前拥有的:

class Sessions(models.Model):
    sessionId = models.AutoField(primary_key=True)

class Ip(models.Model):
    ipId = models.AutoField(primary_key=True)

class Affiliation(models.Model):
    affiliationId = models.AutoField(primary_key=True)
    ip = models.ForeignKey("Ip", null=False, db_column="ipId")
    session = models.ForeignKey("Sessions", null=False, db_column="sessionId")

现在我想找到返回 ipId=x 的 Sessions QuerySet。基本上这就是我正在尝试的:

Sessions.objects.filter(affiliation__ip=x)

有什么办法可以在 Django 中做到这一点吗？

Answer 1

找到答案了!

psobjs = Affiliation.objects.filter(ipId=x)
queryset = Sessions.objects.filter(sessionId__in=psobjs.values('sessionId'))