|
register some better adapters & converters.
Ripped from pysqlite2.dbapi2. see its license
These tests aren't very useful for humans. XXX fix IGNORE - I couldn't
get # doctest:+ELLIPSIS working
>>> conn=sqlite3.connect(":memory:", detect_types=sqlite3.PARSE_DECLTYPES)
>>> IGNORE=conn.execute("create table test (test_date date, test_time time, test_datetime datetime)")
>>> d=datetime.date(2007, 4, 4)
>>> t=datetime.time(11, 8, 42)
>>> t2=datetime.time(11, 8, 42, 1234)
>>> dt=datetime.datetime(2007, 4, 4, 11, 8, 42, 1234)
>>> IGNORE=conn.execute("insert into test values (?, ?, ?)", (d, t, dt))
>>> d_, t_, dt_=conn.execute("select * from test").fetchone()
>>> d_
datetime.date(2007, 4, 4)
>>> t_
datetime.time(11, 8, 42)
>>> dt_
datetime.datetime(2007, 4, 4, 11, 8, 42, 1234)
>>> IGNORE=conn.execute("delete from test")
>>> IGNORE=conn.execute("insert into test values (?, ?, ?)", (d, t2, dt))
>>> d_, t2_, dt_=conn.execute("select * from test").fetchone()
>>> d_
datetime.date(2007, 4, 4)
>>> t2_
datetime.time(11, 8, 42, 1234)
>>> dt_
datetime.datetime(2007, 4, 4, 11, 8, 42, 1234)
|
