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 2896 days ago, the information mentioned may be changed or developed.
如何动态构建 query,
有时候要写个 demo server,所以用了 tinydb 这个库，但是有一个问题，如何动态构造 query 呢？
querys = []
for name in ("a", "b","c", "d"):
val = self.get_argument(name,"")
if val:
querys.append(where(name)==val)
list=db.search(querys)
有没有了办法实现上面那种效果呢？
 |
1
nbboy May 28, 2018  1
太小众了把。
|
 |
2
louisganlu May 30, 2018 1
http://tinydb.readthedocs.io/en/latest/usage.html
The second, traditional way of constructing queries is as follows: >>> from tinydb import where >>> db.search(where('field') == 'value') Using where('field') is a shorthand for the following code: >>> db.search(Query()['field'] == 'value') Accessing nested fields with this syntax can be achieved like this: >>> db.search(where('birthday').year == 1900) >>> db.search(where('birthday')['year'] == 1900) |
Select Language