Re: [Sqlalchemy-users] something broken with bytea

[Michael Bayer]

well I havent worked with blob types on postgres as of yet.  does it need to use the DBAPI "Binary" contstructor ?  right now the blob value is just bound to a bind parameter like any other value and sent into cursor.execute() with no processing.  If you can show me (or I will figure out) what the proper methodlogy is, it just gets built onto the PGBinary type within the convert_bind_param and convert_result_value methods as appropriate (or perhaps onto the base Binary type). On Dec 31, 2005, at 7:03 PM, Jonathan Ellis wrote: from sqlalchemy import * import urllib # CREATE TABLE foo ( #     id   serial PRIMARY KEY, #     blob bytea # ) WITH OIDS; engine = create_engine('postgres', ...) foo = Table('foo', engine, autoload = True) class Foo(object): pass assign_mapper(Foo, foo) f = Foo() f.blob = urllib.urlopen('http://schlockmercenary.com/comics/schlock20051231.png').read() print len(f.blob) # 38201 objectstore.commit () # select octet_length(blob) from foo; #  octet_length # ------------- #            8 -- Jonathan Ellis http://spyced.blogspot.com