Django + MYSQL事务回滚

最新推荐文章于 2024-09-12 20:46:18 发布

念小東

最新推荐文章于 2024-09-12 20:46:18 发布

阅读量425

点赞数

分类专栏： MYSQL 文章标签： Django MYSQL 事务回滚

本文链接：https://blog.youkuaiyun.com/weixin_39779316/article/details/101701005

版权

MYSQL 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍Django中使用原子性(atomic)装饰器和上下文管理器进行事务处理的方法，以及如何利用savepoint_commit进行错误回滚，确保数据一致性和事务的正确性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、atomic

1，atomic 被用作装饰器

from django.db import transaction
 
@transaction.atomic
def viewfunc(request):
    # This code executes inside a transaction.
    do_stuff()

2，atomic被用作上下文管理器

from django.db import transaction
 
def viewfunc(request):
    # This code executes in autocommit mode (Django's default).
    do_stuff()
 
    with transaction.atomic():
        # This code executes inside a transaction.
        do_more_stuff()

二、savepoint_commit

def atomic(using=None):
        sid = transaction.savepoint(using=using)
        try:
            yield
        except IntegrityError:
            transaction.savepoint_rollback(sid, using=using)
            raise
        else:
            transaction.savepoint_commit(sid, using=using)

def forwards(self, orm):
        from sentry.db.models import create_or_update
        from sentry.utils.query import RangeQuerySetWrapperWithProgressBar

        OrganizationMember = orm['sentry.OrganizationMember']
        Team = orm['sentry.Team']

        queryset = Team.objects.all()

        for team in RangeQuerySetWrapperWithProgressBar(queryset):
            sid = transaction.savepoint()
            try:
                OrganizationMember.objects.create(
                    organization_id=team.organization_id,
                    user_id=team.owner_id,
                    type=0,  # OWNER
                )
            except IntegrityError:
                transaction.savepoint_rollback(sid)
            else:
                transaction.savepoint_commit(sid)
            transaction.commit()