logo

pleroma

My custom branche(s) on git.pleroma.social/pleroma/pleroma
commit: 2ebabaeb9c4ba9e53e66a971f3c89b4bec8167bb
parent: 0f80bc2dca3f9a6a42c3a9c20a14d714138992ed
Author: kaniini <nenolod@gmail.com>
Date:   Thu, 24 Jan 2019 13:22:34 +0000

Merge branch 'fix-activity_visibility-autovacuum' into 'develop'

Fix postgres activity_visibility when running in autovacuum

See merge request pleroma/pleroma!708

Diffstat:

Apriv/repo/migrations/20190124131141_update_activity_visibility_again.exs37+++++++++++++++++++++++++++++++++++++
1 file changed, 37 insertions(+), 0 deletions(-)

diff --git a/priv/repo/migrations/20190124131141_update_activity_visibility_again.exs b/priv/repo/migrations/20190124131141_update_activity_visibility_again.exs @@ -0,0 +1,37 @@ +defmodule Pleroma.Repo.Migrations.UpdateActivityVisibilityAgain do + use Ecto.Migration + @disable_ddl_transaction true + + def up do + definition = """ + create or replace function activity_visibility(actor varchar, recipients varchar[], data jsonb) returns varchar as $$ + DECLARE + fa varchar; + public varchar := 'https://www.w3.org/ns/activitystreams#Public'; + BEGIN + SELECT COALESCE(users.follower_address, '') into fa from public.users where users.ap_id = actor; + + IF data->'to' ? public THEN + RETURN 'public'; + ELSIF data->'cc' ? public THEN + RETURN 'unlisted'; + ELSIF ARRAY[fa] && recipients THEN + RETURN 'private'; + ELSIF not(ARRAY[fa, public] && recipients) THEN + RETURN 'direct'; + ELSE + RETURN 'unknown'; + END IF; + END; + $$ LANGUAGE plpgsql IMMUTABLE PARALLEL SAFE SECURITY DEFINER; + """ + + execute(definition) + + end + + def down do + + end + +end