事务的使用-django

使用时需要安装第三方模块

pip install django-haystack whoosh jieba -i https://pypi.python.org/simple/            

# 加锁
from django.db import transaction
# 开启事务
with transaction.atomic():
    # 添加回滚
    point = transaction.savepoint()
    try:
        User.objects.filter(name='zhangsan').update(name='wangwu')
    except Exception as e:
        print(e)
        # 当修改失败后回滚
        transaction.savepoint_rollback(point)
        # 成功后提交
    transaction.savepoint_commit(point)

sql中的命令行

select @@global.transaction_isolation;   查看全局

select @@transaction_isolation;  查看当前

set session transaction isolation level serializable;   可串行化

开启事务
mysql> start transaction;


结束
commit