def makeDictFactory(cursor):
columnNames = [d[0] for d in cursor.description]
def createRow(*args):
return dict(zip(columnNames, args))
return createRow
def makeNamedTupleFactory(cursor):
columnNames = [d[0].lower() for d in cursor.description]
import collections
Row = collections.namedtuple(‘Row‘, columnNames)
return Row
Then, just after the cursor.execute() call, you can add:
cursor.rowfactory = makeDictFactory(cursor)
# or
cursor.rowfactory = makeNamedTupleFactory(cursor)
Oracle数据库之python oracle 查询返回字典
最新推荐文章于 2024-07-18 15:48:54 发布