summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorfeld <feld@feld.me>2021-06-07 20:02:28 +0000
committerfeld <feld@feld.me>2021-06-07 20:02:28 +0000
commitbc51dea4257d4faaff70f8511dcd3702489ebb74 (patch)
tree572c4e92a1cb7e48d2134d2ff106009f3fff8f5e
parent5be9d139816fa40ff6227950b58f3c6cea01fc81 (diff)
Update lib/mix/tasks/pleroma/database.ex
-rw-r--r--lib/mix/tasks/pleroma/database.ex8
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/mix/tasks/pleroma/database.ex b/lib/mix/tasks/pleroma/database.ex
index bcde07774..57f73d12b 100644
--- a/lib/mix/tasks/pleroma/database.ex
+++ b/lib/mix/tasks/pleroma/database.ex
@@ -97,10 +97,10 @@ 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)
+ 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)