1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
5 defmodule Pleroma.Repo.Migrations.UsersPopulateEmoji do
14 execute("ALTER TABLE users ALTER COLUMN emoji SET DEFAULT '{}'::jsonb")
15 execute("UPDATE users SET emoji = DEFAULT WHERE emoji = '[]'::jsonb")
18 |> select([u], struct(u, [:id, :ap_id, :source_data]))
20 |> Enum.each(fn user ->
25 %{"type" => "Emoji"} -> true
28 |> Enum.reduce(%{}, fn %{"icon" => %{"url" => url}, "name" => name}, acc ->
29 Map.put(acc, String.trim(name, ":"), url)
33 |> Ecto.Changeset.cast(%{emoji: emoji}, [:emoji])
39 execute("ALTER TABLE users ALTER COLUMN emoji SET DEFAULT '[]'::jsonb")
40 execute("UPDATE users SET emoji = DEFAULT WHERE emoji = '{}'::jsonb")