V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
推荐学习书目
› Learn Python the Hard Way
Python Sites
› PyPI - Python Package Index
› http://diveintopython.org/toc/index.html
› Pocoo
值得关注的项目
› PyPy
› Celery
› Jinja2
› Read the Docs
› gevent
› pyenv
› virtualenv
› Stackless Python
› Beautiful Soup
› 结巴中文分词
› Green Unicorn
› Sentry
› Shovel
› Pyflakes
› pytest
Python 编程
› pep8 Checker
Styles
› PEP 8
› Google Python Style Guide
› Code Style from The Hitchhiker's Guide
This topic created in 1847 days ago, the information mentioned may be changed or developed.
比如现在有如下表:
class Foo(models.Model):
id = fields.IntField(pk=True)
tags = fields.JSONField(default=['aa', 'bb', 'cc'])
想查询 tags 内含 bb 的数据项，该怎么写呢？
官方文档里面有个filtering感觉比较合适，但是这样写:
bb_tags = await Foo.filter(tags__in=['bb'])
并找不到数据。 另一个思路是直接写原始的 SQL Query:
async with in_transaction() as conn:
r = await conn.execute_query('SELECT tags FROM Foo')
然而我并不会写...
 |
1
jenlors Apr 6, 2021  1
可以使用自定义 function，https://tortoise-orm.readthedocs.io/en/latest/functions.html，看最后的样例，annotate + filter
|
Select Language