1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
5 defmodule Pleroma.ScheduledActivity do
11 alias Pleroma.ScheduledActivity
13 alias Pleroma.Web.CommonAPI.Utils
14 alias Pleroma.Workers.ScheduledActivityWorker
19 @type t :: %__MODULE__{}
21 @min_offset :timer.minutes(5)
23 schema "scheduled_activities" do
24 belongs_to(:user, User, type: FlakeId.Ecto.CompatType)
25 field(:scheduled_at, :naive_datetime)
31 def changeset(%ScheduledActivity{} = scheduled_activity, attrs) do
33 |> cast(attrs, [:scheduled_at, :params])
34 |> validate_required([:scheduled_at, :params])
35 |> validate_scheduled_at()
36 |> with_media_attachments()
39 defp with_media_attachments(
40 %{changes: %{params: %{"media_ids" => media_ids} = params}} = changeset
42 when is_list(media_ids) do
44 Utils.attachments_from_ids(
45 %{media_ids: media_ids},
46 User.get_cached_by_id(changeset.data.user_id)
51 |> Map.put("media_attachments", media_attachments)
52 |> Map.put("media_ids", media_ids)
54 put_change(changeset, :params, params)
57 defp with_media_attachments(changeset), do: changeset
59 def update_changeset(%ScheduledActivity{} = scheduled_activity, attrs) do
61 |> cast(attrs, [:scheduled_at])
62 |> validate_required([:scheduled_at])
63 |> validate_scheduled_at()
66 def validate_scheduled_at(changeset) do
67 validate_change(changeset, :scheduled_at, fn _, scheduled_at ->
69 not far_enough?(scheduled_at) ->
70 [scheduled_at: "must be at least 5 minutes from now"]
72 exceeds_daily_user_limit?(changeset.data.user_id, scheduled_at) ->
73 [scheduled_at: "daily limit exceeded"]
75 exceeds_total_user_limit?(changeset.data.user_id) ->
76 [scheduled_at: "total limit exceeded"]
84 def exceeds_daily_user_limit?(user_id, scheduled_at) do
86 |> where(user_id: ^user_id)
87 |> where([sa], type(sa.scheduled_at, :date) == type(^scheduled_at, :date))
88 |> select([sa], count(sa.id))
90 |> Kernel.>=(Config.get([ScheduledActivity, :daily_user_limit]))
93 def exceeds_total_user_limit?(user_id) do
95 |> where(user_id: ^user_id)
96 |> select([sa], count(sa.id))
98 |> Kernel.>=(Config.get([ScheduledActivity, :total_user_limit]))
101 def far_enough?(scheduled_at) when is_binary(scheduled_at) do
102 with {:ok, scheduled_at} <- Ecto.Type.cast(:naive_datetime, scheduled_at) do
103 far_enough?(scheduled_at)
109 def far_enough?(scheduled_at) do
110 now = NaiveDateTime.utc_now()
111 diff = NaiveDateTime.diff(scheduled_at, now, :millisecond)
115 def new(%User{} = user, attrs) do
116 changeset(%ScheduledActivity{user_id: user.id}, attrs)
120 Creates ScheduledActivity and add to queue to perform at scheduled_at date
122 @spec create(User.t(), map()) :: {:ok, ScheduledActivity.t()} | {:error, Ecto.Changeset.t()}
123 def create(%User{} = user, attrs) do
125 |> Multi.insert(:scheduled_activity, new(user, attrs))
126 |> maybe_add_jobs(Config.get([ScheduledActivity, :enabled]))
127 |> Repo.transaction()
128 |> transaction_response
131 defp maybe_add_jobs(multi, true) do
133 |> Multi.run(:scheduled_activity_job, fn _repo, %{scheduled_activity: activity} ->
134 %{activity_id: activity.id}
135 |> ScheduledActivityWorker.new(scheduled_at: activity.scheduled_at)
140 defp maybe_add_jobs(multi, _), do: multi
142 def get(%User{} = user, scheduled_activity_id) do
144 |> where(user_id: ^user.id)
145 |> where(id: ^scheduled_activity_id)
149 @spec update(ScheduledActivity.t(), map()) ::
150 {:ok, ScheduledActivity.t()} | {:error, Ecto.Changeset.t()}
151 def update(%ScheduledActivity{id: id} = scheduled_activity, attrs) do
152 with {:error, %Ecto.Changeset{valid?: true} = changeset} <-
153 {:error, update_changeset(scheduled_activity, attrs)} do
155 |> Multi.update(:scheduled_activity, changeset)
156 |> Multi.update_all(:scheduled_job, job_query(id),
157 set: [scheduled_at: get_field(changeset, :scheduled_at)]
159 |> Repo.transaction()
160 |> transaction_response
164 @doc "Deletes a ScheduledActivity and linked jobs."
165 @spec delete(ScheduledActivity.t() | binary() | integer) ::
166 {:ok, ScheduledActivity.t()} | {:error, Ecto.Changeset.t()}
167 def delete(%ScheduledActivity{id: id} = scheduled_activity) do
169 |> Multi.delete(:scheduled_activity, scheduled_activity, stale_error_field: :id)
170 |> Multi.delete_all(:jobs, job_query(id))
171 |> Repo.transaction()
172 |> transaction_response
175 def delete(id) when is_binary(id) or is_integer(id) do
176 delete(%__MODULE__{id: id})
179 defp transaction_response(result) do
181 {:ok, %{scheduled_activity: scheduled_activity}} ->
182 {:ok, scheduled_activity}
184 {:error, _, changeset, _} ->
189 def for_user_query(%User{} = user) do
191 |> where(user_id: ^user.id)
194 def due_activities(offset \\ 0) do
196 NaiveDateTime.utc_now()
197 |> NaiveDateTime.add(offset, :millisecond)
200 |> where([sa], sa.scheduled_at < ^naive_datetime)
204 def job_query(scheduled_activity_id) do
206 where: j.queue == "scheduled_activities",
207 where: fragment("args ->> 'activity_id' = ?::text", ^to_string(scheduled_activity_id))