假设我在django中有一个地址(思考街道地址)模型,它被jobs(思考工作站点)和客户(思考邮件地址)引用。
执行查询时,是否可以仅筛选没有对其引用的行?
模型
class Address(models.Model):
street = models.TextField()
suite = models.TextField()
city = models.TextField()
state = models.TextField()
county = models.TextField(default="")
country = models.TextField(default= "USA")
zip = models.TextField()
notes = models.TextField()
class Customer(models.Model ):
firstname = models.TextField(null=False)
lastname = models.TextField(blank=True)
address = models.ForeignKey(Address,null=True,blank=True,default=None)
class Job(models.Model):
number=models.IntegerField(null=False)
name=models.CharField(max_length=100,default="")
address = models.ForeignKey(Address,null=True)
所需功能
#get all addresses that don't have a job or customer referencing it
addresses = Address.objects.filter(job_set_count = 0, customer_set_count=0)
聚苯乙烯
这会是使用“一对一”关系的场景吗?