Django-ORM进阶操作01

• 1.增删改查
• 2.一般操作:

models.UserInfo.objects.filter(id__gt=1)
models.UserInfo.objects.filter(id__lt=1)
models.UserInfo.objects.filter(id__lte=1)
models.UserInfo.objects.filter(id__gte=1)
models.UserInfo.objects.filter(id__in=[1,2,3])
models.UserInfo.objects.filter(id__range=[1,2])
models.UserInfo.objects.filter(name__startswith='au')
models.UserInfo.objects.filter(name__contains='au') # 包含
models.UserInfo.objects.exclude(id=1) # 排除，除去括号内的条件之外的内容。 

---

• 3.排序:

user_object_list = models.UserInfo.objects.all().order_by('id') # asc

user_object_list = models.UserInfo.objects.all().order_by('-id') # desc

user_object_list = models.UserInfo.objects.all().order_by('-id','name') # 如果遇到id相等 按name从小到大排序

---

• 4.分组:

    from django.db.models import Count

    v = models.UserInfo.objects.values('ut_id').annotate(aa = Count('id'))
    print(v.query)
    # SELECT "app01_us