Re: [sqlalchemy] Upgrade to 0.7.8 breaks code for query().all()

2012-07-08 Thread Michael Bayer
yeah, actually, that's just what the behavior needs to be going forward, there are some improvements in 0.8 in that you'll be able to say correlate_except(SnortEvent), since you definitely don't want it correlated, so once that API is in place I'll add to the docs. The situation is that by sayi

Re: [sqlalchemy] Upgrade to 0.7.8 breaks code for query().all()

2012-07-08 Thread Michael Bayer
I have it appearing in 0.7.3, which would imply you're on 0.7.2 on the working system. On Jul 8, 2012, at 2:31 PM, Michael Bayer wrote: > its a bug. Here's a workaround, declare this outside of the Signature class: > > Signature.sig_count = column_property( >select([func.c

Re: [sqlalchemy] Upgrade to 0.7.8 breaks code for query().all()

2012-07-08 Thread Michael Bayer
its a bug. Here's a workaround, declare this outside of the Signature class: Signature.sig_count = column_property( select([func.count('*')]).\ where(SnortEvent.signature == Signature.id).\ correlate(Signature.__table__)

[sqlalchemy] Upgrade to 0.7.8 breaks code for query().all()

2012-07-08 Thread RedBaron
I have written some code on (I think) SqlAlchemy 0.7.5 on my office computer and it works perfectly. Now I tried to run the same code on my home computer and installed Sqlalchemy 0.7.8. However, the first query statement returned an error "InvalidRequestError: Select statement 'SELECT count(%s) AS