Oracle数据库之python oracle 查询返回字典

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)