SchemaGenerator::initialize() - Code Metrics - Inspection of "Updated readme" - kitloong/laravel-migrations-generator - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 4.x ( 626ee6...0f520e )

by Kit Loong

created 2020-04-03 16:53 UTC

SchemaGenerator::initialize() A

↳ Parent: SchemaGenerator

Complexity

Conditions	2
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	53
rs	9.0254
c	0
b	0
f	0
cc	2
nc	2
nop	3

How to fix Long Method

<?php
/**
 * Created by PhpStorm.
 * User: liow.kitloong
 */

namespace KitLoong\MigrationsGenerator\Generators;

use Doctrine\DBAL\Types\Type;
use Illuminate\Support\Facades\DB;
use KitLoong\MigrationsGenerator\MigrationGeneratorSetting;
use KitLoong\MigrationsGenerator\Types\DoubleType;
use KitLoong\MigrationsGenerator\Types\EnumType;
use KitLoong\MigrationsGenerator\Types\GeometryCollectionType;
use KitLoong\MigrationsGenerator\Types\GeometryType;
use KitLoong\MigrationsGenerator\Types\IpAddressType;
use KitLoong\MigrationsGenerator\Types\JsonbType;
use KitLoong\MigrationsGenerator\Types\LineStringType;
use KitLoong\MigrationsGenerator\Types\LongTextType;
use KitLoong\MigrationsGenerator\Types\MacAddressType;
use KitLoong\MigrationsGenerator\Types\MediumIntegerType;
use KitLoong\MigrationsGenerator\Types\MediumTextType;
use KitLoong\MigrationsGenerator\Types\MultiLineStringType;
use KitLoong\MigrationsGenerator\Types\MultiPointType;
use KitLoong\MigrationsGenerator\Types\MultiPolygonType;
use KitLoong\MigrationsGenerator\Types\PointType;
use KitLoong\MigrationsGenerator\Types\PolygonType;
use KitLoong\MigrationsGenerator\Types\SetType;
use KitLoong\MigrationsGenerator\Types\TimestampType;
use KitLoong\MigrationsGenerator\Types\TimestampTzType;
use KitLoong\MigrationsGenerator\Types\TimeTzType;
use KitLoong\MigrationsGenerator\Types\UUIDType;
use KitLoong\MigrationsGenerator\Types\YearType;
use Xethron\MigrationsGenerator\Generators\ForeignKeyGenerator;

class SchemaGenerator
{
    /**
     * @var \Doctrine\DBAL\Schema\AbstractSchemaManager
     */
    protected $schema;

    /**
     * @var FieldGenerator
     */
    protected $fieldGenerator;

    /**
     * @var ForeignKeyGenerator
     */
    protected $foreignKeyGenerator;

    private $indexGenerator;

    /**
     * @var string
     */
    protected $database;
    /**
     * @var bool
     */
    private $ignoreIndexNames;
    /**
     * @var bool
     */
    private $ignoreForeignKeyNames;

    public function __construct(
        FieldGenerator $fieldGenerator,
        IndexGenerator $indexGenerator,
        ForeignKeyGenerator $foreignKeyGenerator
    ) {
        $this->fieldGenerator = $fieldGenerator;
        $this->indexGenerator = $indexGenerator;
        $this->foreignKeyGenerator = $foreignKeyGenerator;
    }

    /**
     * @param  string  $database
     * @param  bool  $ignoreIndexNames
     * @param  bool  $ignoreForeignKeyNames
     * @throws \Doctrine\DBAL\DBALException
     */
    public function initialize(string $database, bool $ignoreIndexNames, bool $ignoreForeignKeyNames)
    {
        /** @var MigrationGeneratorSetting $setting */
        $setting = resolve(MigrationGeneratorSetting::class);

        $this->registerCustomDoctrineType(DoubleType::class, 'double', 'double');
        $this->registerCustomDoctrineType(EnumType::class, 'enum', 'enum');
        $this->registerCustomDoctrineType(GeometryType::class, 'geometry', 'geometry');
        $this->registerCustomDoctrineType(GeometryCollectionType::class, 'geometrycollection', 'geometrycollection');
        $this->registerCustomDoctrineType(LineStringType::class, 'linestring', 'linestring');
        $this->registerCustomDoctrineType(LongTextType::class, 'longtext', 'longtext');
        $this->registerCustomDoctrineType(MediumIntegerType::class, 'mediumint', 'mediumint');
        $this->registerCustomDoctrineType(MediumTextType::class, 'mediumtext', 'mediumtext');
        $this->registerCustomDoctrineType(MultiLineStringType::class, 'multilinestring', 'multilinestring');
        $this->registerCustomDoctrineType(MultiPointType::class, 'multipoint', 'multipoint');
        $this->registerCustomDoctrineType(MultiPolygonType::class, 'multipolygon', 'multipolygon');
        $this->registerCustomDoctrineType(PointType::class, 'point', 'point');
        $this->registerCustomDoctrineType(PolygonType::class, 'polygon', 'polygon');
        $this->registerCustomDoctrineType(SetType::class, 'set', 'set');
        $this->registerCustomDoctrineType(TimestampType::class, 'timestamp', 'timestamp');
        $this->registerCustomDoctrineType(UUIDType::class, 'uuid', 'uuid');
        $this->registerCustomDoctrineType(YearType::class, 'year', 'year');

        // Postgres types
        $this->registerCustomDoctrineType(IpAddressType::class, 'ipaddress', 'inet');
        $this->registerCustomDoctrineType(JsonbType::class, 'jsonb', 'jsonb');
        $this->registerCustomDoctrineType(MacAddressType::class, 'macaddress', 'macaddr');
        $this->registerCustomDoctrineType(TimeTzType::class, 'timetz', 'timetz');
        $this->registerCustomDoctrineType(TimestampTzType::class, 'timestamptz', 'timestamptz');

        /** @var \Doctrine\DBAL\Connection $connection */
        $connection = DB::connection($database)->getDoctrineConnection();

        $connection->getDatabasePlatform()->registerDoctrineTypeMapping('bit', 'boolean');
        $connection->getDatabasePlatform()->registerDoctrineTypeMapping('json', 'json');

        switch ($setting->getPlatform()) {
            case Platform::POSTGRESQL:
                $connection->getDatabasePlatform()->registerDoctrineTypeMapping('_text', 'text');
                $connection->getDatabasePlatform()->registerDoctrineTypeMapping('_int4', 'integer');
                $connection->getDatabasePlatform()->registerDoctrineTypeMapping('_numeric', 'float');
                $connection->getDatabasePlatform()->registerDoctrineTypeMapping('cidr', 'string');
                break;
            default:
        }

        $this->database = $connection->getDatabase();

        $this->schema = $connection->getSchemaManager();

        $this->ignoreIndexNames = $ignoreIndexNames;
        $this->ignoreForeignKeyNames = $ignoreForeignKeyNames;
    }

    /**
     * @return string[]
     */
    public function getTables(): array
    {
        return $this->schema->listTableNames();
    }

    public function getFields(string $tableName): array
    {
        $table = $this->schema->listTableDetails($tableName);
        $indexes = $this->indexGenerator->generate($table, $this->ignoreIndexNames);
        $singleColIndexes = $indexes['single'];
        $multiColIndexes = $indexes['multi'];
        $fields = $this->fieldGenerator->generate($table, $singleColIndexes);
        return array_merge($fields, $multiColIndexes->toArray());
    }

    public function getForeignKeyConstraints(string $table): array
    {
        return $this->foreignKeyGenerator->generate($table, $this->schema, $this->ignoreForeignKeyNames);
    }

    /**
     * Register custom doctrineType
     * Will override if exists
     *
     * @param $class
     * @param $name
     * @param $type
     * @throws \Doctrine\DBAL\DBALException
     */
    public function registerCustomDoctrineType($class, $name, $type)
    {
        /** @var MigrationGeneratorSetting $setting */
        $setting = resolve(MigrationGeneratorSetting::class);

        if (!Type::hasType($name)) {
            Type::addType($name, $class);
        } else {
            Type::overrideType($name, $class);
        }

        $setting->getDatabasePlatform()
            ->registerDoctrineTypeMapping($type, $name);
    }
}


1			<?php
2			/**
3			* Created by PhpStorm.
4			* User: liow.kitloong
5			*/
6
7			namespace KitLoong\MigrationsGenerator\Generators;
8
9			use Doctrine\DBAL\Types\Type;
10			use Illuminate\Support\Facades\DB;
11			use KitLoong\MigrationsGenerator\MigrationGeneratorSetting;
12			use KitLoong\MigrationsGenerator\Types\DoubleType;
13			use KitLoong\MigrationsGenerator\Types\EnumType;
14			use KitLoong\MigrationsGenerator\Types\GeometryCollectionType;
15			use KitLoong\MigrationsGenerator\Types\GeometryType;
16			use KitLoong\MigrationsGenerator\Types\IpAddressType;
17			use KitLoong\MigrationsGenerator\Types\JsonbType;
18			use KitLoong\MigrationsGenerator\Types\LineStringType;
19			use KitLoong\MigrationsGenerator\Types\LongTextType;
20			use KitLoong\MigrationsGenerator\Types\MacAddressType;
21			use KitLoong\MigrationsGenerator\Types\MediumIntegerType;
22			use KitLoong\MigrationsGenerator\Types\MediumTextType;
23			use KitLoong\MigrationsGenerator\Types\MultiLineStringType;
24			use KitLoong\MigrationsGenerator\Types\MultiPointType;
25			use KitLoong\MigrationsGenerator\Types\MultiPolygonType;
26			use KitLoong\MigrationsGenerator\Types\PointType;
27			use KitLoong\MigrationsGenerator\Types\PolygonType;
28			use KitLoong\MigrationsGenerator\Types\SetType;
29			use KitLoong\MigrationsGenerator\Types\TimestampType;
30			use KitLoong\MigrationsGenerator\Types\TimestampTzType;
31			use KitLoong\MigrationsGenerator\Types\TimeTzType;
32			use KitLoong\MigrationsGenerator\Types\UUIDType;
33			use KitLoong\MigrationsGenerator\Types\YearType;
34			use Xethron\MigrationsGenerator\Generators\ForeignKeyGenerator;
35
36			class SchemaGenerator
37			{
38			/**
39			* @var \Doctrine\DBAL\Schema\AbstractSchemaManager
40			*/
41			protected $schema;
42
43			/**
44			* @var FieldGenerator
45			*/
46			protected $fieldGenerator;
47
48			/**
49			* @var ForeignKeyGenerator
50			*/
51			protected $foreignKeyGenerator;
52
53			private $indexGenerator;
54
55			/**
56			* @var string
57			*/
58			protected $database;
59			/**
60			* @var bool
61			*/
62			private $ignoreIndexNames;
63			/**
64			* @var bool
65			*/
66			private $ignoreForeignKeyNames;
67
68			public function __construct(
69			FieldGenerator $fieldGenerator,
70			IndexGenerator $indexGenerator,
71			ForeignKeyGenerator $foreignKeyGenerator
72			) {
73			$this->fieldGenerator = $fieldGenerator;
74			$this->indexGenerator = $indexGenerator;
75			$this->foreignKeyGenerator = $foreignKeyGenerator;
76			}
77
78			/**
79			* @param string $database
80			* @param bool $ignoreIndexNames
81			* @param bool $ignoreForeignKeyNames
82			* @throws \Doctrine\DBAL\DBALException
83			*/
84			public function initialize(string $database, bool $ignoreIndexNames, bool $ignoreForeignKeyNames)
85			{
86			/** @var MigrationGeneratorSetting $setting */
87			$setting = resolve(MigrationGeneratorSetting::class);
88
89			$this->registerCustomDoctrineType(DoubleType::class, 'double', 'double');
90			$this->registerCustomDoctrineType(EnumType::class, 'enum', 'enum');
91			$this->registerCustomDoctrineType(GeometryType::class, 'geometry', 'geometry');
92			$this->registerCustomDoctrineType(GeometryCollectionType::class, 'geometrycollection', 'geometrycollection');
93			$this->registerCustomDoctrineType(LineStringType::class, 'linestring', 'linestring');
94			$this->registerCustomDoctrineType(LongTextType::class, 'longtext', 'longtext');
95			$this->registerCustomDoctrineType(MediumIntegerType::class, 'mediumint', 'mediumint');
96			$this->registerCustomDoctrineType(MediumTextType::class, 'mediumtext', 'mediumtext');
97			$this->registerCustomDoctrineType(MultiLineStringType::class, 'multilinestring', 'multilinestring');
98			$this->registerCustomDoctrineType(MultiPointType::class, 'multipoint', 'multipoint');
99			$this->registerCustomDoctrineType(MultiPolygonType::class, 'multipolygon', 'multipolygon');
100			$this->registerCustomDoctrineType(PointType::class, 'point', 'point');
101			$this->registerCustomDoctrineType(PolygonType::class, 'polygon', 'polygon');
102			$this->registerCustomDoctrineType(SetType::class, 'set', 'set');
103			$this->registerCustomDoctrineType(TimestampType::class, 'timestamp', 'timestamp');
104			$this->registerCustomDoctrineType(UUIDType::class, 'uuid', 'uuid');
105			$this->registerCustomDoctrineType(YearType::class, 'year', 'year');
106
107			// Postgres types
108			$this->registerCustomDoctrineType(IpAddressType::class, 'ipaddress', 'inet');
109			$this->registerCustomDoctrineType(JsonbType::class, 'jsonb', 'jsonb');
110			$this->registerCustomDoctrineType(MacAddressType::class, 'macaddress', 'macaddr');
111			$this->registerCustomDoctrineType(TimeTzType::class, 'timetz', 'timetz');
112			$this->registerCustomDoctrineType(TimestampTzType::class, 'timestamptz', 'timestamptz');
113
114			/** @var \Doctrine\DBAL\Connection $connection */
115			$connection = DB::connection($database)->getDoctrineConnection();
116
117			$connection->getDatabasePlatform()->registerDoctrineTypeMapping('bit', 'boolean');
118			$connection->getDatabasePlatform()->registerDoctrineTypeMapping('json', 'json');
119
120			switch ($setting->getPlatform()) {
121			case Platform::POSTGRESQL:
122			$connection->getDatabasePlatform()->registerDoctrineTypeMapping('_text', 'text');
123			$connection->getDatabasePlatform()->registerDoctrineTypeMapping('_int4', 'integer');
124			$connection->getDatabasePlatform()->registerDoctrineTypeMapping('_numeric', 'float');
125			$connection->getDatabasePlatform()->registerDoctrineTypeMapping('cidr', 'string');
126			break;
127			default:
128			}
129
130			$this->database = $connection->getDatabase();
131
132			$this->schema = $connection->getSchemaManager();
133
134			$this->ignoreIndexNames = $ignoreIndexNames;
135			$this->ignoreForeignKeyNames = $ignoreForeignKeyNames;
136			}
137
138			/**
139			* @return string[]
140			*/
141			public function getTables(): array
142			{
143			return $this->schema->listTableNames();
144			}
145
146			public function getFields(string $tableName): array
147			{
148			$table = $this->schema->listTableDetails($tableName);
149			$indexes = $this->indexGenerator->generate($table, $this->ignoreIndexNames);
150			$singleColIndexes = $indexes['single'];
151			$multiColIndexes = $indexes['multi'];
152			$fields = $this->fieldGenerator->generate($table, $singleColIndexes);
153			return array_merge($fields, $multiColIndexes->toArray());
154			}
155
156			public function getForeignKeyConstraints(string $table): array
157			{
158			return $this->foreignKeyGenerator->generate($table, $this->schema, $this->ignoreForeignKeyNames);
159			}
160
161			/**
162			* Register custom doctrineType
163			* Will override if exists
164			*
165			* @param $class
166			* @param $name
167			* @param $type
168			* @throws \Doctrine\DBAL\DBALException
169			*/
170			public function registerCustomDoctrineType($class, $name, $type)
171			{
172			/** @var MigrationGeneratorSetting $setting */
173			$setting = resolve(MigrationGeneratorSetting::class);
174
175			if (!Type::hasType($name)) {
176			Type::addType($name, $class);
177			} else {
178			Type::overrideType($name, $class);
179			}
180
181			$setting->getDatabasePlatform()
182			->registerDoctrineTypeMapping($type, $name);
183			}
184			}
185

kitloong / laravel-migrations-generator

Push — 4.x ( 626ee6...0f520e )

SchemaGenerator::initialize() A

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like