On Jan 21, 10:59 am, Stuart Axon <stua...@yahoo.com> wrote:
> Hi,
> I've been using sqlalchemy with sqlsoup and having some trouble getting my
> head around joins in here as opposed to sql.
>
> I've two tables, device + manufacturer
>
> [device]
> id, device_name, manufacturer
>
> [manufacturer]
> id, manufacturer_name
>
> I can't seem to get a result that contains both device_name and
> manufacturer_name...
>
> >>> device.first()
>
> MappedBuildinfo_device(id=1,device_name='c701',manufacturer_id=1)
>
> >>> manufacturer.first(
>
> MappedBuildinfo_manufacturer(id=1,manufacturer_name='alcatel')
>
> >>> device.join(manufacturer).first()
>
> MappedBuildinfo_device(id=1034,device_name='s920',manufacturer_id=1)
>
SQLSoup may make this more complicated, but you should probably say
x.add_entity(y).join(X.y).first().
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@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
-~----------~----~----~----~------~----~------~--~---
