cx oracle 返回字典,python – 如何使cx-oracle将查询的结果绑定到字典而不是元组？...

Bindvars用于执行查询

>按名称(给定命名参数)

cursor = self.db.cursor()

cursor.execute("SELECT bookName, author from books where Id=:bookId" , bookId="155881")

print cursor.bindnames()

将打印：[‘BOOKID’]

按照位置给出一个值列表

cursor = self.db.cursor()

cursor.prepare("insert into books (bookId,title,author,price) values(:1, :2, :3, :4)")

cursor.executemany(None, listOfbookwhichAreTuppleOf4Field )

为了得到你的期望,你可以尝试这样的事情：

def connect():

dsn = cx_Oracle.makedsn("host", 1521, "sid")

orcl = cx_Oracle.connect('scott/tiger@' + dsn)

curs = orcl.cursor()

sql = "select * from sometable"

curs.execute(sql)

desc = [d[0] for d in curs.description]

result = [dict(zip(desc,line)) for line in curs]

curs.close()