使用 ActiveRecord 冒泡嵌套事务失败 [英] Bubbling Up Nested-transaction Failures with ActiveRecord

问题描述

我在服务对象中有一个方法，该方法组合应包含在事务中的操作.其中一些操作也包含在事务中.例如:

I have a method in a service object that composes operations that should be wrapped in a transaction. Some of these operations are also wrapped in transactions. For example:

class PostCreator
   def create
      ActiveRecord::Base.transaction do
        post.do_this
        post.do_that
        user.do_more(post, other_stuff)
      end
   end
 end

 def Post
   def do_this
     transaction do; ...; end
   end
 end

我需要任何嵌套失败一直冒泡到顶部，但我不知道如何实现这一点，以及 嵌套事务 似乎没有提供解决方案.来自文档:

I need any nested failures to bubble up all the way to the top, but I'm not sure how to make that happen, and the ActiveRecord docs on nested transactions don't seem to offer a solution. From the docs:

# Standard nesting

User.transaction do
  User.create(username: 'Kotori')
  User.transaction do
    User.create(username: 'Nemu')
    raise ActiveRecord::Rollback    #  This won't bubble up:
                                    #  _Both_ users will still be created.
  end
end

# Nesting with `requires_new: true` on the nested transaction

User.transaction do
  User.create(username: 'Kotori')
  User.transaction(requires_new: true) do
    User.create(username: 'Nemu')
    raise ActiveRecord::Rollback    #  This won't bubble up either
                                    #  "Kotori" will still be created.
  end
end

推荐答案

以下是使嵌套事务中的失败冒泡的方法:

Here's how you could get failures in your nested transactions to bubble up:

User.transaction do
  User.create(username: 'Kotori')
  raise ActiveRecord::Rollback unless User.transaction(requires_new: true) do
    User.create(username: 'Nemu')
    raise ActiveRecord::Rollback
  end
end

基本上，您必须在顶级事务中引发错误才能使其回滚.为此，如果嵌套事务返回假值(nil)或真值，则会引发错误.

Basically, you have to raise an error in your top-level transaction for it to rollback too. To do that, you raise an error if the nested transaction returns a falsey value(nil) or a truthy value.

希望有帮助！

这篇关于使用 ActiveRecord 冒泡嵌套事务失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！