Platine\Framework\Migration\Command\MigrationExecuteCommand

Complexity

Total Complexity

14

Size/Duplication

Total Lines	142
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	22	2
B	execute()	0	56	9
A	executeMigrationDown()	0	18	2
A	executeMigrationUp()	0	19	1

<?php

/**
 * Platine Framework
 *
 * Platine Framework is a lightweight, high-performance, simple and elegant
 * PHP Web framework
 *
 * This content is released under the MIT License (MIT)
 *
 * Copyright (c) 2020 Platine Framework
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 */

/**
 *  @file MigrationExecuteCommand.php
 *
 *  The migration execute command class
 *
 *  @package    Platine\Framework\Migration\Command
 *  @author Platine Developers team
 *  @copyright  Copyright (c) 2020
 *  @license    http://opensource.org/licenses/MIT  MIT License
 *  @link   https://www.platine-php.com
 *  @version 1.0.0
 *  @filesource
 */

declare(strict_types=1);

namespace Platine\Framework\Migration\Command;

use Platine\Config\Config;
use Platine\Filesystem\Filesystem;
use Platine\Framework\App\Application;
use Platine\Framework\Migration\MigrationRepository;
use RuntimeException;

/**
 * @class MigrationExecuteCommand
 * @package Platine\Framework\Migration\Command
 * @template T
 * @extends AbstractCommand<T>
 */
class MigrationExecuteCommand extends AbstractCommand
{
    /**
     * Create new instance
     * {@inheritdoc}
     */
    public function __construct(
        Application $app,
        MigrationRepository $repository,
        Config $config,
        Filesystem $filesystem
    ) {
        parent::__construct($app, $repository, $config, $filesystem);
        $this->setName('migration:exec')
             ->setDescription('Execute the migration up/down for one version');

        $this->addArgument('type', 'type of migration [up|down]', 'up', true, false, function ($val) {
            if (!in_array($val, ['up', 'down'])) {
                throw new RuntimeException(sprintf(
                    'Invalid argument type [%s], must be one of [up, down]',
                    $val
                ));
            }

             return $val;
        });

        $this->addOption('-i|--id', 'the migration version', null, false);
    }

    /**
     * {@inheritdoc}
     */
    public function execute(): mixed
    {
        $type = $this->getArgumentValue('type');

        $io = $this->io();
        $writer = $io->writer();
        $writer->boldYellow('MIGRATION EXECUTION', true)->eol();

        $migrations = $this->getMigrations();
        $executed = $this->getExecuted('DESC');
        $version = $this->getOptionValue('id');

        if ($type === 'up') {
            $diff = array_diff_key($migrations, $executed);
            if (count($diff) === 0) {
                $writer->boldGreen('Migration already up to date');
            } else {
                if (empty($version)) {
                    $version = $io->choice('Choose which version to migrate up', $diff);
                }

                if (!isset($diff[$version])) {
                    $writer->boldRed(sprintf(
                        'Invalid migration version [%s] or already executed',
                        $version
                    ));
                } else {
                    $description = str_replace('_', ' ', $migrations[$version]);
                    $this->executeMigrationUp($version, $description);
                }
            }
        } else {
            if (count($executed) === 0) {
                $writer->boldGreen('No migration to rollback');
            } else {
                $data = [];
                foreach ($executed as $ver => $entity) {
                    $data[$ver] = $entity->description;
                }
                if (empty($version)) {
                    $version = $io->choice('Choose which version to rollback', $data);
                }

                if (!isset($data[$version])) {
                    $writer->boldRed(sprintf(
                        'Invalid migration version [%s] or not yet executed',
                        $version
                    ));
                } else {
                    $description = str_replace('_', ' ', $data[$version]);
                    $this->executeMigrationDown($version, $description);
                }
            }
        }

        return true;
    }

    /**
     * Execute migration up
     * @param string $version
     * @param string $description
     * @return void
     */
    public function executeMigrationUp(string $version, string $description): void
    {
        $writer = $this->io()->writer();
        $writer->boldGreen(sprintf(
            '* Execute migration up for %s: %s',
            $version,
            $description,
        ))->eol();

        $migration = $this->createMigrationClass($description, $version);
        $migration->up();

        $entity = $this->repository->create([
            'version' => $version,
            'description' => $description,
            'created_at' => date('Y-m-d H:i:s'),
        ]);

        $this->repository->save($entity);
    }

    /**
     * Execute migration down
     * @param string $version
     * @param string $description
     * @return void
     */
    public function executeMigrationDown(string $version, string $description): void
    {
        $writer = $this->io()->writer();
        $writer->boldGreen(sprintf(
            '* Execute migration down for %s: %s',
            $version,
            $description,
        ))->eol();

        $migration = $this->createMigrationClass($description, $version);
        $migration->down();

        $entity = $this->repository->findBy([
            'version' => $version
        ]);

        if ($entity) {
            $this->repository->delete($entity);
        }
    }
}