六、Django学习之基于下划线的跨表查询

result = models.Author.objects.filter(name='admin').values("authorDetail__telephone",'name','age')

result = models.AuthorDetail.objects.filter(author__name='admin').values('telephone')

result = models.Book.objects.filter(title='第一本书').values("publishs__name")

result = models.Publish.objects.filter(book__title='第一本书').values('name')

obj = models.Publish.objects.filter(name='老男人出版社').values("book__title")

obj = models.Book.objects.filter(publishs__name='老男人出版社').values('title')

obj = models.Book.objects.filter(publishs__name='老男人出版社').values('title','authors__name')
obj = models.Publish.objects.filter(name='老男人出版社').values('book__title','book__authors__name')

class Book(models.Model):
    nid = models.AutoField(primary_key=True)
    title = models.CharField( max_length=32)
    publishDate=models.DateField()
    price=models.DecimalField(max_digits=5,decimal_places=2)  #decimal(16,2)
    publishs=models.ForeignKey(to="Publish",related_name='xx')
    authors=models.ManyToManyField(to='Author',)