[sqlalchemy] Re: Help convert my SQL query to SQLAlchemy

2009-09-11 Thread Richie Ward
0.5.1, I will try with a later version if there is one. Heres full test code: from datetime import datetime from sqlalchemy import * from sqlalchemy.orm import mapper, relation from sqlalchemy import Table, ForeignKey, Column from sqlalchemy.types import Integer, Unicode, DateTime from

[sqlalchemy] Re: Help convert my SQL query to SQLAlchemy

2009-09-11 Thread Richie Ward
WOW it works with 0.5.5, I am surprised they found the bug and actually fixed it before I did! I am impressed! That was a complex query, keep up the good work guys! 2009/9/12 Richie Ward rich...@gmail.com: 0.5.1, I will try with a later version if there is one. Heres full test code: from

[sqlalchemy] Re: Help convert my SQL query to SQLAlchemy

2009-09-07 Thread Michael Bayer
when I run it i get the correct: SELECT content.modulename AS content_modulename, content.revision_id AS content_revision_id, content.content AS content_content FROM content WHERE content.revision_id IN (SELECT max(content.revision_id) AS max_1 FROM content GROUP BY content.modulename) AND