djang常用查询SQL语句的使用代码
作者:TAMAYURA 时间:2022-04-27 02:59:51
将django语法和sql对应一下,希望对大家有所帮助
查询单个列的值
story.object.values_list("url", flat=True)
SELECT `story`.`url` FROM `hbtc_story` WHERE `story`.`status` = resolved
AND查询
Stories.objects.filter(Q(status='resolved') & Q(status='developing'))
SELECT * FROM `story` WHERE (`story`.`status` = resolved AND `story`.`status` = developing)
或查询
Stories.objects.filter(Q(status='resolved') | Q(status='developing'))
SELECT * FROM `story` WHERE (`story`.`status` = resolved OR `story`.`status` = developing)
NOT查询
Stories.objects.filter(~Q(status='resolved'))
SELECT * FROM `story` WHERE NOT (`story`.`status` = resolved)
查询为空
Stories.objects.filter(status__isnull=True)
SELECT * FROM `story` WHERE `story`.`plan_id_id` IS NULL
like查询
Stories.objects.filter(status__contains='resolved')
SELECT * FROM `story` WHERE `story`.`status` LIKE BINARY %resolved%;
Stories.objects.filter(status__endswith='resolved')
SELECT * FROM `story` WHERE `story`.`status` LIKE BINARY %resolved;
Stories.objects.filter(status__istartswith='resolved')
SELECT * FROM `story` WHERE `story`.`status` LIKE BINARY resolved%;
in查询
Stories.objects.filter(status__in=('resolved',))
SELECT * FROM `story` WHERE `story`.`status` IN (resolved) ;
distinct查询
story.object.values_list("status", flat=True).distinct()
SELECT DISTINCT `story`.`status` FROM `story`
具体示例代码
Django查询SQL语句
# 1 res=models.Book.objects.all()
# print(res)#<QuerySet [<Book: Book object>, <Book: Book object>, <Book: Book object>, <Book: Book object>, <Book: Book object>, <Book: Book object>]>
#2 res=models.Book.objects.filter(price='555')
# print(res)#<QuerySet [<Book: 海贼王>, <Book: 哆啦A梦>]>
#3 res=models.Book.objects.get(nid=2)
# print(res.price)#三月的狮子
# res=models.Book.objects.get(nid=10)
# print(res)#只能用于一个对象的里面
#4 res=models.Book.objects.exclude(price='555')
# print(res)#<QuerySet [<Book: 百变小樱>, <Book: 三月的狮子>, <Book: 水星领航员>, <Book: 火影忍者>]>
#5 res=models.Book.objects.values('title','publishDate')
# print(res)#<QuerySet [{'title': '百变小樱', 'publishDate': datetime.date(2000, 8, 8)}, {'title': '三月的狮子', 'publishDate': datetime.date(2017, 10, 19)}, {'title': '水星领航员', 'publishDate': datetime.date(2004, 2, 23)}, {'title': '火影忍者', 'publishDate': datetime.date(1996, 1, 2)}, {'title': '海贼王', 'publishDate': datetime.date(1995, 2, 2)}, {'title': '哆啦A梦', 'publishDate': datetime.date(1969, 12, 31)}]>
#6 res=models.Book.objects.values_list('title','price')
# print(res)#<QuerySet [('百变小樱', Decimal('155.00')), ('三月的狮子', Decimal('114.00')), ('水星领航员', Decimal('999.99')), ('火影忍者', Decimal('99.20')), ('海贼王', Decimal('555.00')), ('哆啦A梦', Decimal('555.00'))]>
#7 res=models.Book.objects.filter(price='555').distinct()
# print(res)
#8 res=models.Book.objects.count()
# print(res) 6
#9 res=models.Book.objects.first()
# print(res)#百变小樱
#10 res=models.Book.objects.exists()
# print(res)#True
####################################################
#1 res=models.Book.objects.filter(price__gt=200 )
# print(res)#<QuerySet [<Book: 水星领航员>, <Book: 海贼王>, <Book: 哆啦A梦>]>
#
#2 res=models.Book.objects.filter(price__lte=555,price__gte=114)
# print(res)#<QuerySet [<Book: 百变小樱>, <Book: 三月的狮子>, <Book: 海贼王>, <Book: 哆啦A梦>]>
#3 res=models.Book.objects.filter(publishDate__year=2017)
# print(res)#<QuerySet [<Book: 三月的狮子>]>
#4 res=models.Book.objects.filter(title__startswith='水')
# print(res)#<QuerySet [<Book: 水星领航员>]>
#5 res=models.Book.objects.filter(title__contains='小')
# print(res)#<QuerySet [<Book: 百变小樱>]>
来源:https://www.cnblogs.com/ldq1996/p/7737827.html
标签:djang,查询,SQL
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
深入理解Tensorflow中的masking和padding
2022-01-26 02:21:44
python的继承知识点总结
2022-12-10 11:21:28
![](https://img.aspxhome.com/file/2023/0/65080_0s.jpg)
Python 将代码转换为可执行文件脱离python环境运行(步骤详解)
2023-05-02 13:29:31
![](https://img.aspxhome.com/file/2023/6/93706_0s.png)
MySql数据库基本命令集会
2011-08-05 18:43:23
浅谈ACCESS数据库升迁SQLSERVER注意事项
2007-08-11 13:44:00
用Python写个新年贺卡生成器
2023-08-26 00:56:45
![](https://img.aspxhome.com/file/2023/5/95725_0s.jpg)
介绍讲解MySQL安装下载登录
2010-10-25 20:34:00
PHP中集成PayPal标准支付的实现方法分享
2023-09-06 09:11:22
![](https://img.aspxhome.com/file/2023/0/55650_0s.gif)
python函数局部变量用法实例分析
2023-08-24 17:50:25
python 实现提取PPT中所有的文字
2023-05-01 04:21:35
![](https://img.aspxhome.com/file/2023/7/81637_0s.gif)
无法通过Google网站管理工具验证的部分情况解决办法
2009-07-28 12:56:00
Python中schedule模块定时任务的使用方法(2)
2023-09-01 09:59:59
多表关联同时更新多条不同的记录方法分享
2011-11-03 17:34:25
Python使用QRCode模块生成二维码实例详解
2022-07-04 16:50:44
python应用文件读取与登录注册功能
2023-04-17 17:04:03
一小时学会TensorFlow2之Fashion Mnist
2023-01-27 12:08:16
![](https://img.aspxhome.com/file/2023/2/85132_0s.jpg)
python计算两个数的百分比方法
2021-06-20 16:39:45
以SQLite和PySqlite为例来学习Python DB API
2023-07-13 02:19:14
![](https://img.aspxhome.com/file/2023/2/60512_0s.png)
python实现图片处理和特征提取详解
2023-10-04 02:28:16
![](https://img.aspxhome.com/file/2023/3/103763_0s.jpg)
Javascript操作表单之间的数据传递
2007-10-25 12:58:00