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 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 future. > > > On Nov 20, 12:19 am, "Michael Bayer" <[EMAIL PROTECTED]> wrote: > >> 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 -~----------~----~----~----~------~----~------~--~---
