put strings into group_by:
group_by = ["client_code", "client_name", ...]
On Jun 6, 2007, at 7:07 PM, Huy Do wrote:
>
> Hi,
>
> I am trying to reuse my column list in my group by clause but some
> of my
> columns use label() which is causing a sql syntax error because of the
> "column as label" in the group by clause. Is it possible to get the
> group_by to only use the "label" side of a column .
>
> eg. (This doesn't work because of the "labels"
> group_by = [
> service.date,
> service.client_id,
> service_type.type_code,
> service.service_code,
> client.code.label('client_code'),
> client.name.label('client_name'),
> func.coalesce(func.nullif(client_rate.description,
> ''),
> service_type.description).label('service_description'),
> service.rate_amt
> ]
> columns = group_by[:].extend([
> func.sum(service.quantity).label('quantity'),
> func.sum(service.service_amt).label('service_amt')
> ])
>
> s = select(columns, criteria,
> from_obj=[outerjoin(db.service_table,
> db.client_rate_table),
> db.job_table, db.client_table, db.service_type_table],
> group_by=group_by,
> order_by=[service.date, client.name, service.service_code]
> )
>
> Many thanks,
>
> Huy
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
