#mitra
I successfully completed the full migration to the proxy by running this command. (Of course, I did so at my own risk.)
UPDATE media_attachment SET media=jsonb_build_object( 'url', media->'url', 'type', 'link', 'media_type', media->'media_type' ) WHERE media->>'url' IS NOT NULL;
UPDATE emoji SET image=jsonb_build_object( 'url', image->'url', 'type', 'link', 'media_type', image->'media_type' ) WHERE image->>'url' IS NOT NULL;
Replying to @ozoramore_dev@social.t2arc.net
@ozoramore_dev Have you migrated actor images too?
Replying to @silverpill@mitra.social
@silverpill Oh, I forgot about that.
Replying to @ozoramore_dev@social.t2arc.net
@silverpillavatar and banner are done.
UPDATE actor_profile SET avatar=jsonb_build_object( 'url', avatar->'url', 'type', 'link', 'media_type', avatar->'media_type' ) WHERE avatar->>'url' IS NOT NULL;
UPDATE actor_profile SET banner=jsonb_build_object( 'url', banner->'url', 'type', 'link', 'media_type', banner->'media_type' ) WHERE banner->>'url' IS NOT NULL;
But emojis have a different structure, and I'm not great at SQL...
Replying to @ozoramore_dev@social.t2arc.net
@ozoramore_dev It's a cache, you can update it using this query: https://codeberg.org/silverpill/mitra/src/commit/8b5c382bc3c0ed9e536e66ce1f81045aef98e6d9/mitra_models/src/profiles/queries.rs#L90-L120
It updates only a single user, but I think removing WHERE actor_profile.id = $1 should be enough to update all users.
Codeberg.orgmitra/mitra_models/src/profiles/queries.rs at 8b5c382bc3c0ed9e536e66ce1f81045aef98e6d9mitra - Federated social network