/Doc/includes/sqlite3/rowclass.py

http://unladen-swallow.googlecode.com/ · Python · 12 lines · 10 code · 2 blank · 0 comment · 1 complexity · e7cda939cd654a4582d354ba0a539202 MD5 · raw file 

    

  1. import sqlite3
    2. 

  2. 

  3. con = sqlite3.connect("mydb")
    4. 

  4. con.row_factory = sqlite3.Row
    5. 

  5. 

  6. cur = con.cursor()
    7. 

  7. cur.execute("select name_last, age from people")
    8. 

  8. for row in cur:
    9. 

  9.     assert row[0] == row["name_last"]
    10. 

  10.     assert row["name_last"] == row["nAmE_lAsT"]
    11. 

  11.     assert row[1] == row["age"]
    12. 

  12.     assert row[1] == row["AgE"]
    13.