[sqlalchemy] many-to-many relation: unexpected count of rows

[Pavel S]

Hello,

I have relation User-User2Group-Group with additional attribute System on 
User2Group table.
The System is part of primary key, which means 
*'user can me member of group via multiple systems'.*
class User(Base):
    __tablename__ = 'User'

    name = Column('Name', Unicode(256), primary_key=True)

class Group(Base):
    __tablename__ = 'Group'

    name = Column('Name', Unicode(256), primary_key=True)

class User2Group(Base):
    __tablename__ = 'User2Group'
    
    userName = Column('UserName', Unicode(256), ForeignKey(User.name), 
primary_key=True)
    groupName = Column('GroupName', Unicode(256), ForeignKey(Group.name), 
primary_key=True)
    systemName = Column('SystemName', Enum('A', 'B', 'C'), primary_key=True)

User.groups = relationship(Group, secondary=User2Group.__table__)


Table User2Group looks like following

UserName | GroupName | SystemName
---------------------------------
fred     |  admins   | A
fred     |  admins   | B
fred     |  admins   | C


However when trying to delete user 'fred' wich is assinged to group 
'admins' via multiple systems A, B, C.

I'm getting error: DELETE statement on table 'User2Group' expected to 
delete 1 row(s); Only 3 were matched.

Did I misconfigured something?

Thanks

-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.