SQLite3的事务分为DEFERRED、IMMEDIATE和EXCLUSIVE三种模式。DEFERRED模式在第一次访问数据库时开始事务，而IMMEDIATE和EXCLUSIVE则立即开始写事务。EXCLUSIVE模式在非WAL模式下阻止其他连接读取数据库。Python的sqlite3模块默认使用DEFERRED模式，并需手动调用commit。
sqlite3在执行SQL语句的时候，如果不是显示的包含在transaction内(即begin...commit)，就是auto commit状态。即，每一条DML语句都会默认立即commit。有人也说这是sqlite3的隐式事务，而用begin开始用commit结束的，是显示事务。
注意python自带的sqlite3模块接口，不是这样的，必须要调用commit接口。
sqlite3有3种事务模式：DEFERRED, IMMEDIATE, or EXCLUSIVE.
DEFERRED
DEFERRED means that the transaction does not actually start until the database is first accessed. Internally, the BEGIN DEFERRED statement merely sets a flag on the database connection that turns off the automatic commit that would normally occur when the last statement finishes. This causes the transaction that is automatically started to persist until an explicit COMMIT or ROLLBACK or until a rollback is provoked by an error or an ON CONFLICT ROLLBACK clause. If the first statement after BEGIN DEFERRED is a SELECT, then a read transaction is started. Subsequent write statements will upgrade the transaction to a write
最低0.47元/天 解锁文章
753
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
