在控制台输入即可,后期开发项目不会使用这种方法
from user.models import *
user1 = User.objects.get(id=1)
print(user1)
user_s = User.objects.all()
print('user_s的类型是:', type(user_s))
from user.models import *
user_s = User.objects.filter(id=1)
print('user_s的类型是:', type(user_s))
print(user_s)
user = user_s[0]
print(user)
from user.models import *
# 查询id不为1的user对象
user_s = User.objects.exclude(id=1)
print(user_s)
from user.models import *
# 没有被逻辑删除的User
user1_s = User.objects.filter(isdelete=0)
print(user1_s)
user2_s = User.objects.filter(isdelete__exact=0)
print(user2_s)
# 查询余额大于等于1000的User对象
user3_s = User.objects.filter(money__gte=1000)
print(user3_s)
# 查询生日为空的User对象
user4_s = User.objects.filter(birthday__isnull=True)
print(user4_s)
from user.models import *
# 查询用户名中包含'1'的用户
user1_s = User.objects.filter(username__contains='1')
print(user1_s)
# 查询用户名已以'name1'开头的用户
user2_s = User.objects.filter(username__startswith='name1')
print(user2_s)
# 查询邮箱以'@qq.com'结尾的用户
user3_s = User.objects.filter(email__endswith='@qq.com')
print(user2_s)
# 查询在第一次创建后,发生修改的对象
user_s = User.objects.filter(updateDatetime__gt=F('createDatetime'))
from user.models import *
from django.db.models import Q
# 查询余额大于5000块的男性
print(User.objects.filter(money__gt=5000, gender=0)) # 第一种 逗号
print(User.objects.filter(Q(money__gt=5000) & Q(gender=0))) # 第二种 Q(【条件】)&Q(【条件】)
# 查询余额大于5000块的男性和余额大于2000的女性
print(User.objects.filter(Q(money__gt=5000, gender=0) | Q(money__gt=2000, gender=1)))