postgresql – 在Flask-SQLAlchemy中自动提交

发布时间：2020-12-13 16:34:44 所属栏目：百科来源：网络整理

导读：如何设置我的Flask应用程序的初始化以将Flask-SQLAlchemy设置为自动提交模式,除非我显式地调用session.begin(),否则不使用事务？会议“begins a database transaction as soon as it starts communicating”.这对Po??stgres的影响比MySQL更难吗？到Instagr

如何设置我的Flask应用程序的初始化以将Flask-SQLAlchemy设置为自动提交模式,除非我显式地调用session.begin(),否则不使用事务？

会议“begins a database transaction as soon as it starts communicating”.这对Po??stgres的影响比MySQL更难吗？

到Instagram年,

autocommit mode; in this mode,Psycopg2 won’t issue BEGIN/COMMIT for
any queries; instead,every query runs in its own single-statement
transaction. This is particularly useful for read-only queries where
transaction semantics aren’t needed. It’s as easy as doing:

connection.autocommit = True

This lowered chatter between our application servers and DBs
significantly,and lowered system CPU as well on the database boxes

我想你可以在Flask-SQLAlchemy中设置autocommit这样做：

from flask.ext.sqlalchemy import SQLAlchemy
db = SQLAlchemy(session_options={'autocommit': True})

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!