Add SQL transactions support about model HOT 6 CLOSED

something like that using sequel like the link provided:

def transaction(options = {})
   DB.transaction(options) do
      yield # if a exception is raised here, then the rollback is fired.
   end
end

from model.

@AlfonsoUceda yes, but we don't have a DB constant. SqlAdapter holds an instance variable called @connection, which is the same Sequel type of DB.

from model.

Because the only high level object that we expose to developers is a repository, we should consider to add that method there. Example BookRepository.transaction { ... }.

from model.

@jodosha can you assing to me please? I'm going to do a PR later or in this weekend

from model.

@jodosha I have a dude with the implementation, If you use the Repository.transaction I think you will use the repository inside, isn't it? I give you 2 examples but I think it should be explicitly done.

what do you think?

UserRepository.transaction { UserRepository.first }
# or
UserRepository.transaction { first }

from model.

@AlfonsoUceda It should be a public method and context free (first option in your example).

A bit of explanation, this can be useful for complex scenarios where several entities needs to be persisted atomically, and eventually rolled back in case of error.

class Signup
  def initialize(params)
    @user = User.new(params[:user])
    @account = Account.new(params[:account])
  end

  def call
    AccountRepository.transaction do
      AccountRepository.create(@account)
      UserRepository.create(@user)
    end
  end
end

from model.