Using case templates to setup your database for integration tests with elixir and ecto.

ex_unite_case_template.ex

defmodule DBTransactions do
  use ExUnit.CaseTemplate

  setup_all do
    Ecto.Adapters.SQL.begin_test_transaction(Repo)

    on_exit fn ->
      Ecto.Adapters.SQL.rollback_test_transaction(Repo)
    end
  end

  setup do
    Ecto.Adapters.SQL.restart_test_transaction(Repo, [])
  end
end

# Use it in your test module
defmodule MessageTest do
  use DBTransactions
end