Django—模型—数据查询（返回单个值+查询集限制）

• 返回单个值+查询集限制

  ---

  def process_data(request):
      # 创建一个对象
      # user = User()
      # user.username = '大侠'
      # user.password = '就是不告诉你密码'
      # user.save()
  
      # 修改
      # user = User.objects.get(uid=7)
      #     # print(user)
      #     # user.password = '你猜'
      #     # user.save()
  
      # 删除
      # user = User.objects.get(uid=5)
      # user.delete()
  
      # 查询结果集QuerySet
      #1 all
      # select * from user
      # data = User.objects.all()
  
      # print(data)
      # 获取一条，从结果集中取一条
      # data = data.first()
  
      # filter 过滤结果集
      # data = User.objects.all()
      # # select * from user where uid < 20
      # data = data.filter(uid__lt=20)  # uid < 20
      # data = data.filter(uid__gt=10)
      # print(data)
  
      # 排序
      # 按username升序排列
      # data = User.objects.order_by('username')
      # for user in data:
      #     print(user.username)
  
      # 限制结果集  不能用负的下标
      # 切片 取前两条记录
      # data = User.objects.order_by('username')[:2]
      # 从下标为4记录到下标为9的记录
      # data = User.objects.order_by('uid')[4:10]
      # print(data)
  
      # values 指定字段
      data = User.objects.all().values('username')
      # print(data)
      # for user in data: # user是字典
      #     print(user['username'])
  
      # 去重  distinct
      # data = User.objects.all().values("password").distinct()[:10]
      # data = User.objects.values("password").distinct()[:10]
      # print(data)
  
      # 反序
      # data = User.objects.order_by('uid').reverse()
      # print(data)
  
      return HttpResponse("CURD")