X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20190711042021_create_safe_jsonb_set.exs;h=2f336a5e84659b98d04dea60ce43b62cbb2ada28;hb=fc2eb1fbd6a5b38a3cf72e557cce1029d6b7f16f;hp=d70961431cf0cb995eae470915768cdb40d7aba4;hpb=deee9f31968c48fb15b4d6b93254d28232e54a69;p=akkoma diff --git a/priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs b/priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs index d70961431..2f336a5e8 100644 --- a/priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs +++ b/priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs @@ -3,20 +3,20 @@ defmodule Pleroma.Repo.Migrations.CreateSafeJsonbSet do alias Pleroma.User def change do - execute(""" - create or replace function safe_jsonb_set(target jsonb, path text[], new_value jsonb, create_missing boolean default true) returns jsonb as $$ - declare - result jsonb; - begin - result := jsonb_set(target, path, coalesce(new_value, 'null'::jsonb), create_missing); - if result is NULL then - raise 'jsonb_set tried to wipe the object, please report this incindent to Pleroma bug tracker. https://git.pleroma.social/pleroma/pleroma/issues/new'; - return target; - else - return result; - end if; - end; - $$ language plpgsql; - """) + execute(""" + create or replace function safe_jsonb_set(target jsonb, path text[], new_value jsonb, create_missing boolean default true) returns jsonb as $$ + declare + result jsonb; + begin + result := jsonb_set(target, path, coalesce(new_value, 'null'::jsonb), create_missing); + if result is NULL then + raise 'jsonb_set tried to wipe the object, please report this incindent to Pleroma bug tracker. https://git.pleroma.social/pleroma/pleroma/issues/new'; + return target; + else + return result; + end if; + end; + $$ language plpgsql; + """) end end