from django.db.models import Exists, OuterRef
 
# 1. 定義子查詢條件
relative_comments = Comment.objects.filter(
 post=OuterRef('pk'), # 注意外鍵關聯方式:post為Comment表的字段，pk表示關聯另一表主鍵
)
 
# 2. 使用annotate和filter共同定義子查詢
Post.objects.annotate( # 使用exists定義一個額外字段
 recent_comment=Exists(recent_comments),
).filter(recent_comment=True) # 在條件中通過檢查額外字段實現exists子查詢過濾

class Host(models.Model):
nid = models.AutoField(primary_key=True)
hostname = models.CharField(max_length=32, db_index=True)
ip = models.GenericIPAddressField(protocol=“ipv4”, db_index=True)
port = models.IntegerField()
# b = models.ForeignKey(to=“Business”, to_field=‘id')

class HostToApp(models.Model):
hobj = models.ForeignKey(to=‘Host', to_field=‘nid')
aobj = models.ForeignKey(to=‘Application', to_field=‘id')

class Application(models.Model):
name = models.CharField(max_length=32)

class HostToApp(models.Model):
hobj = models.ForeignKey(to=‘Host', to_field=‘nid')
aobj = models.ForeignKey(to=‘xxxx.Application', to_field=‘id')