EctoTemp is an Ecto extension to support using PostgreSQL temporary tables with Ecto. This can be useful in situations where permanent tables may not be viable, such as when testing data migrations (where the schema at the time of test creation will differ over time), or to test modules that extend Ecto, but are not concernted with a specific schema.

This library is tested against the most recent 3 versions of Elixir and Erlang.

This library is part of the Synchronal suite of libraries and tools which includes more than 15 open source Elixir libraries as well as some Rust libraries and tools.

You can support our open source work by sponsoring us. If you have specific features in mind, bugs you'd like fixed, or new libraries you'd like to see, file an issue or contact us at contact@reflective.dev.

Add ecto_temp to mix.exs. Consider only adding it to the :test environment.

def deps do
  [
    {:ecto_temp, "~> 1.2", only: :test}
  ]
end

EctoTemp provides several macros which can be included by useing EctoTemp.

defmodule MyTest do
  use MyProject.DataCase
  use EctoTemp, repo: MyProject.Repo

  require EctoTemp.Factory
  alias EctoTemp.Factory

  deftemptable :things do
    column :data, :string, null: false
    column :data_with_default, :string, default: "default value"
    deftimestamps()
  end

  setup do
    create_temp_tables()
    :ok
  end

  test "insert records" do
    Factory.insert(:things, data: "stuff")
  end
end

• Documentation