1 defmodule Pleroma.Repo.Migrations.RemoveEmbededObjects do
4 # TODO: bench on a real DB and add clippy if it takes too long
7 update activities set data = jsonb_set(data, '{object}'::text[], data->'object'->'id') where data->>'type' = 'Create' and data->'object'->>'id' is not null;