Re: [sqlalchemy] Example project

2010-01-29 Thread Michael Chambliss
to store database initialization and configuration - how to store models in separate files, and how to interact with them Thanks Daniel -- Michael Chambliss em...@mchambliss.com -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post

Re: [sqlalchemy] Map to Arbitrary Select Using Raw SQL

2010-01-27 Thread Michael Chambliss
Michael Chambliss wrote: Michael Bayer wrote: On Jan 26, 2010, at 7:48 PM, Michael Chambliss wrote: Presently, I'm trying to determine the best way to map a class against an arbitrary select where the select is constructed from raw SQL. Based on this, it's possible using the expression

Re: [sqlalchemy] Map to Arbitrary Select Using Raw SQL

2010-01-27 Thread Michael Chambliss
King Simon-NFHD78 wrote: You'll have to give it a table name, which will have the effect of defining a Table object even though no such table exists in the database, but I don't think this matters. Then you could use the query that Mike suggested to actually retrieve rows Thanks, Simon - I ended

[sqlalchemy] Map to Arbitrary Select Using Raw SQL

2010-01-26 Thread Michael Chambliss
Hello, I'm new to SQLAlchemy (and really Python in general) and admittedly I'm probably not following the best process for learning it. Ultimately, I'd prefer to deal with raw SQL as opposed to working through the expression building methods despite the benefits of the framework I leave on

Re: [sqlalchemy] Map to Arbitrary Select Using Raw SQL

2010-01-26 Thread Michael Chambliss
Michael Bayer wrote: On Jan 26, 2010, at 7:48 PM, Michael Chambliss wrote: Presently, I'm trying to determine the best way to map a class against an arbitrary select where the select is constructed from raw SQL. Based on this, it's possible using the expression builders: http