Re: [sqlalchemy] Nested bundles, labels and "Ambiguous column name"

2015-09-08 Thread Jacob Magnusson
Michael, Is there any chance we might see support for *with_labels* in this use case? Even though my "solution" works, it's somewhat of an annoyance with all these warnings being spit out: *SAWarning: Column 'id' on table 0x110cd5d30; Select object> being replaced by Column('id', Integer(),

Re: [sqlalchemy] Nested bundles, labels and "Ambiguous column name"

2015-09-08 Thread Mike Bayer
On 9/8/15 4:13 AM, Jacob Magnusson wrote: Michael, Is there any chance we might see support for /with_labels/ in this use case? Even though my "solution" works, it's somewhat of an annoyance with all these warnings being spit out: /SAWarning: Column 'id' on table being replaced by

Re: [sqlalchemy] Nested bundles, labels and "Ambiguous column name"

2015-09-08 Thread Mike Bayer
On 9/8/15 12:03 PM, Mike Bayer wrote: On 9/8/15 4:13 AM, Jacob Magnusson wrote: Michael, Is there any chance we might see support for /with_labels/ in this use case? Even though my "solution" works, it's somewhat of an annoyance with all these warnings being spit out: /SAWarning:

Re: [sqlalchemy] Nested bundles, labels and Ambiguous column name

2015-04-09 Thread Mike Bayer
On 4/9/15 1:50 PM, Jacob Magnusson wrote: I have this case with a bundle that looks something like this: |primate_bundle = Bundle( 'primate', Primate.name, Bundle('wooden_tool', *[ WoodenTool.id, WoodenTool.name, WoodenToolCategory.name.label('category'), ]), Bundle('solid_tool', *[

Re: [sqlalchemy] Nested bundles, labels and Ambiguous column name

2015-04-09 Thread Jacob Magnusson
Thanks for the quick reply Michael. I would love to hear what you can find out about it. I have what I think is a pretty horrible and dirty “solution”. But it *seems* to work. What I’ve done is to assign the key attribute of columns like this: from collections import namedtuple

[sqlalchemy] Nested bundles, labels and Ambiguous column name

2015-04-09 Thread Jacob Magnusson
I have this case with a bundle that looks something like this: primate_bundle = Bundle( 'primate', Primate.name, Bundle('wooden_tool', *[ WoodenTool.id, WoodenTool.name, WoodenToolCategory.name.label('category'), ]), Bundle('solid_tool', *[