akkoma/priv/repo/migrations/20200825061316_move_activity_expirations_to_oban.exs

31 lines
847 B
Elixir
Raw Permalink Normal View History

2020-08-25 09:30:00 +00:00
defmodule Pleroma.Repo.Migrations.MoveActivityExpirationsToOban do
use Ecto.Migration
import Ecto.Query, only: [from: 2]
def change do
2020-09-13 07:04:50 +00:00
Pleroma.Config.Oban.warn()
Application.ensure_all_started(:oban)
2020-08-25 09:30:00 +00:00
Supervisor.start_link([{Oban, Pleroma.Config.get(Oban)}],
strategy: :one_for_one,
name: Pleroma.Supervisor
)
from(e in "activity_expirations",
select: %{id: e.id, activity_id: e.activity_id, scheduled_at: e.scheduled_at}
)
|> Pleroma.Repo.stream()
2020-09-04 09:05:17 +00:00
|> Stream.each(fn expiration ->
with {:ok, expires_at} <- DateTime.from_naive(expiration.scheduled_at, "Etc/UTC") do
Pleroma.Workers.PurgeExpiredActivity.enqueue(%{
activity_id: FlakeId.to_string(expiration.activity_id),
expires_at: expires_at
})
end
2020-08-25 09:30:00 +00:00
end)
|> Stream.run()
end
end