Hello Michael, many thanks for answer.

The tables are inputted automatically by SQLAlchemy. Because of this I
thought there should not be confusion over schema names.

Well, I could solve the problem by following code:
---------------------------------------
 
@mapper_property('hapo.common.countries.Country',secondary_table='cou2ent')
    def citizens(self, mapper, cou_mapper, metadata, username,
cou2ent):
        return sqlalchemy.orm.relation(
            cou_mapper,
            uselist=True,
            secondary= cou2ent,
 
primaryjoin=mapper.local_table.c.ent_id==cou2ent.c.ent_key,
 
secondaryjoin=cou2ent.c.cou_key==cou_mapper.local_table.c.cou_iso2,
            foreign_keys = [cou2ent.c.cou_key, cou2ent.c.ent_key]
        )
---------------------------------------
Thank you very much indeed.
Kai
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to