hi there, I am using sqlalchemy 0.5.3 with the following declaration: # membership class tblMembershiptype(Base2): __table__ = tables2["tblMembershiptype"] company_members = relation( tblCompany, secondary=tables2["tblMembership"], backref='membershiptyp', ) person_members = relation( tblPerson, secondary=tables2["tblMembership"], backref='membershiptyp', )
I get a traceback as follows, pretending that tblMembershiptype.person_members': property of that name exists on mapper 'Mapper|tblPerson|tblPerson' why is that so? I add the relation to two different tables, so the backref should not be added to the same class. thanks for any help robert Traceback (most recent call last): File "transfer.py", line 803, in ? main() File "transfer.py", line 774, in main updateProfileMembership() File "transfer.py", line 664, in updateProfileMembership h = tblTeveHandler(howmany=1000) File "transfer.py", line 427, in __init__ q = self.tevesession.query(tblTeve) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py", line 908, in query return self._query_cls(entities, self, **kwargs) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py", line 95, in __init__ self.__setup_aliasizers(self._entities) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py", line 109, in __setup_aliasizers mapper, selectable, is_aliased_class = _entity_info(entity) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/util.py", line 466, in _entity_info mapper = class_mapper(entity, compile) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/util.py", line 543, in class_mapper mapper = mapper.compile() File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/mapper.py", line 679, in compile mapper._post_configure_properties() File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/mapper.py", line 701, in _post_configure_properties prop.init(key, self) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/interfaces.py", line 404, in init self.do_init() File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/properties.py", line 579, in do_init self._post_init() File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/properties.py", line 838, in _post_init self.backref.compile(self) File "/usr/local/lib/python2.4/site-packages/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/properties.py", line 995, in compile raise sa_exc.ArgumentError("Error creating backref '%s' on relation '%s': " sqlalchemy.exc.ArgumentError: Error creating backref 'membershiptyp' on relation 'tblMembershiptype.person_members': property of that name exists on mapper 'Mapper|tblPerson|tblPerson' --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---