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

最新推荐文章于 2023-01-17 18:48:39 发布

我心依依旧

最新推荐文章于 2023-01-17 18:48:39 发布

阅读量1.6k

点赞数

分类专栏： # flask

本文链接：https://blog.csdn.net/a200822146085/article/details/103636448

版权

flask 专栏收录该内容

23 篇文章 0 订阅

订阅专栏

Flask Sqlalchemy 事务报错：

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

源代码如下：

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)