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'