diff options
| author | feld <feld@feld.me> | 2021-06-07 20:11:45 +0000 |
|---|---|---|
| committer | feld <feld@feld.me> | 2021-06-07 20:11:45 +0000 |
| commit | b553bfd745e76117efafd81c8306abd29e28e4a0 (patch) | |
| tree | 49a0266aa03707104d370faafd694671306e6b48 /lib | |
| parent | 676c3c96dce8a620c86bca03cc4997b0593d54fb (diff) | |
| parent | 9a357d63f0d8381492a0ffe0e507f233fc35fbf8 (diff) | |
| download | pleroma-b553bfd745e76117efafd81c8306abd29e28e4a0.tar.gz | |
Merge branch 'fix/prune-hashtags' into 'develop'
get prune_objects to work again
See merge request pleroma/pleroma!3397
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/mix/tasks/pleroma/database.ex | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/lib/mix/tasks/pleroma/database.ex b/lib/mix/tasks/pleroma/database.ex index e7f4b67a4..57f73d12b 100644 --- a/lib/mix/tasks/pleroma/database.ex +++ b/lib/mix/tasks/pleroma/database.ex @@ -96,6 +96,15 @@ defmodule Mix.Tasks.Pleroma.Database do ) |> Repo.delete_all(timeout: :infinity) + prune_hashtags_query = """ + DELETE FROM hashtags AS ht + WHERE NOT EXISTS ( + SELECT 1 FROM hashtags_objects hto + WHERE ht.id = hto.hashtag_id) + """ + + Repo.query(prune_hashtags_query) + if Keyword.get(options, :vacuum) do Maintenance.vacuum("full") end |