summaryrefslogtreecommitdiff
path: root/examples/dt.py
diff options
context:
space:
mode:
authorFederico Di Gregorio <fog@initd.org>2005-10-18 14:44:57 +0000
committerFederico Di Gregorio <fog@initd.org>2005-10-18 14:44:57 +0000
commit49a255059e6873e9c26ca80e4f0f7f3e0e997977 (patch)
treebb063c6229ec175284a53edf408b9c732583a51a /examples/dt.py
parent8d4607ebbde66325c3a560c1ea16f5108d113fd6 (diff)
downloadpsycopg2-49a255059e6873e9c26ca80e4f0f7f3e0e997977.tar.gz
Releasing 2.0 beta 5.2_0_BETA_5
Diffstat (limited to 'examples/dt.py')
-rw-r--r--examples/dt.py16
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)