Convert Sqlite Function from cx_Oracle
============================================================== 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
participants (2)
-
Carlos Eugenio
-
Oleg Broytman