[sqlalchemy] SAValidation: class-level validation for Declarative objects

2010-11-24 Thread Randy Syring
I wanted to let others know about a project I am working on to give active record style validations to declarative SA classes. The idea is that you can declare validation on individual fields or the whole class and have those validators fire when the session is flushed. I am not an SA guru by

[sqlalchemy] Failing test - SQLAlchemy 0.5.8, python 2.7.0

2010-11-24 Thread Martin Bacovsky
Hi, I'm trying to build SqlAlchemy 0.5.8 (Linux, python 2.7.0). From time to time some of the tests fail. - the sources are always the same - so far the only affected tests were those testing compilation of statements with joined tables - the orderning of the tables in the from clause seems

Re: [sqlalchemy] Failing test - SQLAlchemy 0.5.8, python 2.7.0

2010-11-24 Thread Michael Bayer
there might be some dictionary ordering dependencies in those tests, which will not behave consistently across platforms. if they fail with 0.6.5 as well, let me know and we'll file a ticket. There aren't any 0.5 releases planned. On Nov 24, 2010, at 7:06 PM, Martin Bacovsky wrote: Hi,

Re: [sqlalchemy] Failing test - SQLAlchemy 0.5.8, python 2.7.0

2010-11-24 Thread Martin Bacovsky
On Thursday, November 25, 2010 01:41 am, Michael Bayer wrote there might be some dictionary ordering dependencies in those tests, which will not behave consistently across platforms. if they fail with 0.6.5 as well, let me know and we'll file a ticket. There aren't any 0.5 releases

Re: [sqlalchemy] Failing test - SQLAlchemy 0.5.8, python 2.7.0

2010-11-24 Thread Michael Bayer
well I'd just take those tests out of 0.5 , I'm not sure if theres any other way to affect the outcome of nosetests without modifying SQLA code or tests directly. On Nov 24, 2010, at 8:17 PM, Martin Bacovsky wrote: On Thursday, November 25, 2010 01:41 am, Michael Bayer wrote there might be

Re: [sqlalchemy] Count over aliased JOIN

2010-11-24 Thread Michael Bayer
You should use func.count(expression) instead of query.count(). On Nov 23, 2010, at 1:52 PM, Juan Antonio Ibáñez juanito1...@gmail.com wrote: Hello I am joining one table with itself so I am using alias as: alias_usuarios1 = aliased(Usuario)