print result as hash in sqlalchemy

Question

sql = select id,name from table
res = session.execute(sql)
for row in res:
    print row

this code print result of execute sql( without names) as array. How to print result as hash ? (with id,name)

Answer 1

Try this:

columns = ('id', 'name')

sql = 'select %s from table' % ','.join(columns)
res = session.execute(sql)
for row in res:
    rowDict = dict(zip(columns, row))