App\Console\Commands\CleanAccountsTable

Complexity

Total Complexity

4

Size/Duplication

Total Lines	54
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	handle()	0	35	4

<?php

declare(strict_types=1);

namespace App\Console\Commands;

use App\Models\Account;
use Illuminate\Console\Command;

/**
 * Class CleanAccountsTable.
 */
class CleanAccountsTable extends Command
{
    /**
     * The console command name.
     *
     * @var string
     */
    protected $name = 'minepic:clean-accounts';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Clean the account table.';

    /**
     * Execute the console command.
     */
    public function handle(): int
    {
        $this->info('Selecting all duplicates...');

        $subQuery = Account::query()
            ->select('username', app('db')->raw('COUNT(id) AS total'))
            ->groupBy('username')
            ->orderBy('total', 'DESC')
            ->toSql();

        /** @var \Illuminate\Support\Collection $results */
        $results = app('db')->table(app('db')->raw(" ({$subQuery}) AS subq"))
            ->where('total', '>', 1)
            ->get();

        if ($results->count() > 0) {
            foreach ($results as $result) {
                $this->info("Removing {$result->username}...");
                $deletedRows = Account::query()
                    ->where('username', $result->username)
                    ->orderBy('updated_at', 'ASC')
                    ->take(1)
                    ->delete();
                if ($deletedRows === 1) {
                    $this->info('Deleted');
                } else {
                    $this->error('Error!');
                }
                $this->info('--------------------------------------------');
            }
        } else {
            $this->info('No duplicates found');
        }

        return 0;
    }
}