[SQLObject] Patch to Support psycopg.Binary

[J-P L. <sql...@si...>]

<mailto:sql...@li...>This is a patch against 
v0.5.1.  I'm using bytea field types in my tables and this patch makes 
life easier.  In my SQLObject classes, I do:

def _set_data(self, val):
    self._SO_set_data(psycopg.Binary(val))

Seems to work with some preliminary testing.


Index: SQLObject/Converters.py
===================================================================
RCS file: /usr/local/cvs/depot/sqlobject/SQLObject/Converters.py,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -5 -r1.1 -r1.2
--- SQLObject/Converters.py    17 Nov 2003 22:36:02 -0000    1.1
+++ SQLObject/Converters.py    18 Dec 2003 15:03:27 -0000    1.2
@@ -135,10 +135,19 @@
     return "(%s)" % ", ".join([sqlrepr(v, db) for v in value])
 
 registerConverter(type(()), SequenceConverter)
 registerConverter(type([]), SequenceConverter)
 
+try:
+    import psycopg
+except ImportError: pass
+else:
+    def PsycopgBinaryConverter(value, db):
+        return str(value)
+
+    registerConverter(type(psycopg.Binary('')), PsycopgBinaryConverter)
+
 if hasattr(time, 'struct_time'):
     def StructTimeConverter(value, db):
         return time.strftime("'%Y-%m-%d %H:%M:%S'", value)
 
     registerConverter(time.struct_time, StructTimeConverter)