+ defp parse_int(string, default \\ nil)
+ defp parse_int(string, default) when is_binary(string) do
+ with {n, _} <- Integer.parse(string) do
+ n
+ else
+ _e -> default
+ end
+ end
+ defp parse_int(_, default), do: default
+
+ def search(user, %{"q" => query} = params) do
+ limit = parse_int(params["rpp"], 20)
+ page = parse_int(params["page"], 1)
+ offset = (page - 1) * limit
+
+ q = from a in Activity,
+ where: fragment("?->>'type' = 'Create'", a.data),
+ where: fragment("to_tsvector('english', ?->'object'->>'content') @@ plainto_tsquery('english', ?)", a.data, ^query),
+ limit: ^limit,
+ offset: ^offset,
+ order_by: [desc: :inserted_at] # this one isn't indexed so psql won't take the wrong index.
+
+ activities = Repo.all(q)
+ activities_to_statuses(activities, %{for: user})
+ end
+