Changeset 801

Timestamp:

03/07/07 21:21:59 (2 years ago)

Author:

mfenniak

Message:

work on supporting numeric types

Files:

• pg8000/trunk/pg8000.py (modified) (4 diffs)
• pg8000/trunk/pg8000-test.py (modified) (1 diff)

pg8000/trunk/pg8000.py

@@ -593 +593 @@
-            self.verifyState("ready")
-            self._send(Protocol.Parse(statement, qs, [type(x) for x in params]))
-1,), params, (1
+0,), params, (0
-            self._send(Protocol.DescribePortal(portal))
-            self._send(Protocol.Flush())
@@ -741 +741 @@
-        return int(data)
-
+    def int4out(v):
+        return str(v)
+
-    def int4send(v):
-        return struct.pack("!i", v)
@@ -757 +760 @@
-        return datetime.datetime(year, month, day, hour, minute, sec)
-
+    def numeric_in(data, description):
+        if data.find(".") == -1:
+            return int(data)
+        else:
+            return decimal(data)
+
+    def numeric_out(v):
+        return str(v)
+
-    py_types = {
-23, None, int4send
+1700, numeric_out, None
-    }
-
@@ -766 +778 @@
-        23: (int4in, int4recv),
-        1114: (timestamp_in, timestamp_recv),
+        1700: (numeric_in, None),
-    }
-

pg8000/trunk/pg8000-test.py

@@ -28 +28 @@
-
-print "begin query..."
-
+, 22::numeric
-for row in cur1:
-    print repr(row)