}
with Repo.delete(object),
Repo.delete_all(Activity.all_non_create_by_object_ap_id_q(id)),
- Repo.delete_all(Activity.all_by_object_ap_id_q(id)),
{:ok, activity} <- insert(data, local),
:ok <- maybe_federate(activity) do
{:ok, activity}
end
defp restrict_actor(query, _), do: query
+ defp restrict_type(query, %{"type" => type}) when is_binary(type) do
+ restrict_type(query, %{"type" => [type]})
+ end
defp restrict_type(query, %{"type" => type}) do
from activity in query,
- where: fragment("?->>'type' = ?", activity.data, ^type)
+ where: fragment("?->>'type' = ANY(?)", activity.data, ^type)
end
defp restrict_type(query, _), do: query
end
defp restrict_favorited_by(query, _), do: query
+ # Only search through last 100_000 activities by default
+ defp restrict_recent(query, _) do
+ since = Repo.aggregate(Activity, :max, :id) - 100_000
+
+ from activity in query,
+ where: activity.id > ^since
+ end
+
def fetch_activities(recipients, opts \\ %{}) do
base_query = from activity in Activity,
limit: 20,
|> restrict_actor(opts)
|> restrict_type(opts)
|> restrict_favorited_by(opts)
+ |> restrict_recent(opts)
|> Repo.all
|> Enum.reverse
end