Triplex v1.3.0 Triplex View Source
This is the main module of Triplex.
The main objetive of it is to make a little bit easier to manage tenants through postgres db schemas or equivalents, executing queries and commands inside and outside the tenant without much boilerplate code.
Using the tenant
This module has useful functions to manage your tenants, like create/1,
rename/2 and drop/1, but if you’re trying to apply the tenant to a
query, changeset or schema, stay with your application Repo, sending the
prefix. Like this:
Repo.all(User, prefix: Triplex.to_prefix("my_tenant"))
It’s a good idea to call Triplex.to_prefix on your tenant name, altough is
not required. Because, if you configured a tenant_prefix, this function will
return the prefixed one.
Link to this section Summary
Functions
Returns all the tenants on the given repo
Returns a %Triplex.Config{} struct with all the args loaded from the app
configuration
Creates the given tenant on the given repo
Creates the tenant schema/database on the given repo
Drops the given tenant on the given repo
Returns if the given tenant exists or not on the given repo
Migrates the given tenant on your repo
Returns the path for the tenant migrations on your repo
Renames the old_tenant to the new_tenant on the given repo
Returns if the given tenant is reserved or not
Returns the list of reserverd tenants
Returns the value of the configured tenant field on the given map
Returns the tenant name with the given prefix
Link to this section Functions
Returns all the tenants on the given repo.
Returns a %Triplex.Config{} struct with all the args loaded from the app
configuration.
Creates the given tenant on the given repo.
Returns {:ok, tenant} if successful or {:error, reason} otherwise.
Besides creating the database itself, this function also loads their
structure executing all migrations from inside
priv/YOUR_REPO/tenant_migrations folder. By calling create_schema/3
sending migrate/2 as the func callback.
See migrate/2 for more details about the migration running.
Ecto 3 migrations, triplex and transactions
So on Ecto 3, migrations were changed to run on async tasks. Because of
that it’s not possible anymore to run Triplex.create/2 inside of a
transaction anymore.
But there is a way to achieve the same results using create_schema/3
and migrate/2. Here is an example using transaction:
Repo.transaction(fn ->
{:ok, _} = Triplex.create("tenant")
User.insert!(%{name: "Demo user 1"})
User.insert!(%{name: "Demo user 2"})
end)
And here is how you could achieve the same results on success or fail:
Triplex.create_schema("tenant", Repo, fn(tenant, repo) ->
Repo.transaction(fn ->
{:ok, _} = Triplex.migrate(tenant, repo)
User.insert!(%{name: "Demo user 1"})
User.insert!(%{name: "Demo user 2"})
# the [`create_schema/3`](#create_schema/3) function must return `{:ok, "tenant"}`
# if succeeded, and `Repo.transaction` transforms the function results
# on this tuple
tenant
end)
end)
So, if the function given to create_schema/3 returns an error tuple, it will
rollback the created schema and return that tuple to you. Check out
create_schema/3 docs for more details.
Creates the tenant schema/database on the given repo.
Returns {:ok, tenant} if successful or {:error, reason} otherwise.
After creating it successfully, the given func callback is called with
the tenant and the repo as arguments. The func must return
{:ok, any} if successfull or {:error, reason} otherwise. In the case
the func fails, this func will rollback the created schema and
fail with the same reason.
The function to_prefix/1 will be applied to the tenant.
Drops the given tenant on the given repo.
Returns {:ok, tenant} if successful or {:error, reason} otherwise.
The function to_prefix/1 will be applied to the tenant.
Returns if the given tenant exists or not on the given repo.
The function to_prefix/1 will be applied to the tenant.
Migrates the given tenant on your repo.
Returns {:ok, migrated_versions} if successful or {:error, reason} otherwise.
The function to_prefix/1 will be applied to the tenant.
Returns the path for the tenant migrations on your repo.
Renames the old_tenant to the new_tenant on the given repo.
Returns {:ok, new_tenant} if successful or {:error, reason} otherwise.
The function to_prefix/1 will be applied to the old_tenant and
new_tenant.
Returns if the given tenant is reserved or not.
The function to_prefix/1 will be applied to the tenant.
Returns the list of reserverd tenants.
By default, there are some limitations for the name of a tenant depending on the database, like “public” or anything that start with “pg_”.
You also can configure your own reserved tenant names if you want with:
config :triplex, reserved_tenants: ["www", "api", ~r/^db+$/]
Notice that you can use regexes, and they will be applied to the tenant names.
Returns the value of the configured tenant field on the given map.
Returns the tenant name with the given prefix.
If the prefix is omitted, the tenant_prefix configuration from
Triplex.Config will be used.
The tenant can be a string, a map or a struct. For a string it will
be used as the tenant name to concat the prefix. For a map or a struct, it
will get the tenant_field/0 from it to concat the prefix.