ORM操作

增加

  1. models.类.objects.create(name=’aa’,age=18)

  2. modes.类.object.create( **dic)

  3. obj=modes.类(name=’张三’,age=15)

obj.save()

4.批量增加

odj_list=[

modes.类.(name=’张三’,age=15),

modes.类.(name=’张三’,age=15),

modes.类.(name=’张三’,age=15)

models.类.objects.bulk_create(obj_list,batch_size=10)

查询

1.queryset = modes.类.object.filter(name=’张三’,age=15)

  1. queryset = modes.类.object.filter(name=’张三’,age=15).first()

  2. queryset = modes.类.object.filter(**dic)

  3. queryset = mode.类.object.filter(age=16)

5.queryset = mode.类.object.filter(age_gt=17)

6.queryset = mode.类.object.filter(age_gt=17,name=’张三’)

7.queyrset = models.类.objects.filter(name__contains=”中国”)

8.queyrset = models.类.objects.exclude(id=9) # id !=9

9.queyrset = models.类.objects.filter(age=19).order_by(“id”)
10.queyrset = models.类.objects.filter(age=19).order_by(“-id”)
11.queyrset = models.类.objects.filter(age=19).order_by(“-id”,”name”)

12.queyrset = models.类.objects.filter(age=19)[0:10]

更新

  1. queryset = models.类.object.filetr(id=2).update(age=19,name=’李四’)

  2. queryset = models.类.object.filetr(id=2).update(**{dic})

  3. obj = models.类.objects.filter(id=2).first()

obj.name = ‘王麻子’

obj.age=14

删除

  1. models.类.objects.filter(id=2).delete()

Original: https://www.cnblogs.com/cl614971/p/16543165.html
Author: 陈木木啊
Title: ORM操作

原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/712162/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球