==============================================================
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
Python-Dev@python.org
https://mail.python.org/mailman/listinfo/python-dev
Unsubscribe: 
https://mail.python.org/mailman/options/python-dev/archive%40mail-archive.com

Reply via email to