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 1850 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