今日学习目标
学习内容
- 神奇的双下划线查询
- orm创建外键关系
- 外键字段的增删改查
- 正反向的概念
- 多表查询
一、神奇的双下划线查询
res = models.Book.objects.filter(price__gt=200)
print(res)
res = models.Book.objects.filter(price__lt=200)
print(res)
res = models.Book.objects.filter(price__gte=200.22)
print(res)
res = models.Book.objects.filter(price__lte=200.22)
print(res)
res = models.Book.objects.filter(price__in=[200,300,666.66])
print(res)
res = models.Book.objects.filter(price__range=(200,800))
print(res)
res = models.Book.objects.filter(title__contains='p')
res1 = models.Book.objects.filter(title__icontains='p')
print(res)
print(res1)
res = models.Book.objects.filter(title__startswith='三')
res1 = models.Book.objects.filter(title__endswith='P')
print(res)
print(res1)
res = models.Book.objects.filter(publish_date__year='2019')
print(res)
res = models.Book.objects