From 26b0c802c3eece72928d0425826af9fe728a5173 Mon Sep 17 00:00:00 2001 From: William Pitcock Date: Mon, 25 Mar 2019 03:32:19 +0000 Subject: fix up missing announcements with preloads --- lib/pleroma/activity.ex | 16 ++++++++++------ 1 file changed, 10 insertions(+), 6 deletions(-) (limited to 'lib') diff --git a/lib/pleroma/activity.ex b/lib/pleroma/activity.ex index 26190df2f..3dfabe9f3 100644 --- a/lib/pleroma/activity.ex +++ b/lib/pleroma/activity.ex @@ -41,8 +41,8 @@ defmodule Pleroma.Activity do # # ``` # |> join(:inner, [activity], o in Object, - # on: fragment("(?->>'id') = COALESCE((? -> 'object'::text) ->> 'id'::text)", - # o.data, activity.data)) + # on: fragment("(?->>'id') = COALESCE((?)->'object'->> 'id', (?)->>'object')", + # o.data, activity.data, activity.data)) # |> preload([activity, object], [object: object]) # ``` # @@ -61,8 +61,9 @@ defmodule Pleroma.Activity do o in Object, on: fragment( - "(?->>'id') = COALESCE((? -> 'object'::text) ->> 'id'::text)", + "(?->>'id') = COALESCE(?->'object'->>'id', ?->>'object')", o.data, + activity.data, activity.data ) ) @@ -86,8 +87,9 @@ defmodule Pleroma.Activity do left_join: o in Object, on: fragment( - "(?->>'id') = COALESCE((? -> 'object'::text) ->> 'id'::text)", + "(?->>'id') = COALESCE(?->'object'->>'id', ?->>'object')", o.data, + activity.data, activity.data ), preload: [object: o] @@ -105,8 +107,9 @@ defmodule Pleroma.Activity do inner_join: o in Object, on: fragment( - "(?->>'id') = COALESCE((? -> 'object'::text) ->> 'id'::text)", + "(?->>'id') = COALESCE(?->'object'->>'id', ?->>'object')", o.data, + activity.data, activity.data ), preload: [object: o] @@ -182,8 +185,9 @@ defmodule Pleroma.Activity do inner_join: o in Object, on: fragment( - "(?->>'id') = COALESCE((? -> 'object'::text) ->> 'id'::text)", + "(?->>'id') = COALESCE(?->'object'->>'id', ?->>'object')", o.data, + activity.data, activity.data ), preload: [object: o] -- cgit v1.2.3