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
-~----------~----~----~----~------~----~------~--~---

Reply via email to