hi werner,
Thanks for the help.It is working fine now.
On Tue, Feb 16, 2010 at 9:11 PM, werner <wbru...@free.fr> wrote:
> On 16/02/2010 15:48, Krishnakant Mane wrote:
>
>> On Tuesday 16 February 2010 07:01 PM, avdd wrote:
>>
>> Now the specific problem you see is that the ORM uses the declared
>>> ForeignKeys to determine how to join tables for a relation, but on
>>> your Detail table you have two foreign keys back to account and the
>>> ORM doesn't know which one to use.
>>>
>>> Even I have the same problem.
>> If one table has 2 columns as foreign keys which refer back to one column
>> in the parent table, how do we sort this problem out?
>>
>> I did it like this:
> class Recipeit(Base):
> __table__ = sa.Table(u'recipeit', metadata,
> sa.Column(u'recipeitid', sa.Integer(),
> sa.Sequence('gen_recipeit_recipeitid'), primary_key=True, nullable=False),
> ...
> sa.Column(u'fk_recipeid', sa.Integer(),
> sa.ForeignKey(u'recipe.recipeid'), nullable=False),
> sa.Column(u'ot_fk_recipeid', sa.Integer(),
> sa.ForeignKey(u'recipe.recipeid')),
> ...
> )
>
> recipe = sao.relation(Recipe, primaryjoin=
> ('Recipeit.fk_recipeid==Recipe.recipeid'))
> ot_recipe = sao.relation(Recipe, primaryjoin=
> ('Recipeit.ot_fk_recipeid==Recipe.recipeid'))
>
> Werner
>
>
> --
> 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<sqlalchemy%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
Njoy the share of Freedom :)
Anusha Kadambala
--
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.
