git.squeep.com Git - akkoma/blob - lib/pleroma/web/activity_pub/transmogrifier.ex

   1 defmodule Pleroma.Web.ActivityPub.Transmogrifier do
   2   @moduledoc """
   3   A module to handle coding from internal to wire ActivityPub and back.
   4   """
   5   alias Pleroma.User
   6   alias Pleroma.Object
   7   alias Pleroma.Activity
   8   alias Pleroma.Repo
   9   alias Pleroma.Web.ActivityPub.ActivityPub
  10   alias Pleroma.Web.ActivityPub.Utils
  11
  12   import Ecto.Query
  13
  14   require Logger
  15
  16   def get_actor(%{"actor" => actor}) when is_binary(actor) do
  17     actor
  18   end
  19
  20   def get_actor(%{"actor" => actor}) when is_list(actor) do
  21     if is_binary(Enum.at(actor, 0)) do
  22       Enum.at(actor, 0)
  23     else
  24       Enum.find(actor, fn %{"type" => type} -> type == "Person" end)
  25       |> Map.get("id")
  26     end
  27   end
  28
  29   def get_actor(%{"actor" => actor}) when is_map(actor) do
  30     actor["id"]
  31   end
  32
  33   @doc """
  34   Checks that an imported AP object's actor matches the domain it came from.
  35   """
  36   def contain_origin(id, %{"actor" => actor} = params) do
  37     id_uri = URI.parse(id)
  38     actor_uri = URI.parse(get_actor(params))
  39
  40     if id_uri.host == actor_uri.host do
  41       :ok
  42     else
  43       :error
  44     end
  45   end
  46
  47   @doc """
  48   Modifies an incoming AP object (mastodon format) to our internal format.
  49   """
  50   def fix_object(object) do
  51     object
  52     |> fix_actor
  53     |> fix_attachments
  54     |> fix_context
  55     |> fix_in_reply_to
  56     |> fix_emoji
  57     |> fix_tag
  58     |> fix_content_map
  59     |> fix_likes
  60     |> fix_addressing
  61   end
  62
  63   def fix_addressing_list(map, field) do
  64     if is_binary(map[field]) do
  65       map
  66       |> Map.put(field, [map[field]])
  67     else
  68       map
  69     end
  70   end
  71
  72   def fix_addressing(map) do
  73     map
  74     |> fix_addressing_list("to")
  75     |> fix_addressing_list("cc")
  76     |> fix_addressing_list("bto")
  77     |> fix_addressing_list("bcc")
  78   end
  79
  80   def fix_actor(%{"attributedTo" => actor} = object) do
  81     object
  82     |> Map.put("actor", get_actor(%{"actor" => actor}))
  83   end
  84
  85   def fix_likes(%{"likes" => likes} = object)
  86       when is_bitstring(likes) do
  87     # Check for standardisation
  88     # This is what Peertube does
  89     # curl -H 'Accept: application/activity+json' $likes | jq .totalItems
  90     object
  91     |> Map.put("likes", [])
  92     |> Map.put("like_count", 0)
  93   end
  94
  95   def fix_likes(object) do
  96     object
  97   end
  98
  99   def fix_in_reply_to(%{"inReplyTo" => in_reply_to} = object)
 100       when not is_nil(in_reply_to) do
 101     in_reply_to_id =
 102       if is_bitstring(in_reply_to) do
 103         in_reply_to
 104       else
 105         if is_map(in_reply_to) && in_reply_to["id"] do
 106           in_reply_to["id"]
 107         end
 108       end
 109
 110     case ActivityPub.fetch_object_from_id(in_reply_to_id) do
 111       {:ok, replied_object} ->
 112         with %Activity{} = activity <-
 113                Activity.get_create_activity_by_object_ap_id(replied_object.data["id"]) do
 114           object
 115           |> Map.put("inReplyTo", replied_object.data["id"])
 116           |> Map.put("inReplyToAtomUri", object["inReplyToAtomUri"] || in_reply_to_id)
 117           |> Map.put("inReplyToStatusId", activity.id)
 118           |> Map.put("conversation", replied_object.data["context"] || object["conversation"])
 119           |> Map.put("context", replied_object.data["context"] || object["conversation"])
 120         else
 121           e ->
 122             Logger.error("Couldn't fetch #{object["inReplyTo"]} #{inspect(e)}")
 123             object
 124         end
 125
 126       e ->
 127         Logger.error("Couldn't fetch #{object["inReplyTo"]} #{inspect(e)}")
 128         object
 129     end
 130   end
 131
 132   def fix_in_reply_to(object), do: object
 133
 134   def fix_context(object) do
 135     context = object["context"] || object["conversation"] || Utils.generate_context_id()
 136
 137     object
 138     |> Map.put("context", context)
 139     |> Map.put("conversation", context)
 140   end
 141
 142   def fix_attachments(%{"attachment" => attachment} = object) when is_list(attachment) do
 143     attachments =
 144       attachment
 145       |> Enum.map(fn data ->
 146         url = [%{"type" => "Link", "mediaType" => data["mediaType"], "href" => data["url"]}]
 147         Map.put(data, "url", url)
 148       end)
 149
 150     object
 151     |> Map.put("attachment", attachments)
 152   end
 153
 154   def fix_attachments(%{"attachment" => attachment} = object) when is_map(attachment) do
 155     attachment =
 156       Map.put(attachment, "url", [
 157         %{"type" => "Link", "mediaType" => attachment["mediaType"], "href" => attachment["url"]}
 158       ])
 159
 160     Map.put(object, "attachment", attachment)
 161   end
 162
 163   def fix_attachments(object) do
 164     object
 165   end
 166
 167   def fix_emoji(%{"tag" => tags} = object) when is_list(tags) do
 168     emoji = tags |> Enum.filter(fn data -> data["type"] == "Emoji" and data["icon"] end)
 169
 170     emoji =
 171       emoji
 172       |> Enum.reduce(%{}, fn data, mapping ->
 173         name = String.trim(data["name"], ":")
 174
 175         mapping |> Map.put(name, data["icon"]["url"])
 176       end)
 177
 178     # we merge mastodon and pleroma emoji into a single mapping, to allow for both wire formats
 179     emoji = Map.merge(object["emoji"] || %{}, emoji)
 180
 181     object
 182     |> Map.put("emoji", emoji)
 183   end
 184
 185   def fix_emoji(%{"tag" => %{"type" => "Emoji"} = tag} = object) do
 186     name = String.trim(tag["name"], ":")
 187     emoji = %{name => tag["icon"]["url"]}
 188
 189     object
 190     |> Map.put("emoji", emoji)
 191   end
 192
 193   def fix_emoji(object) do
 194     object
 195   end
 196
 197   def fix_tag(%{"tag" => tag} = object) when is_list(tag) do
 198     tags =
 199       tag
 200       |> Enum.filter(fn data -> data["type"] == "Hashtag" and data["name"] end)
 201       |> Enum.map(fn data -> String.slice(data["name"], 1..-1) end)
 202
 203     combined = tag ++ tags
 204
 205     object
 206     |> Map.put("tag", combined)
 207   end
 208
 209   def fix_tag(object) do
 210     object
 211   end
 212
 213   # content map usually only has one language so this will do for now.
 214   def fix_content_map(%{"contentMap" => content_map} = object) do
 215     content_groups = Map.to_list(content_map)
 216     {_, content} = Enum.at(content_groups, 0)
 217
 218     object
 219     |> Map.put("content", content)
 220   end
 221
 222   def fix_content_map(object), do: object
 223
 224   # disallow objects with bogus IDs
 225   def handle_incoming(%{"id" => nil}), do: :error
 226   def handle_incoming(%{"id" => ""}), do: :error
 227   # length of https:// = 8, should validate better, but good enough for now.
 228   def handle_incoming(%{"id" => id}) when not (is_binary(id) and length(id) > 8), do: :error
 229
 230   # TODO: validate those with a Ecto scheme
 231   # - tags
 232   # - emoji
 233   def handle_incoming(%{"type" => "Create", "object" => %{"type" => objtype} = object} = data)
 234       when objtype in ["Article", "Note", "Video"] do
 235     actor = get_actor(data)
 236
 237     data =
 238       Map.put(data, "actor", actor)
 239       |> fix_addressing
 240
 241     with nil <- Activity.get_create_activity_by_object_ap_id(object["id"]),
 242          %User{} = user <- User.get_or_fetch_by_ap_id(data["actor"]) do
 243       object = fix_object(data["object"])
 244
 245       params = %{
 246         to: data["to"],
 247         object: object,
 248         actor: user,
 249         context: object["conversation"],
 250         local: false,
 251         published: data["published"],
 252         additional:
 253           Map.take(data, [
 254             "cc",
 255             "id"
 256           ])
 257       }
 258
 259       ActivityPub.create(params)
 260     else
 261       %Activity{} = activity -> {:ok, activity}
 262       _e -> :error
 263     end
 264   end
 265
 266   def handle_incoming(
 267         %{"type" => "Follow", "object" => followed, "actor" => follower, "id" => id} = data
 268       ) do
 269     with %User{local: true} = followed <- User.get_cached_by_ap_id(followed),
 270          %User{} = follower <- User.get_or_fetch_by_ap_id(follower),
 271          {:ok, activity} <- ActivityPub.follow(follower, followed, id, false) do
 272       if not User.locked?(followed) do
 273         ActivityPub.accept(%{
 274           to: [follower.ap_id],
 275           actor: followed.ap_id,
 276           object: data,
 277           local: true
 278         })
 279
 280         User.follow(follower, followed)
 281       end
 282
 283       {:ok, activity}
 284     else
 285       _e -> :error
 286     end
 287   end
 288
 289   defp mastodon_follow_hack(%{"id" => id, "actor" => follower_id}, followed) do
 290     with true <- id =~ "follows",
 291          %User{local: true} = follower <- User.get_cached_by_ap_id(follower_id),
 292          %Activity{} = activity <- Utils.fetch_latest_follow(follower, followed) do
 293       {:ok, activity}
 294     else
 295       _ -> {:error, nil}
 296     end
 297   end
 298
 299   defp mastodon_follow_hack(_), do: {:error, nil}
 300
 301   defp get_follow_activity(follow_object, followed) do
 302     with object_id when not is_nil(object_id) <- Utils.get_ap_id(follow_object),
 303          {_, %Activity{} = activity} <- {:activity, Activity.get_by_ap_id(object_id)} do
 304       {:ok, activity}
 305     else
 306       # Can't find the activity. This might a Mastodon 2.3 "Accept"
 307       {:activity, nil} ->
 308         mastodon_follow_hack(follow_object, followed)
 309
 310       _ ->
 311         {:error, nil}
 312     end
 313   end
 314
 315   def handle_incoming(
 316         %{"type" => "Accept", "object" => follow_object, "actor" => actor, "id" => id} = data
 317       ) do
 318     with %User{} = followed <- User.get_or_fetch_by_ap_id(actor),
 319          {:ok, follow_activity} <- get_follow_activity(follow_object, followed),
 320          %User{local: true} = follower <- User.get_cached_by_ap_id(follow_activity.data["actor"]),
 321          {:ok, activity} <-
 322            ActivityPub.accept(%{
 323              to: follow_activity.data["to"],
 324              type: "Accept",
 325              actor: followed.ap_id,
 326              object: follow_activity.data["id"],
 327              local: false
 328            }) do
 329       if not User.following?(follower, followed) do
 330         {:ok, follower} = User.follow(follower, followed)
 331       end
 332
 333       {:ok, activity}
 334     else
 335       _e -> :error
 336     end
 337   end
 338
 339   def handle_incoming(
 340         %{"type" => "Reject", "object" => follow_object, "actor" => actor, "id" => id} = data
 341       ) do
 342     with %User{} = followed <- User.get_or_fetch_by_ap_id(actor),
 343          {:ok, follow_activity} <- get_follow_activity(follow_object, followed),
 344          %User{local: true} = follower <- User.get_cached_by_ap_id(follow_activity.data["actor"]),
 345          {:ok, activity} <-
 346            ActivityPub.accept(%{
 347              to: follow_activity.data["to"],
 348              type: "Accept",
 349              actor: followed.ap_id,
 350              object: follow_activity.data["id"],
 351              local: false
 352            }) do
 353       User.unfollow(follower, followed)
 354
 355       {:ok, activity}
 356     else
 357       _e -> :error
 358     end
 359   end
 360
 361   def handle_incoming(
 362         %{"type" => "Like", "object" => object_id, "actor" => actor, "id" => id} = _data
 363       ) do
 364     with %User{} = actor <- User.get_or_fetch_by_ap_id(actor),
 365          {:ok, object} <-
 366            get_obj_helper(object_id) || ActivityPub.fetch_object_from_id(object_id),
 367          {:ok, activity, _object} <- ActivityPub.like(actor, object, id, false) do
 368       {:ok, activity}
 369     else
 370       _e -> :error
 371     end
 372   end
 373
 374   def handle_incoming(
 375         %{"type" => "Announce", "object" => object_id, "actor" => actor, "id" => id} = _data
 376       ) do
 377     with %User{} = actor <- User.get_or_fetch_by_ap_id(actor),
 378          {:ok, object} <-
 379            get_obj_helper(object_id) || ActivityPub.fetch_object_from_id(object_id),
 380          {:ok, activity, _object} <- ActivityPub.announce(actor, object, id, false) do
 381       {:ok, activity}
 382     else
 383       _e -> :error
 384     end
 385   end
 386
 387   def handle_incoming(
 388         %{"type" => "Update", "object" => %{"type" => object_type} = object, "actor" => actor_id} =
 389           data
 390       )
 391       when object_type in ["Person", "Application", "Service", "Organization"] do
 392     with %User{ap_id: ^actor_id} = actor <- User.get_by_ap_id(object["id"]) do
 393       {:ok, new_user_data} = ActivityPub.user_data_from_user_object(object)
 394
 395       banner = new_user_data[:info]["banner"]
 396       locked = new_user_data[:info]["locked"] || false
 397
 398       update_data =
 399         new_user_data
 400         |> Map.take([:name, :bio, :avatar])
 401         |> Map.put(:info, Map.merge(actor.info, %{"banner" => banner, "locked" => locked}))
 402
 403       actor
 404       |> User.upgrade_changeset(update_data)
 405       |> User.update_and_set_cache()
 406
 407       ActivityPub.update(%{
 408         local: false,
 409         to: data["to"] || [],
 410         cc: data["cc"] || [],
 411         object: object,
 412         actor: actor_id
 413       })
 414     else
 415       e ->
 416         Logger.error(e)
 417         :error
 418     end
 419   end
 420
 421   # TODO: Make secure.
 422   def handle_incoming(
 423         %{"type" => "Delete", "object" => object_id, "actor" => actor, "id" => _id} = _data
 424       ) do
 425     object_id = Utils.get_ap_id(object_id)
 426
 427     with %User{} = _actor <- User.get_or_fetch_by_ap_id(actor),
 428          {:ok, object} <-
 429            get_obj_helper(object_id) || ActivityPub.fetch_object_from_id(object_id),
 430          {:ok, activity} <- ActivityPub.delete(object, false) do
 431       {:ok, activity}
 432     else
 433       _e -> :error
 434     end
 435   end
 436
 437   def handle_incoming(
 438         %{
 439           "type" => "Undo",
 440           "object" => %{"type" => "Announce", "object" => object_id},
 441           "actor" => actor,
 442           "id" => id
 443         } = _data
 444       ) do
 445     with %User{} = actor <- User.get_or_fetch_by_ap_id(actor),
 446          {:ok, object} <-
 447            get_obj_helper(object_id) || ActivityPub.fetch_object_from_id(object_id),
 448          {:ok, activity, _} <- ActivityPub.unannounce(actor, object, id, false) do
 449       {:ok, activity}
 450     else
 451       _e -> :error
 452     end
 453   end
 454
 455   def handle_incoming(
 456         %{
 457           "type" => "Undo",
 458           "object" => %{"type" => "Follow", "object" => followed},
 459           "actor" => follower,
 460           "id" => id
 461         } = _data
 462       ) do
 463     with %User{local: true} = followed <- User.get_cached_by_ap_id(followed),
 464          %User{} = follower <- User.get_or_fetch_by_ap_id(follower),
 465          {:ok, activity} <- ActivityPub.unfollow(follower, followed, id, false) do
 466       User.unfollow(follower, followed)
 467       {:ok, activity}
 468     else
 469       e -> :error
 470     end
 471   end
 472
 473   @ap_config Application.get_env(:pleroma, :activitypub)
 474   @accept_blocks Keyword.get(@ap_config, :accept_blocks)
 475
 476   def handle_incoming(
 477         %{
 478           "type" => "Undo",
 479           "object" => %{"type" => "Block", "object" => blocked},
 480           "actor" => blocker,
 481           "id" => id
 482         } = _data
 483       ) do
 484     with true <- @accept_blocks,
 485          %User{local: true} = blocked <- User.get_cached_by_ap_id(blocked),
 486          %User{} = blocker <- User.get_or_fetch_by_ap_id(blocker),
 487          {:ok, activity} <- ActivityPub.unblock(blocker, blocked, id, false) do
 488       User.unblock(blocker, blocked)
 489       {:ok, activity}
 490     else
 491       e -> :error
 492     end
 493   end
 494
 495   def handle_incoming(
 496         %{"type" => "Block", "object" => blocked, "actor" => blocker, "id" => id} = data
 497       ) do
 498     with true <- @accept_blocks,
 499          %User{local: true} = blocked = User.get_cached_by_ap_id(blocked),
 500          %User{} = blocker = User.get_or_fetch_by_ap_id(blocker),
 501          {:ok, activity} <- ActivityPub.block(blocker, blocked, id, false) do
 502       User.unfollow(blocker, blocked)
 503       User.block(blocker, blocked)
 504       {:ok, activity}
 505     else
 506       e -> :error
 507     end
 508   end
 509
 510   def handle_incoming(
 511         %{
 512           "type" => "Undo",
 513           "object" => %{"type" => "Like", "object" => object_id},
 514           "actor" => actor,
 515           "id" => id
 516         } = _data
 517       ) do
 518     with %User{} = actor <- User.get_or_fetch_by_ap_id(actor),
 519          {:ok, object} <-
 520            get_obj_helper(object_id) || ActivityPub.fetch_object_from_id(object_id),
 521          {:ok, activity, _, _} <- ActivityPub.unlike(actor, object, id, false) do
 522       {:ok, activity}
 523     else
 524       _e -> :error
 525     end
 526   end
 527
 528   def handle_incoming(_), do: :error
 529
 530   def get_obj_helper(id) do
 531     if object = Object.normalize(id), do: {:ok, object}, else: nil
 532   end
 533
 534   def set_reply_to_uri(%{"inReplyTo" => inReplyTo} = object) do
 535     with false <- String.starts_with?(inReplyTo, "http"),
 536          {:ok, %{data: replied_to_object}} <- get_obj_helper(inReplyTo) do
 537       Map.put(object, "inReplyTo", replied_to_object["external_url"] || inReplyTo)
 538     else
 539       _e -> object
 540     end
 541   end
 542
 543   def set_reply_to_uri(obj), do: obj
 544
 545   # Prepares the object of an outgoing create activity.
 546   def prepare_object(object) do
 547     object
 548     |> set_sensitive
 549     |> add_hashtags
 550     |> add_mention_tags
 551     |> add_emoji_tags
 552     |> add_attributed_to
 553     |> prepare_attachments
 554     |> set_conversation
 555     |> set_reply_to_uri
 556   end
 557
 558   #  @doc
 559   #  """
 560   #  internal -> Mastodon
 561   #  """
 562
 563   def prepare_outgoing(%{"type" => "Create", "object" => %{"type" => "Note"} = object} = data) do
 564     object =
 565       object
 566       |> prepare_object
 567
 568     data =
 569       data
 570       |> Map.put("object", object)
 571       |> Map.put("@context", "https://www.w3.org/ns/activitystreams")
 572
 573     {:ok, data}
 574   end
 575
 576   # Mastodon Accept/Reject requires a non-normalized object containing the actor URIs,
 577   # because of course it does.
 578   def prepare_outgoing(%{"type" => "Accept"} = data) do
 579     with follow_activity <- Activity.normalize(data["object"]) do
 580       object = %{
 581         "actor" => follow_activity.actor,
 582         "object" => follow_activity.data["object"],
 583         "id" => follow_activity.data["id"],
 584         "type" => "Follow"
 585       }
 586
 587       data =
 588         data
 589         |> Map.put("object", object)
 590         |> Map.put("@context", "https://www.w3.org/ns/activitystreams")
 591
 592       {:ok, data}
 593     end
 594   end
 595
 596   def prepare_outgoing(%{"type" => "Reject"} = data) do
 597     with follow_activity <- Activity.normalize(data["object"]) do
 598       object = %{
 599         "actor" => follow_activity.actor,
 600         "object" => follow_activity.data["object"],
 601         "id" => follow_activity.data["id"],
 602         "type" => "Follow"
 603       }
 604
 605       data =
 606         data
 607         |> Map.put("object", object)
 608         |> Map.put("@context", "https://www.w3.org/ns/activitystreams")
 609
 610       {:ok, data}
 611     end
 612   end
 613
 614   def prepare_outgoing(%{"type" => _type} = data) do
 615     data =
 616       data
 617       |> maybe_fix_object_url
 618       |> Map.put("@context", "https://www.w3.org/ns/activitystreams")
 619
 620     {:ok, data}
 621   end
 622
 623   def maybe_fix_object_url(data) do
 624     if is_binary(data["object"]) and not String.starts_with?(data["object"], "http") do
 625       case ActivityPub.fetch_object_from_id(data["object"]) do
 626         {:ok, relative_object} ->
 627           if relative_object.data["external_url"] do
 628             _data =
 629               data
 630               |> Map.put("object", relative_object.data["external_url"])
 631           else
 632             data
 633           end
 634
 635         e ->
 636           Logger.error("Couldn't fetch #{data["object"]} #{inspect(e)}")
 637           data
 638       end
 639     else
 640       data
 641     end
 642   end
 643
 644   def add_hashtags(object) do
 645     tags =
 646       (object["tag"] || [])
 647       |> Enum.map(fn tag ->
 648         %{
 649           "href" => Pleroma.Web.Endpoint.url() <> "/tags/#{tag}",
 650           "name" => "##{tag}",
 651           "type" => "Hashtag"
 652         }
 653       end)
 654
 655     object
 656     |> Map.put("tag", tags)
 657   end
 658
 659   def add_mention_tags(object) do
 660     recipients = object["to"] ++ (object["cc"] || [])
 661
 662     mentions =
 663       recipients
 664       |> Enum.map(fn ap_id -> User.get_cached_by_ap_id(ap_id) end)
 665       |> Enum.filter(& &1)
 666       |> Enum.map(fn user ->
 667         %{"type" => "Mention", "href" => user.ap_id, "name" => "@#{user.nickname}"}
 668       end)
 669
 670     tags = object["tag"] || []
 671
 672     object
 673     |> Map.put("tag", tags ++ mentions)
 674   end
 675
 676   # TODO: we should probably send mtime instead of unix epoch time for updated
 677   def add_emoji_tags(object) do
 678     tags = object["tag"] || []
 679     emoji = object["emoji"] || []
 680
 681     out =
 682       emoji
 683       |> Enum.map(fn {name, url} ->
 684         %{
 685           "icon" => %{"url" => url, "type" => "Image"},
 686           "name" => ":" <> name <> ":",
 687           "type" => "Emoji",
 688           "updated" => "1970-01-01T00:00:00Z",
 689           "id" => url
 690         }
 691       end)
 692
 693     object
 694     |> Map.put("tag", tags ++ out)
 695   end
 696
 697   def set_conversation(object) do
 698     Map.put(object, "conversation", object["context"])
 699   end
 700
 701   def set_sensitive(object) do
 702     tags = object["tag"] || []
 703     Map.put(object, "sensitive", "nsfw" in tags)
 704   end
 705
 706   def add_attributed_to(object) do
 707     attributedTo = object["attributedTo"] || object["actor"]
 708
 709     object
 710     |> Map.put("attributedTo", attributedTo)
 711   end
 712
 713   def prepare_attachments(object) do
 714     attachments =
 715       (object["attachment"] || [])
 716       |> Enum.map(fn data ->
 717         [%{"mediaType" => media_type, "href" => href} | _] = data["url"]
 718         %{"url" => href, "mediaType" => media_type, "name" => data["name"], "type" => "Document"}
 719       end)
 720
 721     object
 722     |> Map.put("attachment", attachments)
 723   end
 724
 725   defp user_upgrade_task(user) do
 726     old_follower_address = User.ap_followers(user)
 727
 728     q =
 729       from(
 730         u in User,
 731         where: ^old_follower_address in u.following,
 732         update: [
 733           set: [
 734             following:
 735               fragment(
 736                 "array_replace(?,?,?)",
 737                 u.following,
 738                 ^old_follower_address,
 739                 ^user.follower_address
 740               )
 741           ]
 742         ]
 743       )
 744
 745     Repo.update_all(q, [])
 746
 747     maybe_retire_websub(user.ap_id)
 748
 749     # Only do this for recent activties, don't go through the whole db.
 750     # Only look at the last 1000 activities.
 751     since = (Repo.aggregate(Activity, :max, :id) || 0) - 1_000
 752
 753     q =
 754       from(
 755         a in Activity,
 756         where: ^old_follower_address in a.recipients,
 757         where: a.id > ^since,
 758         update: [
 759           set: [
 760             recipients:
 761               fragment(
 762                 "array_replace(?,?,?)",
 763                 a.recipients,
 764                 ^old_follower_address,
 765                 ^user.follower_address
 766               )
 767           ]
 768         ]
 769       )
 770
 771     Repo.update_all(q, [])
 772   end
 773
 774   def upgrade_user_from_ap_id(ap_id, async \\ true) do
 775     with %User{local: false} = user <- User.get_by_ap_id(ap_id),
 776          {:ok, data} <- ActivityPub.fetch_and_prepare_user_from_ap_id(ap_id) do
 777       data =
 778         data
 779         |> Map.put(:info, Map.merge(user.info, data[:info]))
 780
 781       already_ap = User.ap_enabled?(user)
 782
 783       {:ok, user} =
 784         User.upgrade_changeset(user, data)
 785         |> Repo.update()
 786
 787       if !already_ap do
 788         # This could potentially take a long time, do it in the background
 789         if async do
 790           Task.start(fn ->
 791             user_upgrade_task(user)
 792           end)
 793         else
 794           user_upgrade_task(user)
 795         end
 796       end
 797
 798       {:ok, user}
 799     else
 800       e -> e
 801     end
 802   end
 803
 804   def maybe_retire_websub(ap_id) do
 805     # some sanity checks
 806     if is_binary(ap_id) && String.length(ap_id) > 8 do
 807       q =
 808         from(
 809           ws in Pleroma.Web.Websub.WebsubClientSubscription,
 810           where: fragment("? like ?", ws.topic, ^"#{ap_id}%")
 811         )
 812
 813       Repo.delete_all(q)
 814     end
 815   end
 816
 817   def maybe_fix_user_url(data) do
 818     if is_map(data["url"]) do
 819       Map.put(data, "url", data["url"]["href"])
 820     else
 821       data
 822     end
 823   end
 824
 825   def maybe_fix_user_object(data) do
 826     data
 827     |> maybe_fix_user_url
 828   end
 829 end