[sqlalchemy] Re: ORM Query that selects only a subset of the columns

2008-11-19 Thread Moshe C.
0.4.6 On Nov 19, 11:12 pm, Bobby Impollonia [EMAIL PROTECTED] wrote: What version of SQLA are you using? In .5 , you can pass individual columns instead of a mapped class to session.query. On Wed, Nov 19, 2008 at 12:17 PM, Moshe C. [EMAIL PROTECTED] wrote: For Query there is an

[sqlalchemy] Re: ORM Query that selects only a subset of the columns

2008-11-19 Thread Bobby Impollonia
Yeah, with .4 there isn't really a way have an ORM query that doesn't select at least one ORM object (possibly with additional columns/ objects added via add_column/ add_entity). You can use the select() construct instead if pulling all the columns of the mapped class is unacceptable. On Wed,

[sqlalchemy] Re: ORM Query that selects only a subset of the columns

2008-11-19 Thread Michael Bayer
0.4.7 and above supports query.values(col1, col2, ...) . use that. Bobby Impollonia wrote: Yeah, with .4 there isn't really a way have an ORM query that doesn't select at least one ORM object (possibly with additional columns/ objects added via add_column/ add_entity). You can use the

[sqlalchemy] Re: ORM Query that selects only a subset of the columns

2008-11-19 Thread Michael Bayer
query.distinct().values() or query.values(func.distinct(func.count(table.c.column))) Moshe C. wrote: How would that work with distinct() ? I see it returns an iterator and not a Query. On Nov 19, 11:39 pm, Michael Bayer [EMAIL PROTECTED] wrote: 0.4.7 and above supports query.values(col1,

[sqlalchemy] Re: ORM Query that selects only a subset of the columns

2008-11-19 Thread Michael Bayer
if 0.4.6 works you're great. take a look at the changelog to see what bugs have been fixed between 0.4.6 and 0.4.8. Moshe C. wrote: I have tried it out on 0.4.6 and it is working nicely. You mentioned 0.4.7 . Is there any bug I should be aware of in 0.4.6? I cannot upgrade in the near

[sqlalchemy] Re: ORM Query that selects only a subset of the columns

2008-11-19 Thread Moshe C.
Apparently, nothing changed specifically with the values() functionality. It was added as _values() in 0.4.5 . I guess 0.4.6 was the release of this feature, then. Cool. Thanks for your help On Nov 20, 12:47 am, Michael Bayer [EMAIL PROTECTED] wrote: if 0.4.6 works you're great.  take a