git.squeep.com Git - akkoma/blob - priv/repo/migrations/20190711042021_create_safe_jsonb_set.exs

   1 defmodule Pleroma.Repo.Migrations.CreateSafeJsonbSet do
   2   use Ecto.Migration
   3
   4   def change do
   5     execute("""
   6     create or replace function safe_jsonb_set(target jsonb, path text[], new_value jsonb, create_missing boolean default true) returns jsonb as $$
   7     declare
   8       result jsonb;
   9     begin
  10       result := jsonb_set(target, path, coalesce(new_value, 'null'::jsonb), create_missing);
  11       if result is NULL then
  12         raise 'jsonb_set tried to wipe the object, please report this incindent to Pleroma bug tracker. https://git.pleroma.social/pleroma/pleroma/issues/new';
  13         return target;
  14       else
  15         return result;
  16       end if;
  17     end;
  18     $$ language plpgsql;
  19     """)
  20   end
  21 end