Cycle\Database\Driver\MySQL\Schema\MySQLColumn::createInstance()

Complexity

Conditions	19
Paths	541

Size

Total Lines	87
Code Lines	52

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	21
CRAP Score	19.7049

Importance

Changes

0

<?php
    public static function createInstance(string $table, array $schema, \DateTimeZone $timezone = null): self
    {
        $column = new self($table, $schema['Field'], $timezone);

        $column->type = $schema['Type'];

The property type does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $column->nullable = strtolower($schema['Null']) === 'yes';

The property nullable does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $column->defaultValue = $schema['Default'];

The property defaultValue does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        $column->autoIncrement = stripos($schema['Extra'], 'auto_increment') !== false;

        if (
            !preg_match(
                '/^(?P<type>[a-z]+)(?:\((?P<options>[^)]+)\))?(?: (?P<attr>[a-z ]+))?/',
                $column->type,
                $matches
            )
        ) {
            //No extra definitions
            return $column;
        }

        $column->type = $matches['type'];

        $options = [];
        if (!empty($matches['options'])) {
            $options = \explode(',', $matches['options']);

            if (count($options) > 1) {
                $column->precision = (int)$options[0];

The property precision does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

                $column->scale = (int)$options[1];

The property scale does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

            } else {
                $column->size = (int)$options[0];

The property size does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

            }
        }

        if (!empty($matches['attr'])) {
            if (\in_array($column->type, self::INTEGER_TYPES, true)) {
                $intAttr = array_map('trim', explode(' ', $matches['attr']));
                if (\in_array('unsigned', $intAttr, true)) {
                    $column->unsigned = true;
                }
                if (\in_array('zerofill', $intAttr, true)) {
                    $column->zerofill = true;
                }
                unset($intAttr);
            }
        }

        // since 8.0 database does not provide size for some columns
        if ($column->size === 0) {
            switch ($column->type) {
                case 'int':
                    $column->size = 11;
                    break;
                case 'bigint':
                    $column->size = 20;
                    break;
                case 'tinyint':
                    $column->size = 4;
                    break;
                case 'smallint':
                    $column->size = 6;
                    break;
            }
        }

        //Fetching enum values
        if ($options !== [] && $column->getAbstractType() === 'enum') {
            $column->enumValues = \array_map(static fn ($value) => trim($value, $value[0]), $options);

The property enumValues does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

            return $column;
        }

        //Default value conversions
        if ($column->type === 'bit' && $column->hasDefaultValue()) {
            //Cutting b\ and '
            $column->defaultValue = new Fragment($column->defaultValue);
        }

        if (
            $column->defaultValue === '0000-00-00 00:00:00'
            && $column->getAbstractType() === 'timestamp'
        ) {
            //Normalizing default value for timestamps
            $column->defaultValue = 0;
        }

        return $column;
    }