diff options
| author | Federico Di Gregorio <fog@initd.org> | 2005-10-18 14:44:57 +0000 |
|---|---|---|
| committer | Federico Di Gregorio <fog@initd.org> | 2005-10-18 14:44:57 +0000 |
| commit | 49a255059e6873e9c26ca80e4f0f7f3e0e997977 (patch) | |
| tree | bb063c6229ec175284a53edf408b9c732583a51a /examples/dt.py | |
| parent | 8d4607ebbde66325c3a560c1ea16f5108d113fd6 (diff) | |
| download | psycopg2-49a255059e6873e9c26ca80e4f0f7f3e0e997977.tar.gz | |
Releasing 2.0 beta 5.2_0_BETA_5
Diffstat (limited to 'examples/dt.py')
| -rw-r--r-- | examples/dt.py | 16 |
1 files changed, 10 insertions, 6 deletions
diff --git a/examples/dt.py b/examples/dt.py index 78d5355..9933164 100644 --- a/examples/dt.py +++ b/examples/dt.py @@ -18,7 +18,8 @@ DSN = 'dbname=test' ## don't modify anything below tis line (except for experimenting) -import sys, psycopg2 +import sys +import psycopg2 import mx.DateTime import datetime @@ -30,14 +31,13 @@ conn = psycopg2.connect(DSN) curs = conn.cursor() try: - curs.execute("""CREATE TABLE test_dt (k int4, d date, t time, dt timestamp, - z interval)""") + curs.execute("""CREATE TABLE test_dt ( + k int4, d date, t time, dt timestamp, z interval)""") except: conn.rollback() curs.execute("DROP TABLE test_dt") - curs.execute("""CREATE TABLE test_dt (k int4, - d date, t time, dt timestamp, - z interval)""") + curs.execute("""CREATE TABLE test_dt ( + k int4, d date, t time, dt timestamp, z interval)""") conn.commit() # build and insert some data using mx.DateTime @@ -48,6 +48,10 @@ mx1 = ( mx.DateTime.Timestamp(2004, 10, 19, 0, 11, 17.5), mx.DateTime.DateTimeDelta(13, 15, 17, 59.9)) +from psycopg2.extensions import adapt +import psycopg2.extras +print adapt(mx1) + print "Inserting mx.DateTime values..." curs.execute("INSERT INTO test_dt VALUES (%s, %s, %s, %s, %s)", mx1) |
