Re: [Sqlalchemy-users] something broken with bytea

[Michael Bayer]

I implemented the dbapi.Binary() constructor at the base of types.Binary, and created a new unit test that saves/retrieves a couple of .pyc files.  It succeeds for mysql, postgres, and sqlite (all of which needed the Binary constructor)....changeset 775/776. 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