+ where: fragment("?->>'type' = ? and ?->>'context' = ?", activity.data, "Create", activity.data, ^context),
+ order_by: [desc: :id]
+ query = restrict_blocked(query, opts)
+ Repo.all(query)
+ end
+
+ def fetch_public_activities(opts \\ %{}) do
+ public = ["https://www.w3.org/ns/activitystreams#Public"]
+ fetch_activities(public, opts)
+ end
+
+ defp restrict_since(query, %{"since_id" => since_id}) do
+ from activity in query, where: activity.id > ^since_id
+ end
+ defp restrict_since(query, _), do: query
+
+ defp restrict_tag(query, %{"tag" => tag}) do
+ from activity in query,
+ where: fragment("? <@ (? #> '{\"object\",\"tag\"}')", ^tag, activity.data)
+ end
+ defp restrict_tag(query, _), do: query
+
+ defp restrict_recipients(query, recipients) do
+ Enum.reduce(recipients, query, fn (recipient, q) ->
+ map = %{ to: [recipient] }
+ from activity in q,
+ or_where: fragment(~s(? @> ?), activity.data, ^map)
+ end)
+ end
+
+ defp restrict_local(query, %{"local_only" => true}) do
+ from activity in query, where: activity.local == true
+ end
+ defp restrict_local(query, _), do: query
+
+ defp restrict_max(query, %{"max_id" => max_id}) do
+ from activity in query, where: activity.id < ^max_id
+ end
+ defp restrict_max(query, _), do: query
+
+ defp restrict_actor(query, %{"actor_id" => actor_id}) do
+ from activity in query,
+ where: fragment("?->>'actor' = ?", activity.data, ^actor_id)
+ 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' = ANY(?)", activity.data, ^type)
+ end
+ defp restrict_type(query, _), do: query
+
+ defp restrict_favorited_by(query, %{"favorited_by" => ap_id}) do
+ from activity in query,
+ where: fragment("? <@ (? #> '{\"object\",\"likes\"}')", ^ap_id, activity.data)
+ 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) || 0) - 100_000
+
+ from activity in query,
+ where: activity.id > ^since
+ end
+
+ defp restrict_blocked(query, %{"blocking_user" => %User{info: info}}) do
+ blocks = info["blocks"] || []
+ from activity in query,
+ where: fragment("not (?->>'actor' = ANY(?))", activity.data, ^blocks)
+ end
+ defp restrict_blocked(query, _), do: query
+
+ def fetch_activities(recipients, opts \\ %{}) do
+ base_query = from activity in Activity,