elixir - Ecto 变更集和多对多关联 "is invalid"错误

Question

我有架构 银行 和 货币 与 多对多协会。我为银行创建了一个包含货币的选择表单。

银行.ex

schema "banks" do
  field :name, :string
  many_to_many :currencies, App.Currency, join_through: "banks_currencies"
end

@required_fields ~w(name)
@optional_fields ~w()

def changeset(model, params \\ %{}) do
  model
  |> cast(params, @required_fields, @optional_fields)
  |> cast_assoc(:currencies)
end

表单.html.ex

<%= multiple_select(form, :currencies, @currencies) %>

问题是:当我提交选择了某些货币的表单时，变更集返回“无效”错误。我在 iex 中模拟:

iex(8)> App.Bank.changeset bank, %{"currencies" => ["1"]}  
#Ecto.Changeset<action: nil, changes: %{},
 errors: [currencies: {"is invalid", [type: {:array, :map}]}],
 data: #App.Bank<>, valid?: false>

我安装了最新的 Phoenix，最近从 1.1.4 升级到 1.2

Answer 1

我不确定这是正确的解决方案，但它有效

银行.ex

def changeset(model, params \\ %{}) do

  currencies = Currency
  |> Currency.by_ids(if params["currencies"], do: params["currencies"], else: [])
  |> App.Repo.all
  |> Enum.map(&Ecto.Changeset.change/1)

  model
  |> cast(params, @required_fields, @optional_fields)
  |> put_assoc(:currencies, currencies)
end

货币.ex

def by_ids(query, ids) do
  from c in query, where: c.id in ^ids
end