cx_oracle rowfactory,python – cx_Oracle：如何将每行作为字典接收？

您可以覆盖游标的rowfactory方法.每次执行查询时都需要执行此操作.

这是标准查询的结果,一个元组.

curs.execute('select * from foo')

curs.fetchone()

(33, 'blue')

返回一个命名元组：

def makeNamedTupleFactory(cursor):

columnNames = [d[0].lower() for d in cursor.description]

import collections

Row = collections.namedtuple('Row', columnNames)

return Row

curs.rowfactory = makeNamedTupleFactory(curs)

curs.fetchone()

Row(x=33, y='blue')

返回字典：

def makeDictFactory(cursor):

columnNames = [d[0] for d in cursor.description]

def createRow(*args):

return dict(zip(columnNames, args))

return createRow

curs.rowfactory = makeDictFactory(curs)

curs.fetchone()

{'Y': 'brown', 'X': 1}