App\Console\Commands\CleanAccountsTable::handle()

Complexity

Conditions	4
Paths	2

Size

Total Lines	35
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    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;
    }