[Sqlalchemy-users] self-joins, namespace schemas

[daishi]

Hi,

I'm wondering if someone could provide an example
of "self-joins" via the ORM/mapper? I'm attaching
a code sample to illustrate what I've tried below.

The current error that I get is:


It appears that my code implicitly creates two
mapper objects, based on pdb.pm() inspection.
I'm not sure how the mapper_registry/hashkey
get managed and initialized, so I couldn't move
forward with debugging.

I am also using namespace schemas, and believe
that there is a problem with ForeignKey objects
not handling namespace schemas. I am attaching
a patch for that.

(I have simplified the attached test.py to not
use namespace schemas).

Thanks,
Daishi

Non-primary property created for attribute 'parent2o' on class 'Subject', but that attribute is not managed! Insure that the primary mapper for this class defines this property: None

test.py
Description: Binary data

schema.diff
Description: Binary data