Re: [sqlalchemy] Re: BLOB and str comparisons

2010-05-23 Thread Yang Zhang
On Sat, May 22, 2010 at 4:12 PM, Michael Bayer mike...@zzzcomputing.com wrote: On May 22, 2010, at 1:14 AM, Michael Bayer wrote: On May 21, 2010, at 10:04 PM, Yang Zhang wrote: Also, how do I do the wrapping portably? For sqlite3 I have to wrap with sqlite3.Binary, for postgresql I have to

Re: [sqlalchemy] Re: BLOB and str comparisons

2010-05-23 Thread Michael Bayer
On May 23, 2010, at 3:48 AM, Yang Zhang wrote: Ah, I was *just* about to paste you a test case I constructed. Glad to see this get fixed, really appreciate it. yup its always best to start with those so I can just run it and see the problem immediately. -- Yang Zhang

Re: [sqlalchemy] Re: BLOB and str comparisons

2010-05-22 Thread Michael Bayer
On May 22, 2010, at 1:14 AM, Michael Bayer wrote: On May 21, 2010, at 10:04 PM, Yang Zhang wrote: Also, how do I do the wrapping portably? For sqlite3 I have to wrap with sqlite3.Binary, for postgresql I have to wrap with psycopg2.Binary, etc. I am not able to reproduce your error in

[sqlalchemy] Re: BLOB and str comparisons

2010-05-21 Thread Yang Zhang
On Fri, May 21, 2010 at 6:47 PM, Yang Zhang yanghates...@gmail.com wrote: I'm trying to run the following:  session.query(Activity).filter(Activity.blob == blob).one() where Activity.blob is a BLOB and blob is a Python bytes object (equiv. to str in Python 2.x). But although I can insert

Re: [sqlalchemy] Re: BLOB and str comparisons

2010-05-21 Thread Michael Bayer
On May 21, 2010, at 10:04 PM, Yang Zhang wrote: On Fri, May 21, 2010 at 6:47 PM, Yang Zhang yanghates...@gmail.com wrote: I'm trying to run the following: session.query(Activity).filter(Activity.blob == blob).one() where Activity.blob is a BLOB and blob is a Python bytes object (equiv.