Re: [SQLObject] How do I select distinct columns?

[Leandro L. <ll...@gm...>]

Thierry Lam, el  4 de mayo a las 14:47 me escribiste:
>    I'm using SQLObject 0.7.0 and I'm having lots of trouble retrieve a list
>    of distinct columns from my table. What is the equivalent of the following
>    in SQLObject?
> 
>     
> 
>    Table: users
> 
>    Columns: id, name, age
> 
>     
> 
>    SELECT distinct name FROM users
> 
>     
> 
>    The only way I can do the above is the following which uses raw sql
>    statement:
> 
>     
> 
>    c = users._connection
> 
>    return c.queryAll('SELECT distinct name FROM users')
> 
>     
> 
>    Is there an alternative way to do the above?

An OO alternative:
names = set([u.name for u in users.select()])

If you need performance, I think c.queryAll() is the way to go.

-- 
LUCA - Leandro Lucarella - Usando Debian GNU/Linux Sid - GNU Generation
------------------------------------------------------------------------
E-Mail / JID:     lu...@lu...
GPG Fingerprint:  D9E1 4545 0F4B 7928 E82C  375D 4B02 0FE0 B08B 4FB2 
GPG Key:          gpg --keyserver pks.lugmen.org.ar --recv-keys B08B4FB2
------------------------------------------------------------------------
they wrap me up in the back of the trunk
packed with foam and blind drunk
they won't ever take me alive
cause they all drive killer cars