Oleg Broytmann a écrit :
> On Thu, Jun 15, 2006 at 10:30:41AM +0200, Fran?ois wrote:
>
>>> There is sqlbuilder.Alias,
>>>
>> But Alias is for Tables, no?
>>
>
> Oops, sorry, it is. There are no field aliases and adding ones would be
> a bigger job - one needs to patch all places where SQLObject generates SQL
> query strings in dbconnection.py, main.py and sqlbuilder.py.
>
> Oleg.
>
OK, so for
SELECT COUNT(table.field1) as MyAlias
FROM table
GROUP BY table.field2
ORDER BY MyAlias DESC
I make :
count = func.COUNT(Table.q.field1)
sql = conn.sqlrepr(sqlbuilder.Select([count]
,groupBy=Table.q.field2
)
)
alias = 'MyAlias'
count_original = "%s" % count
count_replace = "%s AS %s" % (count, alias)
sql.replace(count_original, count_replace)
return conn.queryAll(sql + " ORDER BY %s DESC" % alias)
Not really nice, but working :-)
François
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
