Untitled attachment

Notices where this attachment appears

1.  (mint@ryona.agency)'s status on Tuesday, 13-Feb-2024 07:20:49 JST 

   in reply to
   @icedquinn @Lumeinshin @gingermilk @histoire Wasn't that hard.
   1. select data->>'attachment' from objects where data->>'actor' like 'https://lab.nyanide.com/users/%' order by id asc;2. extract urls however you want and download them all with wget or whatever
   3. put the images on server
   4. update objects set data = REPLACE(data::TEXT, 'https://meds.lab.nyanide.com/media/', 'https://zetsubou.ryona.agency/media/nyanide/')::jsonb where data->>'actor' like 'https://lab.nyanide.com/users/%'; (this takes shitton of time, one should probably limit the id as well to avoid overwriting paths for images that would be uploaded inbetween)