Django进阶-5-ORM连表查询

publish=models.Publish.objects.filter(name__contains='长沙').first()
books=publish.book_set.all()
  for book in books:
    print(book.title)

authorobj = models.Author.objects.filter(id=1).first()
objects = models.Book.objects.all()
authorobj.book_set.add(*objects)
authorobj.save()

books=models.Publish.objects.filter(name__contains='湖南').values('name','book__title')
authors=models.Book.objects.filter(title__icontains='云团').values('author__name')
print(authors)

 filter()也支持__小写表名语法进行连表查询：

publishs=models.Publish.objects.filter(book__title='数据分析').values('name')
print(publishs)

models.Tb1.objects.filter(name='seven').count()

# 获取id大于1的值
models.Tb1.objects.filter(id__gt=1)
# 获取id大于等于1的值
models.Tb1.objects.filter(id__gte=1)
models.Tb1.objects.filter(id__lt=10)
# 获取id小于10的值
models.Tb1.objects.filter(id__lte=10)
# 获取id大于1 且 小于10的值
models.Tb1.objects.filter(id__lt=10, id__gt=1)

# 获取id等于11、22、33的数据
models.Tb1.objects.filter(id__in=[11, 22, 33])
# not in
models.Tb1.objects.exclude(id__in=[11, 22, 33])

# isnull
Entry.objects.filter(pub_date__isnull=True)

models.Tb1.objects.filter(name__contains="ven")
# icontains大小写不敏感
models.Tb1.objects.filter(name__icontains="ven")
models.Tb1.objects.exclude(name__icontains="ven")

models.Tb1.objects.filter(id__range=[1, 2])