Hi,
When wrapping a query with an enclosing query to add columns computed from
the original query's columns, I'm blatantly doing this:
order_clause_list = ClauseList(*fact_query._order_by_clause)
fact_query._order_by_clause = ClauseList()
subq = fact_query.alias('forperc')
return select(
[subq.c[k] for k in subq.c.keys()] + [
<extra columns based on subq's columns>
for dim in percentage_dims
]
).order_by(*order_clause_list)
since I want the original query's ordering, and subquery ordering is not
guaranteed to be maintained.
This works (in 0.7.5). But it messes with internals (_order_by_clause). So
is there a more proper way to do this (for general queries), against the
public sql.expression API?
Regards,
Gulli
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/HlBjhxwBMxQJ.
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.
