1 defmodule Pleroma.Activity do
3 alias Pleroma.{Repo, Activity}
8 field :local, :boolean, default: true
13 def get_by_ap_id(ap_id) do
14 Repo.one(from activity in Activity,
15 where: fragment("(?)->>'id' = ?", activity.data, ^to_string(ap_id)))
18 def all_by_object_ap_id_q(ap_id) do
19 from activity in Activity,
20 where: fragment("(?)->'object'->>'id' = ?", activity.data, ^to_string(ap_id))
23 def all_by_object_ap_id(ap_id) do
24 Repo.all(all_by_object_ap_id_q(ap_id))
27 def get_create_activity_by_object_ap_id(ap_id) do
28 Repo.one(from activity in Activity,
29 where: fragment("(?)->'object'->>'id' = ?", activity.data, ^to_string(ap_id))
30 and fragment("(?)->>'type' = 'Create'", activity.data))