Cycle\Database\Driver\Postgres\Schema\PostgresColumn::createInstance()

Complexity

Conditions	25
Paths	385

Size

Total Lines	87
Code Lines	46

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	650

Importance

Changes	1
Bugs	1	Features	0

<?php
    public static function createInstance(
        string $table,
        array $schema,
        DriverInterface $driver
    ): self {
        $column = new self($table, $schema['column_name'], $driver->getTimezone());

        $column->type = match (true) {

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

            $schema['typname'] === 'timestamp' || $schema['typname'] === 'timestamptz' => 'timestamp',
            $schema['typname'] === 'date' => 'date',
            $schema['typname'] === 'time' || $schema['typname'] === 'timetz' => 'time',
            default => $schema['data_type']
        };

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

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

        $column->nullable = $schema['is_nullable'] === 'YES';

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

        if (
            \is_string($column->defaultValue)
            && \in_array($column->type, ['int', 'bigint', 'integer', 'smallint'])
            && preg_match('/nextval(.*)/', $column->defaultValue)
        ) {
            $column->type = match (true) {
                $column->type === 'bigint' => 'bigserial',
                $column->type === 'smallint' => 'smallserial',
                default => 'serial'
            };
            $column->autoIncrement = true;

            $column->defaultValue = new Fragment($column->defaultValue);

            return $column;
        }

        if ($schema['character_maximum_length'] !== null && str_contains($column->type, 'char')) {
            $column->size = (int) $schema['character_maximum_length'];

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

        }

        if ($column->type === 'numeric') {
            $column->precision = (int) $schema['numeric_precision'];

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) $schema['numeric_scale'];

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

        }

        if ($column->type === 'USER-DEFINED' && $schema['typtype'] === 'e') {
            $column->type = $schema['typname'];

            /**
             * Attention, this is not default enum type emulated via CHECK.
             * This is real Postgres enum type.
             */
            self::resolveEnum($driver, $column);
        }

        if ($column->type === 'timestamp' || $column->type === 'time' || $column->type === 'interval') {
            $column->size = (int) $schema['datetime_precision'];
        }

        if (
            $schema['typname'] === 'timestamptz' ||
            $schema['typname'] === 'timetz' ||
            $schema['typname'] === 'tstzrange'
        ) {
            $column->withTimezone = true;
        }

        if (!empty($column->size) && str_contains($column->type, 'char')) {
            //Potential enum with manually created constraint (check in)
            self::resolveConstrains($driver, $schema, $column);
        }

        if ($column->type === 'interval' && \is_string($schema['interval_type'])) {
            $column->intervalType = \str_replace(\sprintf('(%s)', $column->size), '', $schema['interval_type']);
            if (!in_array($column->intervalType, self::INTERVALS_WITH_ALLOWED_PRECISION, true)) {
                $column->size = 0;
            }
        }

        if (
            ($column->type === 'bit' || $column->type === 'bit varying') &&
            isset($schema['character_maximum_length'])
        ) {
            $column->size = (int) $schema['character_maximum_length'];
        }

        $column->normalizeDefault();

        return $column;
    }