the cursed sql to convert all heart reactions to star reactions in misskey

star.sql

BEGIN;

UPDATE note_reaction
SET reaction='⭐'
WHERE reaction='❤';

UPDATE note
SET reactions = jsonb_set(reactions, '{⭐}', ((reactions->>'❤')::int + coalesce((reactions->>'⭐')::int, 0))::text::jsonb)
WHERE (reactions->>'❤')::int >= 0;

UPDATE note
SET reactions = reactions - '❤'
WHERE (reactions->>'❤')::int >= 0;

update note
set "reactionAndUserPairCache" = array(select replace(unnest("reactionAndUserPairCache"), '❤', '⭐'))
where "reactionAndUserPairCache" != '{}';