Hi, Is there a way for SQLAlchemy to silently avoid duplicate entries in a Many-To-Many Association Table? My current set-up; class UserRole(db.Model): __tablename__ = 'user_roles'
id = Column(Integer, primary_key=True) rolename = Column(Unicode(80), unique=True) UserUserRoleTable = Table('user_user_roles', db.Model.metadata, Column('user_id', Integer, ForeignKey('users.id')), Column('user_role_id', Integer, ForeignKey('user_roles.id')), UniqueConstraint('user_id', 'user_role_id', name='uix_1') ) class User(db.Model): __tablename__ = 'users' id = Column(Integer, primary_key=True) roles = relationship("UserRole", secondary=lambda: UserUserRoleTable, backref="users") Code:: r1 = UserRole('news_add') db.session.add(r1) r3 = UserRole('news_del') db.session.add(r3) me = Administrator() me.fullname = 'Sjoerd Huisman' me.roles.append(r1) me.roles.append(r3) me.roles.append(r1) db.session.add(me) Without the UniqueConstraint rows are the r1 is added twice. With the UniqueConstraint, there is a big error. Thanks for any thoughts! -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/mNJa_CN1Id8J. 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.