[sqlalchemy] sqlalchemy and running custom sql.

2007-05-27 Thread SamDonaldson
I'd like to be able to run a custom query without having to use any of the ORM stuff. I'd like to pass in a sql query string to some API that returns back to me instances (it'd be great), or tuples. How do I do this? Thanks. --~--~-~--~~~---~--~~ You received

[sqlalchemy] what is the use_alter kwarg for ForeignKeyConstraint?

2007-05-27 Thread Eric Ongerth
I'm curious about the use_alter keyword argument for ForeignKeyConstraint. It's there in the docs but with no explanation, and I've been tracking it through the sources but (forgive me) not quite figuring out exactly what it's doing. --~--~-~--~~~---~--~~ You

[sqlalchemy] checking the sql string.

2007-05-27 Thread SamDonaldson
How do I look to see what sql is being constructed in the query object? So if I have something like: q = query.session(User) q = q.add_column() q = q.group_by(.).select() How do I check what sql string has been constructed in q? Also, say I want to do a group by a particular column

[sqlalchemy] Re: The installed version of sqlite is out-dated..

2007-05-27 Thread anatoly techtonik
On May 25, 7:20 pm, Michael Bayer [EMAIL PROTECTED] wrote: On May 25, 2007, at 9:02 AM, anatoly techtonik wrote: .. and will cause errors in some cases. Version 3.3.13 or greater is recommended. Does anybody know where to get these updated binaries of pysqlite for windows? Those