Elixir Ecto：Schema配置多组belongs_to关联cast操作报错求解

你一共存在两个核心配置错误：

• 关联方向完全颠倒：迁移文件中你是给matches表增加了指向players表的外键，说明一场比赛绑定两个选手，应该是Match属于Player，而不是Player属于Match，你之前把has_many写在Match中、belongs_to写在Player中的逻辑完全不符合外键设计
• 字段与关联名不匹配：迁移文件中定义的外键是单数first_player、second_player，但你在Schema中定义的关联名是复数first_players、second_players，导致cast操作无法识别对应字段

1. 修正Match Schema定义 #

defmodule TennisPhx.Matches.Match do
  use Ecto.Schema
  import Ecto.Changeset
  alias TennisPhx.Participants.Player

  schema "matches" do
    # 显式指定外键和关联类型，匹配迁移文件的字段名
    belongs_to :first_player, Player, foreign_key: :first_player
    belongs_to :second_player, Player, foreign_key: :second_player

    # 保留原有其他字段定义
    field :starting_datetime, :utc_datetime
    belongs_to :location, TennisPhx.Events.Location
    belongs_to :phase, TennisPhx.Events.Phase
    belongs_to :status, TennisPhx.Events.Status
    belongs_to :player_unit, TennisPhx.Events.PlayerUnit
    belongs_to :tour, TennisPhx.Events.Tour

    timestamps()
  end

  @doc false
  def changeset(match, attrs) do
    match
    # 保留first_player、second_player到允许字段列表
    |> cast(attrs, [:tour_id, :first_player, :second_player, :starting_datetime, :location_id, :phase_id, :status_id, :player_unit_id])
    |> validate_required([:tour_id, :first_player, :second_player, :location_id, :phase_id, :player_unit_id])
  end
end

2. 修正Player Schema定义 #

defmodule TennisPhx.Participants.Player do
  use Ecto.Schema
  import Ecto.Changeset

  alias TennisPhx.Matches.Match

  schema "players" do
    # 保留原有其他字段定义
    field :name, :string
    field :nickname, :string
    field :info, :string
    field :birthdate, :date

    # 定义反向关联，区分选手作为第一/第二参赛的比赛列表
    has_many :matches_as_first, Match, foreign_key: :first_player
    has_many :matches_as_second, Match, foreign_key: :second_player

    timestamps()
  end

  @doc false
  def changeset(player, attrs) do
    player
    |> cast(attrs, [:name, :nickname, :info, :birthdate])
    |> validate_required([:name])
  end
end

3. 修正assign_match函数传参 #

如果参数中的first_player、second_player是Player结构体，直接传入id即可：

def assign_match(%Tour{} = tour, first_player, second_player, day, month, year, location, phase, unit) do
  %Match{}
  |> Match.changeset(%{
    tour_id: tour.id,
    first_player: first_player.id,
    second_player: second_player.id,
    location_id: location,
    phase_id: phase,
    player_unit_id: unit
  })
  |> Repo.insert()
end

• 第一个报错unknown field :first_player given to cast：你原有Match Schema中仅定义了复数的first_players关联，不存在first_player字段或关联，cast操作无法识别
• 第二个报错casting assocs with cast/4 for :first_players field is not supported：first_players是你定义的has_many关联，cast不支持直接处理关联类型字段，需要用cast_assoc，但本身你的关联方向设计错误，即使使用cast_assoc也无法实现预期逻辑

内容的提问来源于stack exchange，提问作者John Sheppard