Changeset 816 for pg8000/trunk/pg8000.py

Timestamp:

03/08/07 23:12:42 (2 years ago)

Author:

mfenniak

Message:

Add support for NULL DB parameters and values

Files:

• pg8000/trunk/pg8000.py (modified) (4 diffs)

pg8000/trunk/pg8000.py

@@ -417 +417 @@
-            val = val + struct.pack("!h", len(self.params))
-            for param in self.params:
-
+
+
+
+
+
-            val = val + struct.pack("!h", len(self.out_fc))
-            for fc in self.out_fc:
@@ -976 +980 @@
-        if data == None:
-            raise NotSupportedError("type %r not mapped to pg type" % typ)
+        elif data.get("tid") == -1:
+            # special case: NULL values
+            return None
-        if fc == 0:
-            func = data.get("txt_out")
@@ -1016 +1023 @@
-
-    def py_value(v, description, **kwargs):
+        if v == None:
+            # special case - NULL value
+            return None
-        type_oid = description['type_oid']
-        format = description['format']
@@ -1134 +1144 @@
-        str: {"tid": 25, "txt_out": textout},
-        unicode: {"tid": 25, "txt_out": textout},
+        type(None): {"tid": -1},
-    }
-