user表里有N条记录，表里有3个字段，uid, username, avatar，这个时候，客户端post给服务端一个用户uid的字典，例如{123,332,190,201}，那么我如何根据这些传过来的uid，查询到数据后，返回给客户端这4个uid数据库表字段中的username和avatar啊？
推荐学习书目
› 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 4207 days ago, the information mentioned may be changed or developed.
 |
1
saximoer Dec 3, 2014
返回几个User 对象的LIST 或者转成JSON 呗~
不晓得有没有帮助 |
 |
2
maroon Dec 3, 2014  1
select * from user where id in (1,2,3,4);
|
 |
3
p8p8 OP @tornado.gen.coroutine
def get_myfriens(self,friends): query = 'SELECT username, avatar_url FROM users WHERE mid IN (759428,480672);' cursor = yield self.execute(query) 这样会报错： psycopg2.ProgrammingError: operator does not exist: text = integer LINE 1: SELECT username, avatar_url FROM users WHERE mid in (759428,... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. |
|
4
p8p8 OP 是我自己字段的问题，设置好了，谢谢大家！
|
Select Language