Hi all, and thanks for the replies: got things to work now!
FYI: If I had the choice, I would definitely use a shared primary key.
Unfortunately I am working off a legacy database so that is not an
option. Neither is renaming DB columns. So I went for the "rename
columns on the mapper" solution. I redefined the Employee mapper as
follows:
mapper(Employee, employee_table, inherits=person_mapper,
properties={'person_id': person_table.c.id,
'id': employee_table.c.id},
)
and that solved the problem: alice1.name and alice2.name now both
return "alice".
This was indeed a pretty thorny issue, and I am not sure I have
totally wrapped my head around it yet. Anyways, thank you all again
for the help on this.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
