This works without errors and it gets simple when i wnat to add other defp and pipe them together in a composition
def list_items(%{matching: name}) when is_binary(name) do
Item
# |> where([m], ilike(m.name, ^"%#{name}%"))
|> search(name)
|> Repo.all()
end
defp search(_query, name) do
query = from(query in Item)
query
|> where([t], ilike(t.name, ^"%#{name}%"))
end
you are trying to search name or query? , we can still pass it as params and do another where,
ecto supports array in query for and operations
filters = [ name: params[:name], age: params[:age] ]
qfilters = reject_empty_values(filters)
from m in model, where: qfilters
No, I am rewriting this to suit my style and understand more how Ecto works with phoenix and absinthe. Also to make it more compos-able using the composition pattern.
def list_items(%{matching: name}) when is_binary(name) do
Item
|> where([m], ilike(m.name, ^"%#{name}%"))
|> Repo.all()
end
ahh, i get it. cool.
you are planning to |> search_by_name, search_by_age
def search(%{name: name, age: age} = params}) do
model
|> sname(name)
|> sage(age)
|> Repo.all
end
defp sname(query, name), do: from q in query, where: q.name == name
defp sage(query, age), do: from q in query, where: q.age == age
Hope it works,
Thanks everyone for the help. This my final version
def list_items(%{matching: name}) when is_binary(name) do
Item
# |> where([m], ilike(m.name, ^"%#{name}%"))
|> search(name)
|> Repo.all()
end
defp search(_query, name) do
query = from(query in Item)
query
|> where([t], ilike(t.name, ^"%#{name}%"))
end