django的model操作汇整详解

框架(架构)  /  管理员 发布于 7年前   182

单表操作

增加数据

auther_obj = {"auther_name":"崔皓然","auther_age":1}models.auther.objects.create( **auther_obj)

models.auther.objects.create( auther_name="周雍博", auther_age=4)

obj = models.auther( auther_name="崔洪艳", auther_age=29)obj.save()

obj = models.auther( auther_name = "王仙枝", auther_age = "50")obj.save()

删除数据

models.auther.objects.filter(auther_name="崔洪艳")[0].delete()

一对多操作

增加数据

a_obj = models.auther.objects.get(id=1)  models.book.objects.create( book_name = "python课程1", book_price = 12, book_auther = a_obj)

a_obj = models.auther.objects.get(id=5) models.book.objects.create( book_name = "java课程1", book_price = 13, book_auther_id = a_obj.id)

a_obj = models.auther.objects.get(id=2) book_dict = { "book_name":"python课程2", "book_price":14, "book_auther_id":a_obj.id} obj = models.book.objects.create( **book_dict)

a_obj = models.auther.objects.get(id=4) book_dict = { "book_name":"java课程2", "book_price":15, "book_auther":a_obj} models.book.objects.create( **book_dict)

一对多正向查询

# 查询id为2的书的所有作者的信息obj = models.book.objects.get(id=2) print(obj.book_auther.auther_name)print(obj.book_auther.auther_age) obj = models.book.objects.filter(id=2).values("book_name","book_price","book_auther__id","book_auther__auther_name","book_auther__auther_age") print(obj)

# 查询id为2的作者的出版的书 obj = models.book.objects.filter(book_auther_id=2).values("book_name","book_price","book_auther__id","book_auther__auther_name","book_auther__auther_age")print(obj)  obj = models.book.objects.get(book_auther_id=2)print(obj.book_auther.auther_age)print(obj.book_auther.auther_name)print(obj.book_name)

一对多反向查询

# 查看出版社出版的书 obj = models.auther.objects.filter(id=2).values("auther_name","auther_age","book__book_name")print(obj) obj = models.auther.objects.get(id=2).book_set.values("book_name","book_price","book_auther__id","book_auther__auther_name","book_auther__auther_age")print(obj)

多对多操作

增加数据

b1 = models.book.objects.get(id=1)b2 = models.book.objects.get(id=2)b4 = models.book.objects.get(id=4)b5 = models.book.objects.get(id=5)models.publish.objects.get(id=1).publish_book.add( b1,b2)

book_list = [b1,b2] models.publish.objects.get(id=2).publish_book.add( *book_list)

更新数据

book_list = [b1,b2,b4,b5]models.publish.objects.get(id=1).publish_book.set(book_list)

移除数据

models.publish.objects.get(id=1).publish_book.remove(b1) book_list = [b2, ] models.publish.objects.get(id=1).publish_book.remove(*book_list)　　

正向查询

obj = models.publish.objects.get(id=1).publish_book.values("book_name","publish__publish_name")print(obj) obj = models.publish.objects.filter(id=1).values("publish_name","publish_book__book_name")print(obj)

反向添加数据

p1 = models.publish.objects.get(id=1)p2 = models.publish.objects.get(id=2)p3 = models.publish.objects.get(id=3)b1.publish_set.add(p1,p2,p3)

反向删除数据

b1.publish_set.remove(p1)

反向更新数据，把remove替换为set就可以了

反向查询

obj = models.book.objects.get(id=1).publish_set.values("publish_name","publish_book__book_name")

model中多表关系和参数 

多对多

一对一

model操作

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。