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.AddAssociatedObjectIdFunction do
10 CREATE OR REPLACE FUNCTION associated_object_id(data jsonb) RETURNS varchar AS $$
14 IF jsonb_typeof(data->'object') = 'array' THEN
15 object_data := data->'object'->0;
17 object_data := data->'object';
20 IF jsonb_typeof(object_data->'id') = 'string' THEN
21 RETURN object_data->>'id';
22 ELSIF jsonb_typeof(object_data) = 'string' THEN
23 RETURN object_data#>>'{}';
28 $$ LANGUAGE plpgsql IMMUTABLE;
35 execute("DROP FUNCTION IF EXISTS associated_object_id(data jsonb)")