import os
# 如果忘记main是怎么写的,可以复制manage.py文件的开头,然后再导入django
if __name__ == '__main__':
os.environ.setdefault("DJANGO_SETTINGS_MODULE", "orm_about.settings")
import django
django.setup()
from app01 import models
ret1 = models.Person.objects.filter(id__gt=1) # id大于1的对象集合
ret2 = models.Person.objects.filter(id__lt=3) # id小于3的对象集合
ret3 = models.Person.objects.filter(id__gte=3) # id大于等于3的对象集合
ret4 = models.Person.objects.filter(id__lte=3) # id小于等于3的对象集合
ret5 = models.Person.objects.filter(id__in=[1, 3]) # id 是列表中的元素
ret6 = models.Person.objects.filter(id__gte=1, id__lte=3) # id大于等于1小于等于3
ret7 = models.Person.objects.filter(id__range=[1, 4]) # id大于等于1小于等于4
ret8 = models.Person.objects.filter(name__contains='s') # 模糊查询,包含的意思,不忽略大小写
ret9 = models.Person.objects.filter(name__icontains='s') # 模糊查询且忽略大小写
ret10 = models.Person.objects.filter(name__startswith='j') # 以j开头的对象集合
ret11 = models.Person.objects.filter(name__endswith='m') # 以m结尾的对象集合