X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=lib%2Fpleroma%2Factivity.ex;h=c7502981e31be64eac7e478750537dc772280ea4;hb=a6fd9c4b0083889d327b0954febd7bb233dfccb1;hp=d7e31b6b4cdfe92a42ff59abe1ee30bf7b77888d;hpb=9f417fd5e9893b095041702a6bd0190c7f1d7f22;p=akkoma diff --git a/lib/pleroma/activity.ex b/lib/pleroma/activity.ex index d7e31b6b4..c7502981e 100644 --- a/lib/pleroma/activity.ex +++ b/lib/pleroma/activity.ex @@ -4,31 +4,53 @@ defmodule Pleroma.Activity do import Ecto.Query schema "activities" do - field :data, :map - field :local, :boolean, default: true - has_many :notifications, Notification + field(:data, :map) + field(:local, :boolean, default: true) + field(:actor, :string) + field(:recipients, {:array, :string}) + has_many(:notifications, Notification, on_delete: :delete_all) timestamps() end def get_by_ap_id(ap_id) do - Repo.one(from activity in Activity, - where: fragment("(?)->>'id' = ?", activity.data, ^to_string(ap_id))) + Repo.one( + from( + activity in Activity, + where: fragment("(?)->>'id' = ?", activity.data, ^to_string(ap_id)) + ) + ) end # TODO: # Go through these and fix them everywhere. # Wrong name, only returns create activities def all_by_object_ap_id_q(ap_id) do - from activity in Activity, - where: fragment("coalesce((?)->'object'->>'id', (?)->>'object') = ?", activity.data, activity.data, ^to_string(ap_id)), + from( + activity in Activity, + where: + fragment( + "coalesce((?)->'object'->>'id', (?)->>'object') = ?", + activity.data, + activity.data, + ^to_string(ap_id) + ), where: fragment("(?)->>'type' = 'Create'", activity.data) + ) end # Wrong name, returns all. def all_non_create_by_object_ap_id_q(ap_id) do - from activity in Activity, - where: fragment("coalesce((?)->'object'->>'id', (?)->>'object') = ?", activity.data, activity.data, ^to_string(ap_id)) + from( + activity in Activity, + where: + fragment( + "coalesce((?)->'object'->>'id', (?)->>'object') = ?", + activity.data, + activity.data, + ^to_string(ap_id) + ) + ) end # Wrong name plz fix thx @@ -36,9 +58,22 @@ defmodule Pleroma.Activity do Repo.all(all_by_object_ap_id_q(ap_id)) end + def create_activity_by_object_id_query(ap_ids) do + from( + activity in Activity, + where: + fragment( + "coalesce((?)->'object'->>'id', (?)->>'object') = ANY(?)", + activity.data, + activity.data, + ^ap_ids + ), + where: fragment("(?)->>'type' = 'Create'", activity.data) + ) + end + def get_create_activity_by_object_ap_id(ap_id) do - Repo.one(from activity in Activity, - where: fragment("(?)->'object'->>'id' = ?", activity.data, ^to_string(ap_id)) - and fragment("(?)->>'type' = 'Create'", activity.data)) + create_activity_by_object_id_query([ap_id]) + |> Repo.one() end end