PhpTelegramBot\Laravel\Migration

Complexity

Total Complexity

5

Size/Duplication

Total Lines	36
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	changeColumnTypes()	0	20	4
A	__construct()	0	3	1

<?php

/*
 * This file is part of the PhpTelegramBot/Laravel package.
 *
 * (c) Avtandil Kikabidze aka LONGMAN <akalongman@gmail.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 PhpTelegramBot\Laravel;

use Illuminate\Database\Migrations\Migration as LaravelMigration;
use Illuminate\Support\Facades\DB;

class Migration extends LaravelMigration
{
    /** @var string */
    protected $prefix = '';

    public function __construct()
    {
        $this->prefix = (string) config('phptelegrambot.database.prefix', '');
    }

    /**
     * Change column type for passed table field(s).
     *
     * @param array  $tableColumns
     * @param string $newType
     */
    public function changeColumnTypes(array $tableColumns, string $newType): void
    {
        $database = DB::connection()->getDatabaseName();
        $prefix   = DB::connection()->getTablePrefix() . $this->prefix;

        foreach ($tableColumns as $table => $columns) {
            foreach ($columns as $column) {
                // Preserve column comment and nullable state.
                $props = DB::selectOne('
                    SELECT `COLUMN_COMMENT`, `IS_NULLABLE`
                    FROM `information_schema`.`COLUMNS`
                    WHERE `TABLE_SCHEMA` = ?
                      AND `TABLE_NAME` = ?
                      AND `COLUMN_NAME` = ?
                    LIMIT 1
                ', [$database, $prefix . $table, $column]);

                $comment  = $props->COLUMN_COMMENT;
                $nullable = $props->IS_NULLABLE === 'YES' ? 'NULL' : 'NOT NULL';
                DB::statement("ALTER TABLE `{$prefix}{$table}` CHANGE `{$column}` `{$column}` {$newType} {$nullable} COMMENT '{$comment}'");
            }
        }
    }
}