IMHO, it doesn't seem to be a bug. The error message reveals that it's
missing the required join that defines the relation between the
objects.
So, the actual question is where to put this join.
Regards,
Ben
On Aug 29, 8:53 pm, "Gaetan de Menten" <[EMAIL PROTECTED]> wrote:
> On 8/29/07, Ben Schwarze <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > Hi all,
>
> > I'm having a problem in using inheritance in combination with multiple
> > ForeignKeys.
>
> > --------------------------------------------
>
> > from elixir import *
>
> > metadata.bind = 'sqlite:///mydbname.sqlite'
>
> > class A(Entity):
> > has_field('name', String)
> > using_options(shortnames=True, inheritance='multi',
> > polymorphic=True)
>
> > class B(A):
> > has_many('many_c', of_kind='C', inverse='some_b')
> > using_options(shortnames=True, inheritance='multi',
> > polymorphic=True)
>
> > class C(A):
> > belongs_to('some_b', of_kind='B', inverse='many_c')
> > using_options(shortnames=True, inheritance='multi',
> > polymorphic=True)
>
> > create_all()
>
> > --------------------------------------
>
> > Executing this example it gives me the following error:
>
> > sqlalchemy.exceptions.ArgumentError: Can't determine join between
> > 'Join object on a b' and 'c'; tables have more than one foreign key
> > constraint relationship between them. Please specify the 'onclause' of
> > this join explicitly.
>
> > How can this problem be solved?
>
> This is obviously a bug in Elixir or SQLAlchemy. Unfortunately I have
> no time at the moment to track it down. If you want to help fixing it,
> the first step is to translate your example into raw SQLAlchemy code
> and see if that works or not.
>
> If it doesn't work, please report it to the SQLAlchemy's list.
> Otherwise, report back here, along with your SQLAlchemy code so that I
> can figure out what is Elixir doing differently.
> --
> Gaëtan de Mentenhttp://openhex.org
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en
-~----------~----~----~----~------~----~------~--~---
