Thanks to Michael Bayer I've added a whole load more tables to my query with
add_entity and join.
Now I've tried adding a table that is joined to more than one of the others and
get the error about onclause:
sqlalchemy.exc.ArgumentError: Can't determine join between 'Join object on Join
object on Join object on Join object on Join object on Join object on buildinfo_
gamedevice(16023024) and buildinfo_device(16043504)(42008272) and
buildinfo_manufacturer(16087600)(42007056) and
buildinfo_game(16041392)(42006576) and buildinf
o_channelgame(16153712)(42008432) and buildinfo_channel(16406480)(42005424) and
%(42107792 buildinfo_channelgame)s(42107792)' and 'buildinfo_build'; tables have
more than one foreign key constraint relationship between them. Please specify
the 'onclause' of this join explicitly.
- How do I set the onclause ?
I tried setting the condition in the .join but this didn't seem to help.
- Is this complicated by the fact that the mappings are created by sqlsoup?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
