Changeset 845

Timestamp:

03/13/07 12:31:49 (2 years ago)

Author:

mfenniak

Message:

Add datetime type upload.

Files:

• pg8000/trunk/pg8000.py (modified) (2 diffs)
• pg8000/trunk/pg8000_test.py (modified) (1 diff)

pg8000/trunk/pg8000.py

@@ -1497 +1497 @@
-        return datetime.datetime(year, month, day, hour, minute, int(sec), int((sec - int(sec)) * 1000000))
-
+    def timestamp_out(v, **kwargs):
+        return v.isoformat(' ')
+
-    def numeric_in(data, **kwargs):
-        if data.find(".") == -1:
@@ -1557 +1560 @@
-        decimal.Decimal: {"tid": 1700, "txt_out": numeric_out},
-        Bytea: {"tid": 17, "bin_out": byteasend},
+        datetime.datetime: {"tid": 1114, "txt_out": timestamp_out},
-        type(None): {"tid": -1},
-    }

pg8000/trunk/pg8000_test.py

@@ -330 +330 @@
-                "retrieved value match failed")
-
+    def TestTimestampRoundtrip(self):
+        v = datetime.datetime(2001, 2, 3, 4, 5, 6, 170000)
+        db.execute("SELECT $1 as f1", v)
+        retval = tuple(db.iterate_dict())
+        self.assert_(retval == ({"f1": v},),
+                "retrieved value match failed")
+
-    def TestOidIn(self):
-        db.execute("SELECT oid FROM pg_type")