'''2.1普通查询'''
# 查询要求:文章发布时间在2023-04-12 06:47:00之前
print(Article.objects.filter(art_time__lte="2023-04-12 06:47:00"))
# 查询要求:列表id=2的所有文章(pk查询)
print(Article.objects.filter(art_top_list_id=2)) # _id 字段
print(Article.objects.filter(art_top_list__id=2)) # __id 筛选条件
# 查询要求:判断字段是否设置可以为空值，如果条件成立返回所有查询集，如果条件不成立返回空查询集
print(Article.objects.filter(is_delete__isnull=False))
print(Article.objects.filter(is_delete=False))
# 查询要求:文章名称完全等于"字符串切片操作"
print(Article.objects.filter(art_title__exact="字符串切片操作"))
# 查询要求:文章名称等于"AAAAAAAAA"不区分大小写
print(Article.objects.filter(art_title__exact="AAAAAAAAA"))
print(Article.objects.filter(art_title__exact="aaaaaaaaa"))
# 查询要求:文章名称包含"AAA"
print(Article.objects.filter(art_title__exact="AAAAAAAAA"))
# 查询要求:文章ID在1或2或3中
print(Article.objects.filter(art_top_list_id__in=[1, 3]))
# 查询要求:文章ID在1到3之间
print(Article.objects.filter(id__range=(1, 3)))
# 查询要求:19号发布的文章
from datetime import datetime
print(Article.objects.filter(art_time__year=2023)) # 修改settings.py中USE_TZ = False
print(Article.objects.filter(art_time__day=11))
# print(Article.objects.get(art_time__date=datetime(year=2023, month=4, day=11)))
# print(Article.objects.get(art_time__date='2023-4-11'))
# 查询要求:以'FF'开头的文章
print((Article.objects.filter(art_title__startswith='FF')))
print((Article.objects.get(art_title__startswith='FF')).art_title)
