git.squeep.com Git - akkoma/blob - lib/mix/tasks/pleroma/database.ex

   1 # Pleroma: A lightweight social networking server
   2 # Copyright © 2017-2018 Pleroma Authors <https://pleroma.social/>
   3 # SPDX-License-Identifier: AGPL-3.0-only
   4
   5 defmodule Mix.Tasks.Pleroma.Database do
   6   alias Mix.Tasks.Pleroma.Common
   7   use Mix.Task
   8
   9   @shortdoc "A collection of database related tasks"
  10   @moduledoc """
  11    A collection of database related tasks
  12
  13    ## Replace embedded objects with their references
  14
  15    Replaces embedded objects with references to them in the `objects` table. Only needs to be ran once. The reason why this is not a migration is because it could significantly increase the database size after being ran, however after this `VACUUM FULL` will be able to reclaim about 20% (really depends on what is in the database, your mileage may vary) of the db size before the migration.
  16
  17        mix pleroma.database remove_embedded_objects
  18
  19     Options:
  20     - `--vacuum` - run `VACUUM FULL` after the embedded objects are replaced with their references
  21   """
  22   def run(["remove_embedded_objects" | args]) do
  23     {options, [], []} =
  24       OptionParser.parse(
  25         args,
  26         strict: [
  27           vacuum: :boolean
  28         ]
  29       )
  30
  31     Common.start_pleroma()
  32
  33     Ecto.Adapters.SQL.query!(
  34       Pleroma.Repo,
  35       "update activities set data = jsonb_set(data, '{object}'::text[], data->'object'->'id') where data->'object'->>'id' is not null;"
  36     )
  37
  38     if Keyword.get(options, :vacuum) do
  39       Ecto.Adapters.SQL.query!(
  40         Pleroma.Repo,
  41         "vacuum full;"
  42       )
  43     end
  44   end
  45 end