Search⌘ K
AI Features
Home
Courses
Building Database Applications in Elixir with Ecto

Solution: Work with Transactions and the Multi Module

Explore how to use Ecto.Multi to manage multiple related database inserts within a transaction in Elixir. Understand creating changesets and combining insert operations to execute them atomically, improving database consistency and error handling. This lesson prepares you to effectively handle complex database workflows using Ecto.

We'll cover the following...

Solution

We are going to rewrite this code by using Ecto.Multi.

Elixir
cs = Ecto.Changeset.change(%Album{title: "Bag's Groove", artist_id: 1})
  |> Ecto.Changeset.validate_required([:title])
Repo.transaction(fn -> 
  case Repo.insert(cs) do
    {:ok, _album} -> IO.puts("Album insert succeeded") 
    {:error, _value} -> Repo.rollback("Album insert failed")
  end
  case Repo.insert(Log.changeset_for_insert(cs)) do
    {:ok, _log} -> IO.puts("Log insert succeeded")
    {:error, _value} -> Repo.rollback("Log insert failed")
  end
end)

It inserts a new album record as well as a log entry. We used an anonymous function with the ...