SQLALCHEMY-遍历数据 [英] SQLALCHEMY - Iterating through data
本文介绍了SQLALCHEMY-遍历数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
当我使用SQLALchemy时,如何遍历列名?
When I am using SQLALchemy how would one iterate through column names?
例如.
Column Name 1, Column Name 2, Column Name 3, etc...
第二个问题是我有以下查询:
The second question is I have the following query:
root = dbsession.query(MyTable).filter(MyTable.name==u'john').all()
但是,当我这样做时:
for row in root:
print row
我没有任何结果.相反,我必须这样做:
I don't get any results. Instead I have to do:
print row.name, row.age, etc...
我不能只是执行print row
从所有列返回数据吗?
Can't I just do print row
to return data from all the columns?
推荐答案
dbsession.query(MyTable).filter(MyTable.name==u'john')
将通过ORM并返回对象.如果只想返回所有列,则可以使用以下方法绕过ORM:
dbsession.query(MyTable).filter(MyTable.name==u'john')
will go through ORM and return you objects. If you just want to return all columns, you can bypass ORM with this:
query = dbsession.query(MyTable).filter(MyTable.name==u'john')
rows = query.statement.execute().fetchall()
for row in rows:
print row
这篇关于SQLALCHEMY-遍历数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文