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

Complexity

Conditions	19
Paths	541

Size

Total Lines	88
Code Lines	53

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	23.4381

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->comment = $schema['Comment'];
        $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];
            }
        }

        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 and set values
        if ($options !== [] && static::isEnum($column)) {
            $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;
    }