Question about Contexts and Pivot tables

Another way is to have 2 User schemas, one in Account, one in Server.

Account User would be read/write, Server User would be read only, and used into link to Server context.

Could you link to an example of something like this? I’m having a bit of trouble wrapping my head around it.

Curiously Yes I can…

I was doing something similar with 2 contexts, Accounting and Social.

This one allows to create, update User

defmodule Chat.Accounting.User do
  @moduledoc false
  
  use Ecto.Schema
  import Ecto.Changeset
  alias __MODULE__
  alias Chat.Accounting.Phone

  schema "users" do
    field :email, :string
    field :name, :string
    field :password, :string, virtual: true
    field :password_hash, :string
    
    has_one :phone, Phone, on_delete: :delete_all

    timestamps()
  end
  
  @required_fields ~w(name email)a
  @registration_fields ~w(password)a  
  
  @doc false
  
  # Because of Postgres constraints errors
  # You will receive only the first constraint error, not all of them!
  
  def changeset(%User{} = user, attrs \\ %{}) do
    user
    |> cast(attrs, @required_fields)
    |> validate_required(@required_fields)
    |> validate_length(:name, min: 1, max: 32)
    |> validate_format(:email, ~r/@/)
    |> unique_constraint(:name, message: "Name already taken")
    |> unique_constraint(:email, message: "Email already taken")
  end
  
  @doc false
  def registration_changeset(user, attrs \\ %{}) do
    user
    |> changeset(attrs)
    |> cast(attrs, @registration_fields)
    |> validate_required(@registration_fields)
    |> validate_length(:password, min: 6, max: 32)
    |> generate_encrypted_password()
  end

  # PRIVATE

  defp generate_encrypted_password(changeset) do
    case changeset do
      %Ecto.Changeset{valid?: true, changes: %{password: password}} ->
        put_change(changeset, :password_hash, Comeonin.Bcrypt.hashpwsalt(password))
      _ ->
        changeset
    end
  end
end

This one allows to manage User association, inside Social context.

defmodule Chat.Social.User do
  @moduledoc false
  
  use Ecto.Schema
  import Ecto.Changeset
  alias __MODULE__
  alias Chat.Social.{Group, Post, Comment}
  
  schema "users" do
    field :email, :string
    field :name, :string
    
    many_to_many :followeds, User, 
      join_through: "followings", 
      join_keys: [follower_id: :id, followed_id: :id], 
      on_delete: :delete_all,
      on_replace: :delete
    
    many_to_many :followers, User, 
      join_through: "followings", 
      join_keys: [followed_id: :id, follower_id: :id], 
      on_delete: :delete_all,
      on_replace: :delete
      
    many_to_many :groups, Group, 
      join_through: "subscriptions",
      on_delete: :delete_all,
      on_replace: :delete
    
    has_many :owned_groups, Group
    has_many :posts, Post
    has_many :comments, Comment
    
    timestamps()
  end
  
  def follow_changeset(%User{} = user, attrs \\ %{}) do
    user
    |> cast(attrs, [])
    |> put_assoc(:followeds, attrs[:followeds])
  end
  
  def group_changeset(%User{} = user, attrs \\ %{}) do
    user
    |> cast(attrs, [])
    |> put_assoc(:groups, attrs[:groups])
  end
end

As You can see they refer to the same table, but they both represent a User, inside their respective contexts.

Social User cannot be created, they don’t know what a password is, but they can join group, and follow other User as well.

Thanks, this really helped me understand how this works

Hi @kokolegorille, thank you for sharing, I’ve been applying this approach which is having multi schemas mapping to a same database table.

Things go well, however, when writing unit tests for the Context having the read-only schema, with Ecto.Repo, I don’t know how to insert data into the DB table since the schema doesn’t have the full of fields and doesn’t have all of the not-null constraints, unique constraints, foreign key constraints,… If we use Ecto.Repo.insert_all/3 , it’s kind of a lot of manual work, since the table may refer to many others.

To be clearer, for example in your code sample, let’s assume that in DB, table column users.password is not-null. So when writing unit tests for your Social context, how to insert mock data into users table with Chat.Social.User schema? Because if we use %Chat.Social.User{} then :password will be null.

Thank you.

Hello and welcome.

As Social.User cannot be created… I would create Accounting.User in the setup block of Social.User test to have some data before.

Thank you. That way is possible. But would it be considered as a across context dependency (even in unit test) since the unit test of Social text depends on User schema in Account context?

Yes it is. But it’s hard to create data from this User read-only context.