select * from user where (in, use_name) in ((10, ''zhangsan), (20, ''lisi))
推荐学习书目
› 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 3591 days ago, the information mentioned may be changed or developed.
7 replies • 2016-07-16 08:12:14 +08:00
 |
1
yikoda OP 突然卡到这~ 好 tama 难、
|
 |
2
JhZ7z587cYROBgVQ Jul 15, 2016
```query(user).filter((user.in, user.use_name) in ((10, 'zhangsan'), (20, 'lisi'))).all()``` 这样子？，不是很看得懂那两个字段哎
|
 |
3
eriale Jul 15, 2016
session.query(user).filter(text("(in, user_name) in ((10, 'zhangsan'), (20, lisi'))")).all()
|
 |
5
mxi1 Jul 15, 2016
sqlalchemy 的一般用法，不是先定义一个 User 的 class ，然后通过 db_session 去 query 、 filter 吗？😅
|
 |
6
valuedlute Jul 15, 2016
嫌麻烦的话 session.execute(sql)
|
 |
7
aristotll Jul 16, 2016
r#6 @mickeyandkaka 高 简单粗暴...
|
Select Language