I'm doing something like this where each Item has 2 ForeignKeys to Dealer for
buyer and seller:
seller = dealers.alias('seller')
buyer = dealers.alias('buyer')
engine.execute(select([items, seller.c.name, buyer.c.name]).fetchall()
When I do this the seller and buyer name end up in the results and are both
called 'name' which isn't very useful. If I add 'use_labels=True' it messes up
all the column names from items.
Is there some way to just have it alias them to seller_name and buyer_name?
It's easy to do in pure sql.
Thanks,
Michael
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
