You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
pixelfed/database/migrations/2023_01_19_141156_fix_bookm...

55 lines
1.3 KiB
PHP

<?php
use App\Models\Bookmark;
use App\Models\Status;
use App\Services\FollowerService;
use Illuminate\Database\Migrations\Migration;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Bookmark::chunk(200, function ($bookmarks) {
foreach ($bookmarks as $bookmark) {
$status = Status::find($bookmark->status_id);
if (! $status) {
$bookmark->delete();
continue;
}
if (! in_array($status->visibility, ['public', 'unlisted', 'private'])) {
$bookmark->delete();
continue;
}
if (! in_array($status->visibility, ['public', 'unlisted'])) {
if ($bookmark->profile_id == $status->profile_id) {
continue;
} else {
if (! FollowerService::follows($bookmark->profile_id, $status->profile_id)) {
$bookmark->delete();
}
}
}
}
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
//
}
};