class Paper(db.Model): __tablename__ = 'papers' reviewers = db.relationship('User', secondary=paper_reviewer, backref=db.backref('papers_reviewed', lazy='dynamic'), lazy='dynamic')
paper_reviewer = db.Table('paper_reviewer', db.Column('user_id', db.Integer, db.ForeignKey('users.id'), primary_key=True), db.Column('paper_id', db.Integer, db.ForeignKey('papers.id'), primary_key=True) ) @event.listens_for(Paper.reviewers, 'append')def paper_reviewers_append(target, value, initiator): # select queries... paper.reviewers.append(usr) db.session.add(paper) db.session.commit() The listener is fired before the execution of paper.reviewers.append(usr). The execution of append makes two insertions into paper_reviewer table. The second one causes IntegrityError: UNIQUE constraint failed. I tried different operations in the listener. If the operation in listener triggered any query, the IntegrityError would be caused while the commit() was executed. Not sure why listener could cause this error. Can anyone give me some details? Plz -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.