aboutsummaryrefslogtreecommitdiff
path: root/lib/mix
diff options
context:
space:
mode:
authorTusooa Zhu <tusooa@kazv.moe>2022-07-11 15:49:58 -0400
committerTusooa Zhu <tusooa@kazv.moe>2022-08-20 20:43:46 -0400
commit3885ee182a572a10b326ae553703ee0d38f3b66d (patch)
treee456867f8185b099ec8b83519df1c64d81c508a2 /lib/mix
parent06678fb4ad42fcaecb99eccc2237c3b863a2b9a5 (diff)
downloadpleroma-3885ee182a572a10b326ae553703ee0d38f3b66d.tar.gz
Switch to associated_object_id index
Diffstat (limited to 'lib/mix')
-rw-r--r--lib/mix/tasks/pleroma/database.ex3
1 files changed, 1 insertions, 2 deletions
diff --git a/lib/mix/tasks/pleroma/database.ex b/lib/mix/tasks/pleroma/database.ex
index 6b8f0ef68..ed560c177 100644
--- a/lib/mix/tasks/pleroma/database.ex
+++ b/lib/mix/tasks/pleroma/database.ex
@@ -154,9 +154,8 @@ defmodule Mix.Tasks.Pleroma.Database do
|> join(:inner, [a], o in Object,
on:
fragment(
- "(?->>'id') = COALESCE((?)->'object'->> 'id', (?)->>'object')",
+ "(?->>'id') = associated_object_id((?))",
o.data,
- a.data,
a.data
)
)