/Doc/includes/sqlite3/row_factory.py

http://unladen-swallow.googlecode.com/ · Python · 13 lines · 11 code · 2 blank · 0 comment · 1 complexity · 53a4712cc8d445085804bdcfafe17b01 MD5 · raw file 

    

  1. import sqlite3
    2. 

  2. 

  3. def dict_factory(cursor, row):
    4. 

  4.     d = {}
    5. 

  5.     for idx, col in enumerate(cursor.description):
    6. 

  6.         d[col[0]] = row[idx]
    7. 

  7.     return d
    8. 

  8. 

  9. con = sqlite3.connect(":memory:")
    10. 

  10. con.row_factory = dict_factory
    11. 

  11. cur = con.cursor()
    12. 

  12. cur.execute("select 1 as a")
    13. 

  13. print cur.fetchone()["a"]
    14.