InvalidRequestError: This session is in 'committed' state; no further SQL can be emitted within this

今天药忘吃喽~ 2023-06-24 04:56 9阅读 0赞

### Flask Sqlalchemy 事务报错： ###

### 源代码如下： ###

class CompareInfo(db.Model, SearchableMixin):
    
        __tablename__ = "compareinfo"
        __searchable__ = ["fromtext", "totext", "create_at"]
    
        id = db.Column(db.Integer, primary_key=True)
        deleted = db.Column(db.String(2), default='00', nullable=False)
        created_at = db.Column(db.DateTime, default=sqlalchemy.func.now(), nullable=False)
        updated_at = db.Column(db.DateTime, default=sqlalchemy.func.now(), onupdate=sqlalchemy.func.now(),
                               nullable=False)

### 问题解决 ###

经排查发现，问题出在default=sqlalchemy.func.now()，将sqlalchemy.func.now()改为datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")问题得以解决。

class CompareInfo(db.Model, SearchableMixin):
    
        __tablename__ = "compareinfo"
        __searchable__ = ["fromtext", "totext", "create_at"]
    
        id = db.Column(db.Integer, primary_key=True)
        deleted = db.Column(db.String(2), default='00', nullable=False)
        create_at = db.Column(db.DateTime, default=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"), nullable=False)
        update_at = db.Column(db.DateTime, default=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"), nullable=False)
        fromtext = db.Column(db.TEXT, nullable=False)
        totext = db.Column(db.TEXT, nullable=False)
        result = db.Column(db.String(10), nullable=False)