SQLALCHEMY-遍历数据 [英] SQLALCHEMY - Iterating through data

问题描述

当我使用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屋！