Table::getIndexes() - Code Metrics - Inspection of "Initialize project" - Codexshaper/laravel-database-manager - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( 0ed784...b28e07 )

by CodexShaper
created 2020-01-02 11:17 UTC
Table::getIndexes() A

↳ Parent: Table
Complexity

Conditions	2
Paths	2
Size

Total Lines	12
Code Lines	6
Duplication

Lines	0
Ratio	0 %
Importance

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

namespace CodexShaper\DBM\Database\Schema;

use CodexShaper\DBM\Database\Schema\Column;
use CodexShaper\DBM\Database\Schema\ForeignKey;
use CodexShaper\DBM\Database\Schema\Index;
use CodexShaper\DBM\Database\Schema\UpdateManager;
use CodexShaper\DBM\Database\Types\Type;
use CodexShaper\DBM\Facades\Driver;
use CodexShaper\DBM\Facades\MongoDB;
use Doctrine\DBAL\Schema\SchemaException;
use Doctrine\DBAL\Schema\Table as DoctrineTable;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Pagination\LengthAwarePaginator;
filter:
    dependency_paths: ["lib/*"]
use Illuminate\Pagination\Paginator;
filter:
    dependency_paths: ["lib/*"]

class Table
{
    public static function all()
    {
        // MongoDb
        if (Driver::isMongoDB()) {
        if (Driver::/** @scrutinizer ignore-call */ isMongoDB()) {
            return MongoDB::getCollectionNames();
        }
        return SchemaManager::getInstance()->listTableNames();
    }

    public static function getTable($tableName)
    {
        if (Driver::isMongoDB()) {
            return MongoDB::getCollection($tableName);
        }

        Type::registerCustomTypes();

        $table          = SchemaManager::getInstance()->listTableDetails($tableName);
        $primaryKeyName = $table->getPrimaryKey();
        $options        = $table->getOptions();

        return [
            'name'           => $table->getName(),
            'oldName'        => $table->getName(),
            'columns'        => static::getColumns($table),
            'indexes'        => static::getIndexes($table),
            'foreignKeys'    => static::getForeignKeys($table),
            'primaryKeyName' => $primaryKeyName,
            'options'        => $options,
        ];
    }

    public static function getColumnsName($tableName)
    {
        $columns = static::getTable($tableName)['columns'];

        $columnsName = [];

        foreach ($columns as $column) {
            $columnsName[] = $column->name;
        }

        return $columnsName;
    }

    public static function create($table = [])
    {
        if (!is_array($table)) {
            $table = json_decode($table, true);
        }

        // MongoDB
        if (Driver::isMongoDB()) {
            return MongoDB::createCollection($table['name']);
        }

        $newTable = self::prepareTable($table);

        $schema = SchemaManager::getInstance();
        return $schema->createTable($newTable);
    }

    public static function update($table = [])
    {
        if (!is_array($table)) {
            $table = json_decode($table, true);
        }

        if (Driver::isMongoDB()) {
            return MongoDB::updateCollection($table);
        }

        (new UpdateManager())->update($table);
    }

    public static function drop($tableName)
    {
        if (Driver::isMongoDB()) {
            return MongoDB::dropCollection($tableName);
class A
{
    function getObject()
    {
        return null;
    }

}

$a = new A();
if ($a->getObject()) {
        }

        return SchemaManager::getInstance()->dropTable($tableName);
    }

    public static function prepareTable($table = [])
    {

        if (!is_array($table)) {
            $table = json_decode($table, true);
        }

        Type::registerCustomTypes();

        // DoctrineType::addType('varchar', 'App\CodexShaper\Database\Types\Common\VarCharType');
        // SchemaManager::getInstance()->getDatabasePlatform()->registerDoctrineTypeMapping('db_varchar', 'varchar');

        $conn = 'database.connections.' . config('database.default');
        $conn = 'database.connections.' . /** @scrutinizer ignore-call */ config('database.default');

        $table['options']['collate'] = config($conn . '.collation', 'utf8mb4_unicode_ci');
        $table['options']['charset'] = config($conn . '.charset', 'utf8mb4');

        $tableName   = $table['name'];
        $columns     = $table['columns'];
        $indexes     = $table['indexes'];
        $foreignKeys = $table['foreignKeys'];

        // Make Doctrain  columns
        $DoctrineColumns = [];
        foreach ($columns as $column) {
            $DoctrineColumn                              = Column::create($column);
            $DoctrineColumns[$DoctrineColumn->getName()] = $DoctrineColumn;
        }

        // Make Doctrain indexes
        $DoctrineIndexes = [];
        foreach ($indexes as $index) {
            $DoctrineIndex                              = Index::create($index);
            $DoctrineIndexes[$DoctrineIndex->getName()] = $DoctrineIndex;
        }

        // Make Doctrain Foreign Keys
        $DoctrineForeignKeys = [];
        foreach ($foreignKeys as $foreignKey) {

            $DoctrineForeignKey = ForeignKey::create($foreignKey);

            $DoctrineForeignKeys[$DoctrineForeignKey->getName()] = $DoctrineForeignKey;
        }

        $options = $table['options'];

        return new DoctrineTable($tableName, $DoctrineColumns, $DoctrineIndexes, $DoctrineForeignKeys, false, $options);
        return new DoctrineTable($tableName, $DoctrineColumns, $DoctrineIndexes, $DoctrineForeignKeys, /** @scrutinizer ignore-type */ false, $options);
    }

    public static function getColumns(DoctrineTable $table)
    {
        $columns = [];

        $order = 1;
        foreach ($table->getColumns() as $column) {
            $columns[] = (object) array_merge(
                Column::toArray($column),
                array('order' => $order)
            );
            $order++;
        }

        return $columns;
    }

    public static function getIndexes(DoctrineTable $table)
    {
        $indexes = [];

        foreach ($table->getIndexes() as $index) {
            $indexes[] = (object) array_merge(
                Index::toArray($index),
                array('table' => $table->getName())
            );
        }

        return $indexes;
    }

    public static function getForeignKeys(DoctrineTable $table)
    {
        $foreignKeys = [];

        foreach ($table->getForeignKeys() as $name => $foreignKey) {
            $foreignKeys[$name] = ForeignKey::toArray($foreignKey);
        }

        return $foreignKeys;
    }

    public static function exists($tableName)
    {
        if (Driver::isMongoDB()) {
            return MongoDB::hasCollection($tableName);
        }

        if (!SchemaManager::getInstance()->tablesExist($tableName)) {
            throw SchemaException::tableDoesNotExist($tableName);
        }

        return true;
    }

    public static function paginate($perPage = 15, $page = null, $options = [], $query = "")
    {
        $page            = $page ?: (Paginator::resolveCurrentPage() ?: 1);
        $options['path'] = Paginator::resolveCurrentPath();
        $items           = static::all();
        $collection      = $items instanceof Collection ? $items : Collection::make($items);
        if (!empty($query)) {
            $collection = $collection->filter(function ($value, $key) use ($query) {
            $collection = $collection->filter(function ($value, /** @scrutinizer ignore-unused */ $key) use ($query) {
                return false !== stristr($value, $query);
            });
        }

        return new LengthAwarePaginator($collection->forPage($page, $perPage), $collection->count(), $perPage, $page, $options);

    }
}

Codexshaper / laravel-database-manager

Push — master ( 0ed784...b28e07 )

Table::getIndexes() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
