Fisharebest\Webtrees\DB\Drivers\MySQLDriver::introspectSchema()

Complexity

Conditions	3
Paths	3

Size

Total Lines	58
Code Lines	39

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function introspectSchema(string $schema_name = null): Schema
    {
        $schema_name ?? $schema_name = $this->query('SELECT DATABASE() AS schema_name')[0]->schema_name;

        $pattern = $this->escapeLike($this->prefix) . '%';

        $sql =
            'SELECT    TABLE_NAME, ENGINE, AUTO_INCREMENT, TABLE_COLLATION' .
            ' FROM     INFORMATION_SCHEMA.TABLES' .
            ' WHERE    TABLE_TYPE   =    :table_type' .
            '   AND    TABLE_SCHEMA =    :table_schema' .
            '   AND    TABLE_NAME   LIKE :pattern' .
            ' ORDER BY TABLE_NAME';

        $table_rows = $this->query($sql, [
            'table_type'   => 'BASE TABLE',
            'pattern'      => $pattern,
            'table_schema' => $schema_name,
        ]);

        $sql =
            'SELECT    TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, DATETIME_PRECISION, CHARACTER_SET_NAME, COLLATION_NAME, COLUMN_TYPE, COLUMN_KEY, EXTRA, COLUMN_COMMENT, GENERATION_EXPRESSION, SRS_ID' .
            ' FROM     INFORMATION_SCHEMA.COLUMNS' .
            ' WHERE    TABLE_SCHEMA =    :table_schema' .
            '   AND    TABLE_NAME   LIKE :pattern' .
            ' ORDER BY ORDINAL_POSITION';

        $column_rows = $this->query($sql, ['pattern' => $pattern, 'table_schema' => $schema_name]);

        $sql =
            'SELECT TABLE_NAME, CONSTRAINT_NAME, CONSTRAINT_TYPE' .
            ' FROM  INFORMATION_SCHEMA.TABLE_CONSTRAINTS' .
            ' WHERE TABLE_SCHEMA =    :table_schema' .
            '   AND TABLE_NAME   LIKE :pattern';

        $table_constraints_rows = $this->query($sql, ['pattern' => $pattern, 'table_schema' => $schema_name]);

        $sql =
            'SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION, POSITION_IN_UNIQUE_CONSTRAINT,' .
            '       REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME' .
            ' FROM  INFORMATION_SCHEMA.KEY_COLUMN_USAGE' .
            ' WHERE TABLE_SCHEMA = :table_schema' .
            '   AND TABLE_NAME LIKE :pattern';

        $key_column_usage_rows = $this->query($sql, ['pattern' => $pattern, 'table_schema' => $schema_name]);

        foreach ($table_rows as $table_row) {
            $table = new Table($table_row->TABLE_NAME);

The assignment to $table is dead and can be removed.

            $this_column_rows = array_filter($column_rows, static fn (object $row): bool => $row->TABLE_NAME === $table_row->TABLE_NAME);

            foreach ($this_column_rows as $this_column_row) {
                $column = new Column($this_column_row->COLUMN_NAME, $this_column_row->COLUMN_TYPE, $this_column_row->COLUMN_DEFAULT);

The assignment to $column is dead and can be removed.

            }

        }

        var_dump($pattern, $schema_name, $table_rows, $column_rows, $table_constraints_rows, $key_column_usage_rows);exit;

Using exit here is not recommended.

var_dump($pattern, $schema_name, $table_rows, $column_rows, $table_constraints_rows, $key_column_usage_rows) looks like debug code. Are you sure you do not want to remove it?

    }