1 defmodule Pleroma.Repo.Migrations.AddRecipientsContainBlockedDomainsFunction do
3 @disable_ddl_transaction true
7 CREATE OR REPLACE FUNCTION recipients_contain_blocked_domains(recipients varchar[], blocked_domains varchar[]) RETURNS boolean AS $$
9 recipient_domain varchar;
12 FOREACH recipient IN ARRAY recipients LOOP
13 recipient_domain = split_part(recipient, '/', 3)::varchar;
15 IF recipient_domain = ANY(blocked_domains) THEN
30 "drop function if exists recipients_contain_blocked_domains(recipients varchar[], blocked_domains varchar[])"