django 多表联查

一对多
name = Blog.objects.get(name='a').test.all()
l = []
for n in name :
    l.append(n.headline)
return HttpResponse(l)

 

class Blog(models.Model):
    name = models.CharField(max_length=100)
    tagline = models.TextField()
    class Meta:
        db_table = 'aaaa'  # 给数据表取名，默认表名：应用名_类名

 

 

 

class Entry(models.Model):
    blog = models.ForeignKey(Blog,on_delete=models.CASCADE,related_name = "test")
    authors = models.ManyToManyField(Author)
    headline = models.CharField(max_length=255)
    body_text = models.TextField()
    pub_date = models.DateField()
    mod_date = models.DateField()
    n_comments = models.IntegerField()
    n_pingbacks = models.IntegerField()
    rating = models.IntegerField()

    class Meta:
        db_table = 'cccc'  # 给数据表取名，默认表名：应用名_类名

 

 

 

 

 

 

 

 

 

 

 

 

 

 

select vendor_company.city,parts_sku.vendor_partwarranty,parts_sku.vendor_partmaker,parts_sku.vendor_oe,parts_sku.vendor_autobrand,parts_sku.vendor_partquality,parts_sku.vendor_partname,parts_sku.vendor_description,picture_merchandise.Url  from parts_sku left join vendor_company on (parts_sku.Vendor_ID =vendor_company.id) left join picture_merchandise on (parts_sku.pic_id = picture_merchandise.SkuID) where parts_sku.Vendor_ID='vencom15045100003'