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, 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 select() >> > construct instead if pulling all the columns of the mapped class is >> > unacceptable. >> >> > On Wed, Nov 19, 2008 at 1:25 PM, Moshe C. <[EMAIL PROTECTED]> wrote: >> >> >> 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 add_column() method, but I do not see a >> remove >> >>> > column method. >> >>> > Initializing a Query requires a full mapped class, so how can I >> >>> select >> >>> > on only a subset of the columns. >> >> >>> > I want to do this for ding a DISTINCT query on only a couple of >> >>> > columns. >> >> >>> > TIA >> >>> > Moshe > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
