对Django项目中的ORM映射与模糊查询的使用详解

UserInfo.objects.get(id=2)

select * from user_userinfo where id=2

obj1 = UserInfo.objects.filter(user_name__contains='王')#以‘王'开头的user__name
obj2 = UserInfo.objects.filter(user_name__endswith='王')#以‘王'结尾的user__name
obj3 = UserInfo.objects.filter(id__gte=5)#ID大于等于5的
obj5 = UserInfo.objects.filter(id__exact=5)#id等于5的
obj6 = UserInfo.objects.filter(id__in=[1,3,5])#id等于1，3，5，的

obj8 = UserInfo.objects.filter(password='123456',id__gt=2).exclude(phone=188)
#找到符合filter的内容后排除phone等于188的，它的另一种写法为
from django.db.models import Q
obj = UserInfo.objects.filter(Q(password='123456') & Q(id__gt=2) & ~Q(phone=188))

from django.db.models import Sum,Max,Min
obj = UserInfo.objects.aggregate(Sum('id'))
obj = UserInfo.objects.aggregate(Max('id'))
obj = UserInfo.objects.aggregate(Min('id'))

print(UserInfo.objects.count())#注：print只可于终端查看

obj = UserInfo.objects.all()[1:3]#左闭右开，只查找了1和2

obj = person.useraddress_set.all()

obj4 = UserInfo.objects.get(id=5)
city = UserAddress.objects.get(detail='北京望京')