问多个关键字的Ecto ILIKE？

EN

defmodule MultiOr do
  import Ecto.Query
  import Kernel, except: [or: 2]
  import Ecto.Query.API, only: [or: 2]

  # terminating call, we are done
  defp or_ilike(var, [term1, term2] = terms) do
    quote do
      ilike(unquote(var), unquote(term1)) or ilike(unquote(var), unquote(term2))
    end
  end

  # recursive call
  defp or_ilike(var, [term | terms]) do
    quote do
      ilike(unquote(var), unquote(term)) or unquote(or_ilike(var, terms))
    end
  end

  # the macro wrapper to inject AST
  defmacrop multi_ilike(var, terms) do
    Macro.expand(or_ilike(var, terms), __CALLER__)
  end

  # test
  def test do
    Ecto.Query.where(User, [u],
      multi_ilike(u.name, ["charlie", "dennis", "frank"]))
  end
end

MultiOr.test
#⇒ #Ecto.Query<from u0 in User,
#   where: ilike(u0.name, "charlie") or (ilike(u0.name, "dennis") or ilike(u0.name, "frank"))>

def multi_ilike(queryable, words) do
  for term <- words, reduce: queryable do
    acc -> 
      str = "%#{String.replace(term, "%", "\\%")}%"
      cond = dynamic([u], ilike(u.name, ^str))
      or_where(acc, ^cond)
  end
end

def multi_ilike(queryable, words) do
  words
  |> Enum.map(&"%#{String.replace(&1, "%", "\\%")}%")
  |> Enum.map(&dynamic([u], ilike(u.name, ^&1))
  |> Enum.reduce(queryable, &or_where(&2, ^&1))
end