Changeset 827

Timestamp:

03/10/07 00:21:37 (2 years ago)

Author:

mfenniak

Message:

Add float and decimal output types

Files:

• pg8000/trunk/pg8000.py (modified) (2 diffs)
• pg8000/trunk/pg8000-test.py (modified) (2 diffs)

pg8000/trunk/pg8000.py

@@ -1207 +1207 @@
-        return float(data)
-
+    def float8send(v, **kwargs):
+        return struct.pack("!d", v)
+
-    # The timestamp_recv function is sadly not in use because some PostgreSQL
-    # servers are compiled with HAVE_INT64_TIMESTAMP, and some are not.  This
@@ -1278 +1281 @@
-        str: {"tid": 25, "txt_out": textout},
-        unicode: {"tid": 25, "txt_out": textout},
+        float: {"tid": 701, "bin_out": float8send},
+        decimal.Decimal: {"tid": 1700, "txt_out": numeric_out},
-        type(None): {"tid": -1},
-    }

pg8000/trunk/pg8000-test.py

@@ -7 +7 @@
-import pg8000
-
-
+#
-#db = pg8000.Connection(host='localhost', user='mfenniak')
-#
+
-
-print "testing db.execute and error recovery in NoData query"
@@ -81 +81 @@
-assert tuple(cur1.iterate_dict()) == ({"?column?": 5},)
-
+cur1.execute("SELECT $1", 22.333)
+retval = tuple(cur1.iterate_dict())
+assert retval == ({"?column?": 22.332999999999998},)
+
+cur1.execute("SELECT $1", decimal.Decimal("22.333"))
+retval = tuple(cur1.iterate_dict())
+assert retval == ({"?column?": decimal.Decimal("22.333")},)
+
-cur1.execute("SELECT 5000::smallint")
-assert tuple(cur1.iterate_dict()) == ({"int2": 5000},)