django的model操作汇整详解
作者:bainianminguo 时间:2022-05-16 03:59:46
单表操作
增加数据
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操作
来源:https://www.cnblogs.com/bainianminguo/p/9351936.html
标签:django,model,操作
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
python实现爬虫统计学校BBS男女比例(一)
2023-06-24 17:48:28
![](https://img.aspxhome.com/file/2023/6/76806_0s.jpg)
PHP平滑关闭/重启的实现方法
2023-10-05 08:48:29
Python Pycurl的属性与方法案例详解
2022-09-27 04:57:23
用Python设计一个经典小游戏
2023-07-11 02:57:09
![](https://img.aspxhome.com/file/2023/6/60496_0s.png)
详解Python图像处理库Pillow常用使用方法
2022-07-17 11:04:53
pytorch 实现冻结部分参数训练另一部分
2023-06-14 16:43:10
scrapy-redis的安装部署步骤讲解
2023-03-18 11:53:41
“Unable to read local eventlog (reason:事件日志文件已在读取时间更改)”解决办法
2009-08-27 13:12:00
SQL Server 2005常见问题浅析
2009-03-16 14:06:00
TensorFlow和Numpy矩阵操作中axis理解及axis=-1的解释
2021-02-14 05:59:09
![](https://img.aspxhome.com/file/2023/3/91933_0s.png)
小结下dom节点操作
2011-03-08 10:33:00
ASP ajax分页教程一
2011-04-10 10:51:00
python爬取淘宝商品销量信息
2023-06-01 14:59:03
python使用openai生成图像的超详细教程
2021-08-15 01:25:53
![](https://img.aspxhome.com/file/2023/7/89307_0s.jpg)
python实现会员管理系统
2023-11-13 19:44:46
![](https://img.aspxhome.com/file/2023/2/65872_0s.jpg)
Python入门之列表用法详解
2023-10-04 05:44:50
![](https://img.aspxhome.com/file/2023/0/117470_0s.png)
pytorch载入预训练模型后,实现训练指定层
2022-01-22 12:40:35
PHP实现的AES双向加密解密功能示例【128位】
2023-09-30 14:52:51
ASP实现网页打开任何类型文件都保存的方法
2007-12-21 13:10:00
有感用户体验规划与系统实现
2009-11-27 18:33:00
![](https://img.aspxhome.com/file/UploadPic/200911/27/01-48s.jpg)