commit bbc38f353e14b3bbc7d7030cabefac094229a676
parent 72af8b1b5385a95ca6d26599e0ee35a194679af9
Author: srfsh <dev@srf.sh>
Date: Fri, 23 Sep 2022 16:57:32 +0300
Zenflows.VF.Person.{Domain,Filter}: add filtering
Diffstat:
3 files changed, 105 insertions(+), 4 deletions(-)
diff --git a/src/zenflows/vf/person/domain.ex b/src/zenflows/vf/person/domain.ex
@@ -22,7 +22,7 @@ import Ecto.Query
alias Ecto.Multi
alias Zenflows.DB.{Paging, Repo}
-alias Zenflows.VF.Person
+alias Zenflows.VF.{Person, Person.Filter}
@typep repo() :: Ecto.Repo.t()
@typep chgset() :: Ecto.Changeset.t()
@@ -42,9 +42,11 @@ def one(repo, clauses) do
end
end
-@spec all(Paging.params()) :: Paging.result()
-def all(params) do
- Paging.page(where(Person, type: :per), params)
+@spec all(Paging.params()) :: Filter.error() | Paging.result()
+def all(params \\ %{}) do
+ with {:ok, q} <- Filter.filter(params[:filter] || %{}) do
+ Paging.page(q, params)
+ end
end
@spec exists?(Keyword.t()) :: boolean()
diff --git a/src/zenflows/vf/person/filter.ex b/src/zenflows/vf/person/filter.ex
@@ -0,0 +1,92 @@
+# Zenflows is designed to implement the Valueflows vocabulary,
+# written and maintained by srfsh <info@dyne.org>.
+# Copyright (C) 2021-2022 Dyne.org foundation <foundation@dyne.org>.
+#
+# This program is free software: you can redistribute it and/or modify
+# it under the terms of the GNU Affero General Public License as published by
+# the Free Software Foundation, either version 3 of the License, or
+# (at your option) any later version.
+#
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU Affero General Public License for more details.
+#
+# You should have received a copy of the GNU Affero General Public License
+# along with this program. If not, see <https://www.gnu.org/licenses/>.
+
+defmodule Zenflows.VF.Person.Filter do
+@moduledoc "Filtering logic of Persons."
+
+use Zenflows.DB.Schema
+
+import Ecto.Query
+
+alias Ecto.Query
+alias Zenflows.DB.Filter
+alias Zenflows.VF.{Person, Validate}
+
+@type error() :: Filter.error()
+
+@spec filter(Filter.params()) :: Filter.result()
+def filter(params) do
+ case chgset(params) do
+ %{valid?: true, changes: c} ->
+ {:ok, Enum.reduce(c, where(Person, type: :per), &f(&2, &1))}
+ %{valid?: false} = cset ->
+ {:error, cset}
+ end
+end
+
+@spec f(Query.t(), {atom(), term()}) :: Query.t()
+defp f(q, {:name, v}),
+ do: where(q, [x], ilike(x.name, ^"%#{Filter.escape_like(v)}%"))
+defp f(q, {:user, v}),
+ do: where(q, [x], ilike(x.user, ^"%#{Filter.escape_like(v)}%"))
+defp f(q, {:user_or_name, v}) do
+ v = "%#{Filter.escape_like(v)}%"
+ where(q, [x], ilike(x.user, ^v) or ilike(x.name, ^v))
+end
+
+embedded_schema do
+ field :name, :string
+ field :user, :string
+ field :user_or_name, :string
+end
+
+@spec chgset(params()) :: Changeset.t()
+defp chgset(params) do
+ %__MODULE__{}
+ |> Changeset.cast(params, ~w[name user user_or_name]a)
+ |> Validate.name(:name)
+ |> Validate.name(:user)
+ |> Validate.name(:user_or_name)
+ |> user_or_name_mutex()
+end
+
+# Validate that `user_or_name` is mutually exclusive with either `user`
+# or `name`.
+@spec user_or_name_mutex(Changeset.t()) :: Changeset.t()
+defp user_or_name_mutex(cset) do
+ name = Changeset.get_change(cset, :name)
+ user = Changeset.get_change(cset, :user)
+ user_or_name = Changeset.get_change(cset, :user_or_name)
+
+ cond do
+ user_or_name && user ->
+ msg = "user-or-name and user can't be used together"
+ cset
+ |> Changeset.add_error(:user_or_name, msg)
+ |> Changeset.add_error(:user, msg)
+
+ user_or_name && name ->
+ msg = "user-or-name and name can't be used together"
+ cset
+ |> Changeset.add_error(:user_or_name, msg)
+ |> Changeset.add_error(:name, msg)
+
+ true ->
+ cset
+ end
+end
+end
diff --git a/src/zenflows/vf/person/type.ex b/src/zenflows/vf/person/type.ex
@@ -148,6 +148,12 @@ object :person_connection do
field :edges, non_null(list_of(non_null(:person_edge)))
end
+input_object :person_filter_params do
+ field :name, :string
+ field :user, :string
+ field :user_or_name, :string
+end
+
object :query_person do
@desc "Find a person by their ID."
field :person, :person do
@@ -164,6 +170,7 @@ object :query_person do
arg :after, :id
arg :last, :integer
arg :before, :id
+ arg :filter, :person_filter_params
resolve &Resolv.people/2
end