MRF.SimplePolicy.media_nsfwへの対処記録

objects.dataのsensitiveキーの値を有効化

確認

code:sql

select o.*

from public.objects AS o

WHERE

and o.data->>'attachment' != '[]'

AND o.data @> '{"sensitive": false}'

limit 10;

何件？

code:sql

select count(*)

from public.objects AS o

WHERE

and o.data->>'attachment' != '[]'

AND o.data @> '{"sensitive": false}'

;

実行

code:sql

UPDATE public.objects AS o

SET data = data || '{"sensitive": true}'::jsonb

WHERE

and o.data->>'attachment' != '[]'

AND o.data @> '{"sensitive": false}'

;

10件ずつ試してみる

code:sql

UPDATE public.objects

SET data = data || '{"sensitive": true}'::jsonb

where objects.id in (

select o.id

from public.objects AS o

WHERE

o.data->>'actor' LIKE '%misskey.io%'

and o.data->>'attachment' != '[]'

AND o.data @> '{"sensitive": false}'

limit 10

);