/Doc/includes/sqlite3/parse_colnames.py

http://unladen-swallow.googlecode.com/ · Python · 8 lines · 7 code · 1 blank · 0 comment · 0 complexity · 681833372f9c072fcf6fe83be0021dcc MD5 · raw file 

    

  1. import sqlite3
    2. 

  2. import datetime
    3. 

  3. 

  4. con = sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_COLNAMES)
    5. 

  5. cur = con.cursor()
    6. 

  6. cur.execute('select ? as "x [timestamp]"', (datetime.datetime.now(),))
    7. 

  7. dt = cur.fetchone()[0]
    8. 

  8. print dt, type(dt)
    9.