DatabaseSchema::listTableColumnsNames() - Code Metrics - Inspection of "wip" - Laravel-Backpack/CRUD - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — update-database-deps ( e3b221 )

by Pedro
created 2024-03-18 14:51 UTC
DatabaseSchema::listTableColumnsNames() A

↳ Parent: DatabaseSchema
Complexity

Conditions	1
Paths	1
Size

Total Lines	5
Code Lines	2
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	2
nc	1
nop	2
dl	0
loc	5
rs	10
c	0
b	0
f	0
<?php

namespace Backpack\CRUD\app\Library\Database;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\LazyCollection;

final class DatabaseSchema
{
    private static $schema;

    /**
     * Return the schema for the table.
     */
    public static function getForTable(string $connection, string $table)
    {
        $connection = $connection ?: config('database.default');
        
        self::generateDatabaseSchema($connection);

        return self::$schema[$connection][$table] ?? null;
    }

    public static function getTables(string $connection = null): array
    {
        $connection = $connection ?: config('database.default');
        self::generateDatabaseSchema($connection);
        
        return self::$schema[$connection] ?? [];
    }

    public function listTableColumnsNames(string $connection, string $table)
    {
        $table = self::getForTable($connection, $table);

        return array_keys($table->getColumns());
    }

    public function listTableIndexes(string $connection, string $table)
    {
        return self::getIndexColumnNames($connection, $table);
    }

    public function getManager(string $connection = null)
    {
        $connection = $connection ?: config('database.default');

        return self::getSchemaManager($connection);
    }

    public function registerDbalTypes(array $types, string $connection = null)
    {
        $connection = $connection ?: config('database.default');
        $manager = self::getSchemaManager($connection);

        if(!method_exists($manager, 'getDatabasePlatform')) {
            return;
        }

        $platform = $manager->getDatabasePlatform();
        $platform = /** @scrutinizer ignore-deprecated */ $manager->getDatabasePlatform();

        foreach ($types as $key => $value) {
            $platform->registerDoctrineTypeMapping($key, $value);
        }
    }

    public static function dbalTypes()
    {
        if(!method_exists(self::getSchemaManager(), 'getDatabasePlatform')) {
        if(!method_exists(self::/** @scrutinizer ignore-call */ getSchemaManager(), 'getDatabasePlatform')) {
            return [];
        }
        return [
            'enum'               => \Doctrine\DBAL\Types\Types::STRING,
            'geometry'           => \Doctrine\DBAL\Types\Types::STRING,
            'point'              => \Doctrine\DBAL\Types\Types::STRING,
            'lineString'         => \Doctrine\DBAL\Types\Types::STRING,
            'polygon'            => \Doctrine\DBAL\Types\Types::STRING,
            'multiPoint'         => \Doctrine\DBAL\Types\Types::STRING,
            'multiLineString'    => \Doctrine\DBAL\Types\Types::STRING,
            'multiPolygon'       => \Doctrine\DBAL\Types\Types::STRING,
            'geometryCollection' => \Doctrine\DBAL\Types\Types::STRING,

            \Doctrine\DBAL\Types\Types::BIGINT => 'bigInteger',
            \Doctrine\DBAL\Types\Types::SMALLINT => 'smallInteger',
            \Doctrine\DBAL\Types\Types::BLOB => 'binary',
            \Doctrine\DBAL\Types\Types::DATE_IMMUTABLE => 'date',
            \Doctrine\DBAL\Types\Types::DATETIME_IMMUTABLE => 'dateTime',
            \Doctrine\DBAL\Types\Types::DATETIMETZ_IMMUTABLE => 'dateTimeTz',
            \Doctrine\DBAL\Types\Types::TIME_IMMUTABLE => 'time',
            \Doctrine\DBAL\Types\Types::SIMPLE_ARRAY => 'array'
        ];
    }

    /**
     * Generates and store the database schema.
     */
    private static function generateDatabaseSchema(string $connection)
    {
        if (! isset(self::$schema[$connection])) {
            self::$schema[$connection] = self::mapTables($connection);
        }
    }

    /**
     * Map the tables from raw db values into an usable array.
     *
     * @param  string  $connection
     * @return array
     */
    private static function mapTables(string $connection)
    {
        return LazyCollection::make(self::getCreateSchema($connection)->getTables())->mapWithKeys(function ($table, $key) use ($connection) {
        return LazyCollection::make(self::getCreateSchema($connection)->/** @scrutinizer ignore-call */ getTables())->mapWithKeys(function ($table, $key) use ($connection) {
            $tableName = is_array($table) ? $table['name'] : $table->getName();

            if (self::$schema[$connection][$tableName] ?? false) {
                return [$tableName => self::$schema[$connection][$tableName]];
            }

            if (is_array($table)) {
                $table = new Table($tableName, self::mapTableColumns($connection, $tableName));
            }

            return [$tableName => $table];
        })->toArray();
    }

    private static function getIndexColumnNames(string $connection, string $table)
    {
        $schemaManager = self::getSchemaManager($connection);
        $indexes = method_exists($schemaManager, 'listTableIndexes') ? $schemaManager->listTableIndexes($table) : $schemaManager->getIndexes($table);
        $indexes = method_exists($schemaManager, 'listTableIndexes') ? $schemaManager->listTableIndexes($table) : $schemaManager->/** @scrutinizer ignore-call */ getIndexes($table);

        $indexes = array_map(function ($index) {
            return is_array($index) ? $index['columns'] : $index->getColumns();
        }, $indexes);

        $indexes = \Illuminate\Support\Arr::flatten($indexes);

        return array_unique($indexes);
    }

    private static function mapTableColumns(string $connection, string $table)
    {
        $indexedColumns = self::getIndexColumnNames($connection, $table);

        return LazyCollection::make(self::getSchemaManager($connection)->getColumns($table))->mapWithKeys(function ($column, $key) use ($indexedColumns) {
        return LazyCollection::make(/** @scrutinizer ignore-type */ self::getSchemaManager($connection)->getColumns($table))->mapWithKeys(function ($column, $key) use ($indexedColumns) {
            $column['index'] = array_key_exists($column['name'], $indexedColumns) ? true : false;

            return [$column['name'] => $column];
        })->toArray();
    }

    private static function getCreateSchema(string $connection)
    {
        $schemaManager = self::getSchemaManager($connection);

        return method_exists($schemaManager, 'createSchema') ? $schemaManager->createSchema() : $schemaManager;
        return method_exists($schemaManager, 'createSchema') ? /** @scrutinizer ignore-deprecated */ $schemaManager->createSchema() : $schemaManager;
    }

    private static function getSchemaManager(string $connection)
    {
        $connection = DB::connection($connection);

        return method_exists($connection, 'getDoctrineSchemaManager') ? $connection->getDoctrineSchemaManager() : $connection->getSchemaBuilder();
    }
}

Laravel-Backpack / CRUD

Scrutinizer GitHub App not installed

Push — update-database-deps ( e3b221 )

DatabaseSchema::listTableColumnsNames() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
