defmodule Mix.Tasks.Pleroma.Database do
alias Mix.Tasks.Pleroma.Common
+ require Logger
use Mix.Task
@shortdoc "A collection of database related tasks"
)
Common.start_pleroma()
+ Logger.info("Removing embedded objects")
- Ecto.Adapters.SQL.query!(
- Pleroma.Repo,
- "update activities set data = jsonb_set(data, '{object}'::text[], data->'object'->'id') where data->'object'->>'id' is not null;"
+ Pleroma.Repo.query!(
+ "update activities set data = jsonb_set(data, '{object}'::text[], data->'object'->'id') where data->'object'->>'id' is not null;",
+ [],
+ timeout: :infinity
)
if Keyword.get(options, :vacuum) do
- Ecto.Adapters.SQL.query!(
- Pleroma.Repo,
- "vacuum full;"
+ Logger.info("Runnning VACUUM FULL")
+
+ Pleroma.Repo.query!(
+ "vacuum full;",
+ [],
+ timeout: :infinity
)
end
end