==============================================================
SQLITE3 Function
def get_db():
def dict_factory(cursor, row):
d = {}
for idx, col in enumerate(cursor.description):
d[col[0]] = row[idx]
return d
db = getattr(g, '_database', None)
if db is None:
db = g._database = sqlite3.connect(DATABASE)
db.row_factory = dict_factory
return db
================================================================
I try this form but isnt ok . Can I help me ?
import cx_Oracle
con = cx_Oracle.connect('xxxx/xxxx@xxxxxxx/xxxxxxx')
cur = con.cursor()
cur.execute("select * from test")
desc = [d[0] for d in cur.description]
result = [dict(zip(dec,line))for line in cur]
print (result)
cur.close()
--
Carlos EugĂȘnio
_______________________________________________
Python-Dev mailing list
[email protected]
https://mail.python.org/mailman/listinfo/python-dev
Unsubscribe:
https://mail.python.org/mailman/options/python-dev/archive%40mail-archive.com