have you tried
mapper(Engineer, engineers, inherits=person_mapper,
polymorphic_identity='engineer', properties={
'manager': relation(Manager,
primaryjoin=engineers.c.manager_id==managers.c.person_id)
})
?
On Nov 2, 2006, at 12:52 PM, asrenzo wrote:
>
> Hi,
>
> Following the documentation about inheritance (Multiple Table
> Inheritance, Polymorphic), I get into troubles trying to add a
> relation
> between tables.
>
> I just used the documentation sample and modified the engineers table
> this way :
>
> engineers = Table('engineers', metadata,
> Column('person_id', Integer, ForeignKey('employees.person_id'),
> primary_key=True),
> Column('engineer_info', String(50)),
> Column('manager_id', Integer, ForeignKey('managers.person_id')),
> )
>
> I try to add a manager to an engineer.
>
> Even if everything is fine in the database, after a
> metadata.create_all(), I can not figure out how to set the relation
> between engineers and managers in my mappers.
>
> Seems like I misunderstood something but I'm stopped.
>
> Any help ??
>
> Regards,
>
> Laurent.
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
