Cog\Laravel\Love\Console\Commands\UpgradeV5ToV8

Complexity

Total Complexity

42

Size/Duplication

Total Lines	354
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

18 Methods

Rating	Name	Duplication	Size	Complexity
A	collectLikeTypes()	0	13	1
B	populateReacters()	0	40	7
A	filesystemCleanup()	0	6	1
A	dbChangeReactions()	0	11	1
A	handle()	0	19	1
B	populateReactants()	0	45	8
A	populateReactionTypes()	0	24	4
B	populateReactions()	0	68	6
A	dbCleanup()	0	15	1
A	collectLikeableTypes()	0	12	1
A	dbMigrate()	0	3	1
A	deleteMigrationFiles()	0	6	3
A	reactionTypeNameFromLikeTypeName()	0	3	1
A	getDbQuery()	0	3	1
A	assertRequirements()	0	9	2
A	getUserClass()	0	7	1
A	collectLikerTypes()	0	4	1
A	getDatabaseConnection()	0	3	1

<?php

/*
 * This file is part of Laravel Love.
 *
 * (c) Anton Komarev <anton@komarev.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

declare(strict_types=1);

namespace Cog\Laravel\Love\Console\Commands;

use Cog\Contracts\Love\Reactable\Models\Reactable as ReactableContract;
use Cog\Contracts\Love\Reacterable\Models\Reacterable as ReacterableContract;
use Cog\Laravel\Love\Reaction\Models\Reaction;
use Cog\Laravel\Love\ReactionType\Models\ReactionType;
use Doctrine\DBAL\Driver as DoctrineDbalDriver;

The type Doctrine\DBAL\Driver was not found. Maybe you did not declare it correctly or list all dependencies?

use Illuminate\Console\Command;
use Illuminate\Database\ConnectionInterface;
use Illuminate\Database\Eloquent\Relations\Relation;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Schema\Builder;
use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Str;

final class UpgradeV5ToV8 extends Command
{
    /**
     * The console command name.
     *
     * @var string
     */
    protected $name = 'love:upgrade-v5-to-v8';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Upgrade Love package from v5 to v8';

    /**
     * Execute the console command.
     *
     * @return void
     */
    public function handle(): void
    {
        $this->assertRequirements();
        $this->warn('Started Laravel Love v5 to v8 upgrade process.');
        # v5 to v6
        $this->dbMigrate();
        $this->populateReactionTypes();
        $this->populateReacters();
        $this->populateReactants();
        $this->populateReactions();

        # v7 to v8 change
        $this->dbChangeReactions();

        # clean v5 files and tables
        $this->dbCleanup();
        $this->filesystemCleanup();

        $this->info('Completed Laravel Love v5 to v8 upgrade process.');
    }

    private function assertRequirements(): void
    {
        if (interface_exists(DoctrineDbalDriver::class)) {
            return;
        }

        $this->error('Doctrine DBAL is missing!');
        $this->info('<comment>Install it with Composer:</comment> composer require doctrine/dbal');
        exit;

Using exit here is not recommended.

    }

    private function dbMigrate(): void
    {
        $this->call('migrate');
    }

    private function populateReactionTypes(): void
    {
        $this->info('Populating Reaction Types');
        $names = $this->collectLikeTypes();
        $mass = [
            'Like' => 1,
            'Dislike' => -1,
        ];

        foreach ($names as $name) {
            $name = $this->reactionTypeNameFromLikeTypeName($name);

            if (!isset($mass[$name])) {
                $this->warn("Reaction mass for type `{$name}` not found.");
                continue;
            }

            if (ReactionType::query()->where('name', $name)->exists()) {
                continue;
            }

            ReactionType::query()->create([
                'name' => $name,
                'mass' => $mass[$name],
            ]);
        }
    }

    private function populateReacters(): void
    {
        $this->info('Populating Reacters');
        $classes = $this->collectLikerTypes();

        $reacterableClasses = [];
        foreach ($classes as $class) {
            if (!class_exists($class)) {
                $this->warn("Class `{$class}` is not found.");
                continue;
            }

            if (!in_array(ReacterableContract::class, class_implements($class))) {
                $this->warn("Class `{$class}` need to implement Reacterable contract.");
                continue;
            }

            $reacterableClasses[] = $class;
        }

        foreach ($reacterableClasses as $class) {
            /** @var \Illuminate\Database\Eloquent\Model[] $reacterables */
            $reacterables = $class::query()->get();
            $progress = $this->output->createProgressBar($reacterables->count());
            foreach ($reacterables as $reacterable) {
                if ($reacterable->getAttributeValue('love_reacter_id') > 0) {
                    $progress->advance();
                    continue;
                }

                $reacter = $reacterable->loveReacter()->create([
                    'type' => $reacterable->getMorphClass(),
                ]);
                $reacterable->setAttribute('love_reacter_id', $reacter->getId());
                $reacterable->save();
                $progress->advance();
            }
            $progress->finish();
        }
        $this->info('');
    }

    private function populateReactants(): void
    {
        $this->info('Populating Reactants');
        $classes = $this->collectLikeableTypes();

        $reactableClasses = [];
        foreach ($classes as $class) {
            $actualClass = Relation::getMorphedModel($class);
            if ($actualClass !== null) {
                $class = $actualClass;
            }

            if (!class_exists($class)) {
                $this->warn("Class `{$class}` is not found.");
                continue;
            }

            if (!in_array(ReactableContract::class, class_implements($class))) {
                $this->warn("Class `{$class}` need to implement Reactable contract.");
                continue;
            }

            $reactableClasses[] = $class;
        }

        foreach ($reactableClasses as $class) {
            /** @var \Illuminate\Database\Eloquent\Model[] $reactables */
            $reactables = $class::query()->get();
            $progress = $this->output->createProgressBar($reactables->count());
            foreach ($reactables as $reactable) {
                if ($reactable->getAttributeValue('love_reactant_id') > 0) {
                    $progress->advance();
                    continue;
                }

                $reactant = $reactable->loveReactant()->create([
                    'type' => $reactable->getMorphClass(),
                ]);
                $reactable->setAttribute('love_reactant_id', $reactant->getId());
                $reactable->save();
                $progress->advance();
            }
            $progress->finish();
        }
        $this->info('');
    }

    private function populateReactions(): void
    {
        $this->info('Converting Likes & Dislikes to Reactions');
        /** @var \Illuminate\Database\Query\Builder $query */
        $query = DB::query();
        $likes = $query
            ->select('*')
            ->from('love_likes')
            ->orderBy('created_at', 'asc')
            ->get();

        $progress = $this->output->createProgressBar($likes->count());
        foreach ($likes as $like) {
            $class = $like->likeable_type;
            $actualClass = Relation::getMorphedModel($class);
            if ($actualClass !== null) {
                $class = $actualClass;
            }

            if (!class_exists($class)) {
                $this->warn("Class `{$class}` is not found.");
                $progress->advance();
                continue;
            }

            /** @var \Cog\Contracts\Love\Reactable\Models\Reactable $reactable */
            $reactable = $class::whereKey($like->likeable_id)->firstOrFail();

            $userClass = $this->getUserClass();

            if (!class_exists($class)) {
                $this->warn("Class `{$userClass}` is not found.");
                $progress->advance();
                continue;
            }

            /** @var \Cog\Contracts\Love\Reacterable\Models\Reacterable $reacterable */
            $reacterable = $userClass::whereKey($like->user_id)->firstOrFail();
            $reactionTypeName = $this->reactionTypeNameFromLikeTypeName($like->type_id);

            $reactionTypeId = ReactionType::fromName($reactionTypeName)->getId();
            $reactantId = $reactable->getLoveReactant()->getId();
            $reacterId = $reacterable->getLoveReacter()->getId();

            $isReactionExists = Reaction::query()
                ->where('reaction_type_id', $reactionTypeId)
                ->where('reactant_id', $reactantId)
                ->where('reacter_id', $reacterId)
                ->exists();

            if ($isReactionExists) {
                $progress->advance();
                continue;
            }

            $reaction = new Reaction();
            $reaction->forceFill([
                'reaction_type_id' => $reactionTypeId,
                'reactant_id' => $reactantId,
                'reacter_id' => $reacterId,
                'created_at' => $like->created_at,
                'updated_at' => $like->updated_at,
            ]);
            $reaction->save();
            $progress->advance();
        }
        $progress->finish();
        $this->info('');
    }

    private function dbChangeReactions(): void
    {
        $this->warn('DB: Updating reaction rate column values for existing records.');
        $this
            ->getDbQuery()
            ->table('love_reactions')
            ->where('rate', 0.0)
            ->update([
                'rate' => 1.0,
            ]);
        $this->info('DB: Updated reaction rate column values for existing records.');
    }

    private function getDbQuery(): ConnectionInterface
    {
        return DB::connection($this->getDatabaseConnection());
    }

    private function getDatabaseConnection(): ?string
    {
        return Config::get('love.storage.database.connection');
    }

    private function collectLikeTypes(): iterable
    {
        /** @var \Illuminate\Database\Query\Builder $query */
        $query = DB::query();
        $types = $query
            ->select('type_id')
            ->from('love_likes')
            ->groupBy('type_id')
            ->get()
            ->pluck('type_id')->map(function($type) {
                return ucfirst(strtolower($type));
            });
        return $types;
    }

    private function collectLikerTypes(): iterable
    {
        return [
            $this->getUserClass(),
        ];
    }

    private function collectLikeableTypes(): iterable
    {
        /** @var \Illuminate\Database\Query\Builder $query */
        $query = DB::query();
        $types = $query
            ->select('likeable_type')
            ->from('love_likes')
            ->groupBy('likeable_type')
            ->get()
            ->pluck('likeable_type');

        return $types;
    }

    private function getUserClass(): string
    {
        $guard = config('auth.defaults.guard');
        $provider = config("auth.guards.{$guard}.provider");
        $class = config("auth.providers.{$provider}.model") ?? '';

        return $class;
    }

    private function reactionTypeNameFromLikeTypeName(string $name): string
    {
        return Str::studly(strtolower($name));
    }

    private function dbCleanup(): void
    {
        $this->info('Deleting old database tables');
        DB::statement('
            DROP TABLE `love_like_counters`;
        ');
        DB::statement('
            DROP TABLE `love_likes`;
        ');
        DB::statement('
            DELETE FROM `migrations`
            WHERE `migration` = "2016_09_02_153301_create_love_likes_table"
            LIMIT 1;
        ');
        DB::statement('
            DELETE FROM `migrations`
            WHERE `migration` = "2016_09_02_163301_create_love_like_counters_table"
            LIMIT 1;
        ');
    }

    private function filesystemCleanup(): void
    {
        $this->info('Deleting old database migration files');
        $this->deleteMigrationFiles([
            '2016_09_02_153301_create_love_likes_table.php',
            '2016_09_02_163301_create_love_like_counters_table.php',
        ]);
    }

    private function deleteMigrationFiles(array $files): void
    {
        foreach ($files as $file) {
            $file = database_path("migrations/{$file}");
            if (File::exists($file)) {
                File::delete($file);
            }
        }
    }
}