pixelfed/database/migrations/2022_09_01_000000_fix_webfinger_profile_duplicate_accounts.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use App\Profile;
use App\Jobs\DeletePipeline\DeleteRemoteProfilePipeline;

class FixWebfingerProfileDuplicateAccounts extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        if(Profile::count() === 0) {
            return;
        }

        Profile::whereNotNull('domain')
            ->where('username', 'not like', '@%')
            ->chunk(200, function($profiles) {
                foreach($profiles as $profile) {
                    $exists = Profile::whereUsername("@{$profile->username}@{$profile->domain}")->first();
                    if($exists) {
                        $exists->username = null;
                        $exists->domain = null;
                        $exists->webfinger = null;
                        $exists->save();
                        DeleteRemoteProfilePipeline::dispatch($exists);

                        $profile->username = "@{$profile->username}@{$profile->domain}";
                        if(!$profile->webfinger) {
                            $profile->webfinger = "@{$profile->username}@{$profile->domain}";
                        }
                        $profile->save();
                    } else {
                        $profile->username = "@{$profile->username}@{$profile->domain}";
                        if(!$profile->webfinger) {
                            $profile->webfinger = "@{$profile->username}@{$profile->domain}";
                        }
                        $profile->save();
                    }
                }
            });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}