[sqlalchemy] Re: correlated subquery w/ ORM queries

2008-10-12 Thread Michael Bayer
On Oct 11, 2008, at 9:41 PM, Jonathan Ellis wrote: I want to do something like this: select ticket.*, (select count(*) from ticket_changes where ticket_changes.ticket = ticket.id) as count from ticket at the ORM layer. My best stab at it was subquery =

[sqlalchemy] Re: Can't connect to local MySQL server

2008-10-12 Thread coder_gus
Check that /tmp is writable. morecowbell wrote: make sure your mysqld.sock is in the location mysql expects it to be. default is /tmp/mysql.sock; if you are using darwinports, depending on mysql version it's /opt/local/var/run/mysqld/mysqld.sock (append mysql version to mysqld).

[sqlalchemy] Re: ClauseList with join?

2008-10-12 Thread Alessandro Dentella
On Sat, Oct 11, 2008 at 11:19:31PM -0400, Michael Bayer wrote: On Oct 11, 2008, at 1:44 PM, sandro dentella wrote: Hi, I started using the .join() method on query and that' s really powerful, with reset_joinpoint and the list of attributes setting the path of relations. Now

[sqlalchemy] Re: ClauseList with join?

2008-10-12 Thread az
On Sunday 12 October 2008 19:05:44 Alessandro Dentella wrote: On Sat, Oct 11, 2008 at 11:19:31PM -0400, Michael Bayer wrote: On Oct 11, 2008, at 1:44 PM, sandro dentella wrote: Hi, I started using the .join() method on query and that' s really powerful, with reset_joinpoint and

[sqlalchemy] SQLAlchemy 0.4.8 released

2008-10-12 Thread Michael Bayer
This release fixes a critical SQLite bug introduced by a backwards incompatible change in Pysqlite 2.5.0, which seems to be packaged in the latest Debian Release as well as Python 2.6. Download SQLAlchemy 0.4.8 at: http://www.sqlalchemy.org/download.html 0.4.8 = - orm - Fixed bug

[sqlalchemy] SQLAlchemy 0.5.0rc2 Released

2008-10-12 Thread Michael Bayer
This release fixes a critical SQLite bug introduced by a backwards incompatible change in Pysqlite 2.5.0, which seems to be packaged in the latest Debian Release as well as Python 2.6. There are additionally many bugfixes to the 0.5 series as we approach the final 0.5 release. Download