Hi,
For the last 2 days, I’ve be trying to implement Triplex to add multi-tenancy to my application, and I use transactions a lot, usually with Ecto.Multi.
From the documentation it looks like with triplex I need to use:
Triplex.create_schema(slug, Project.Repo, fn(tenant, repo) ->
Repo.transaction(fn ->
mig = Triplex.migrate(tenant, repo)
IO.inspect(mig, label: "MIGRATE")
// Add any ecto operation here...
tenant
end)
end)
My problem is that Triplex.migrate(tenant, repo) is always, always returning:
{:error,
"ERROR 42P01 (undefined_table) relation \"prj_c24.schema_migrations\" does not exist\n\n query: INSERT INTO \"prj_c24\".\"schema_migrations\" (\"version\",\"inserted_at\") VALUES ($1,$2)"}
For me this is an extreme confusing error. It tells nothing about what is happening, (at least for me).
My only migration is this:
defmodule Project.Repo.Migrations.CreateUsersTables do
use Ecto.Migration
def change do
# execute "CREATE EXTENSION IF NOT EXISTS citext", ""
create table(:users, primary_key: false) do
add(:id, :uuid, primary_key: true, null: false)
# add(:email, :citext, null: false)
add(:hashed_password, :string, null: false)
add(:first_name, :string, null: false)
add(:last_name, :string, null: false)
add(:is_enabled, :boolean, null: false, default: true)
add(:dob, :date)
add(:photo, :string, default: "/images/empty.png")
add(:confirmed_at, :naive_datetime)
timestamps()
end
# create unique_index(:users, [:email])
end
end
Any help on that error? thanks
PS: The prefix is being created in the database. But migrations are not running.
❯ elixir --version
Erlang/OTP 24 [erts-12.1.5] [source] [64-bit] [smp:16:16] [ds:16:16:10] [async-threads:1] [jit] [dtrace]
Elixir 1.13.0 (compiled with Erlang/OTP 24)
{:triplex, "~> 1.3.0-rc.1"}
