Django基础（三）

23、ORM映射
UserInfo.objects.get(id=2)

select * from user_userinfo where id=2

24、修改管理器
from django.db import models

25、模糊查询 filter exclude

obj = UserInfo.objects.filter(user_name__contains='王')
obj1 = UserInfo.objects.filter(user_name__endtains='王')
obj2 = UserInfo.objects.filter(user_name__starttains='王')
obj3 = UserInfo.objects.filter(id__gte=5)
obj4 = UserInfo.objects.filter(id=5)
obj5 = UserInfo.objects.get(id=5)
obj6 = UserInfo.objects.filter(id__in=[1,2,3])
obj7 = UserInfo.objects.filter.xeclude(id=3)
obj7 = UserInfo.objects.filter(password='123456',id__gt=3)
obj8 = UserInfo.objects.filter(password='123456',id__gt=3).exclude(phone = 188)
Q属性：逻辑之间的比较
obj = UserInfo.objects.filter(Q(password='123456')&Q(id__gt=3) &~ Q(phone=188))
F属性：两个字段之间的比较
obj = UserInfo.objects.all()[1:3]左闭右开，表示的是类似切片