Information on "primaryjoin" and "secondaryjoin" is available at:
http://www.sqlalchemy.org/docs/05/mappers.html#advdatamapping_relation_customjoin On Sep 25, 2008, at 8:18 PM, Jorge Vargas wrote: > > hello I'm having a bit of troubles with the following case. > > http://paste.turbogears.org/paste/8177 > > This is the error I'm getting. Now I know it has to do with SA not > being able to know to which field to map state.id, but how do I fix > it? > > "Specify a 'primaryjoin' expression. If this is a many-to-many > relation, 'secondaryjoin' is needed as well." % (self)) > sqlalchemy.exc.ArgumentError: Could not determine join condition > between parent/child tables on relation MappedPolicy.state. Specify a > 'primaryjoin' expression. If this is a many-to-many relation, > 'secondaryjoin' is needed as well. > > PS: in case you where wondering for commodity I need those to values > present in the table and since they are always going to be two it > isn't such a bad design decision... although I may optimize the > "state" table into a python list or dict in the future. I want to know > how to fix this. > > > --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---