[sqlalchemy] 2nd Level Cache and RowTuples

Hello, I'm using SQLAlchemy .5 to produce result sets composed of columns from multiple tables and mapped entities. I'd like to cache these results, but since RowTuples cannot be pickled, I'm having a hard time figuring out how to go about doing this. Any suggestions? Thanks, Justin

[sqlalchemy] exclude_properties in .5

Hello, I've been playing around with .5 a bit since I like the ability to select individual columns a lot. I've noticed, however, that the exclude_properties for mapper() doesn't seem to work. The mapped object still has the properties I've put in that list. Justin

[sqlalchemy] Counts that depend on joins

Hello, I am doing a A-B join before I do any filtering on a query object constructed from A. I then to filtering based on C. I have a column_property mapped to A that gives me the total number of B. This is executed as a subquery, which means it gives me the total number of B in the database,

[sqlalchemy] Re: Counts that depend on joins

On May 23, 4:33 pm, Justin Tulloss [EMAIL PROTECTED] wrote: I am doing a A-B join before I do any filtering on a query object Sorry, this should be A-B-C join. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups