starker-xp / database-checker

src/Checker/MysqlDatabaseCheckerService.php

Spacing +1 added lines, -1 removed lines

@@ -188,7 +188,7 @@
     {
         $statements = [];
         foreach ($modificationsBetweenTable as $modifications) {
-            foreach ((array)$modifications as $modification) {
+            foreach ((array) $modifications as $modification) {
                 $statements[] = $modification;
             }
         }

src/Repository/MysqlRepository.php

Spacing +1 added lines, -1 removed lines

@@ -53,7 +53,7 @@
      */
     public function getTablesCollation($database, $table)
     {
-        $sql =' SELECT c.collation_name
+        $sql = ' SELECT c.collation_name
                 FROM information_schema.`TABLES` t
                 INNER JOIN information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` c ON c.collation_name = t.table_collation
                 WHERE 

src/Structure/MysqlDatabaseColumn.php

Spacing +5 added lines, -5 removed lines

@@ -74,7 +74,7 @@ 
     {
         $isEnum = explode('enum', $this->type);
         if (!empty($isEnum)) {
-            $numberElements = substr_count(str_replace(['(', ')', "'",], '', $isEnum[1]), ',') + 1;
+            $numberElements = substr_count(str_replace(['(', ')', "'", ], '', $isEnum[1]), ',') + 1;
             if ($numberElements == 2) {
                 $this->type = 'tinyint';
                 $this->length = 1;
@@ -115,10 +115,10 @@ 
         }
         $null = $this->getNullable() ? '' : 'NOT';
         $default = $this->getDefaultValue() == false ? '' : ' DEFAULT ' . $this->getDefaultValue();
-        $collate = $this->getCollate()==''?'':sprintf("COLLATE '%s'", $this->getCollate());
+        $collate = $this->getCollate() == '' ? '' : sprintf("COLLATE '%s'", $this->getCollate());
         $modification = sprintf('ALTER TABLE `%s` ADD COLUMN `%s` %s %s NULL %s %s %s;', $this->getTable(), $this->getName(), $this->getColonneType(), $null, $default, $this->getExtra(), $collate);
 
-        return [str_replace(['   ', '  ',], ' ', $modification)];
+        return [str_replace(['   ', '  ', ], ' ', $modification)];
     }
 
     /**
@@ -189,9 +189,9 @@ 
         $null = $this->getNullable() ? '' : 'NOT';
         $default = $this->getDefaultValue() == false ? '' : ' DEFAULT ' . $this->getDefaultValue();
         $columnName = '`' . $this->getName() . '`';
-        $collate = $this->getCollate()==''?'':sprintf("COLLATE '%s'", $this->getCollate());
+        $collate = $this->getCollate() == '' ? '' : sprintf("COLLATE '%s'", $this->getCollate());
         $modification = sprintf('ALTER TABLE `%s` CHANGE COLUMN %s %s %s %s NULL %s %s %s;', $this->getTable(), $columnName, $columnName, $this->getColonneType(), $null, $default, $this->getExtra(), $collate);
 
-        return [str_replace(['   ', '  ',], ' ', $modification)];
+        return [str_replace(['   ', '  ', ], ' ', $modification)];
     }
 }

src/Structure/MysqlDatabaseTable.php

Spacing +3 added lines, -3 removed lines

@@ -173,7 +173,7 @@ 
         }
         foreach ($columns as $column) {
             try {
-                if($this->getCollate() == ''){
+                if ($this->getCollate() == '') {
                     $column->setCollate('');
                 }
                 $modifications[] = $column->createStatement();
@@ -207,7 +207,7 @@ 
     {
         $statements = [];
         foreach ($modificationsBetweenTable as $modifications) {
-            foreach ((array)$modifications as $modification) {
+            foreach ((array) $modifications as $modification) {
                 $statements[] = $modification;
             }
         }
@@ -222,7 +222,7 @@ 
         }
         $tmp = [];
         foreach ($modifications as $modification) {
-            $tmp[] = trim(str_replace(['ALTER TABLE `' . $this->getTable() . '` ADD COLUMN', 'ALTER TABLE `' . $this->getTable() . '` ADD ', ';',], '', $modification));
+            $tmp[] = trim(str_replace(['ALTER TABLE `' . $this->getTable() . '` ADD COLUMN', 'ALTER TABLE `' . $this->getTable() . '` ADD ', ';', ], '', $modification));
         }
         $collate = $this->getCollate() == '' ? '' : sprintf("COLLATE='%s'", $this->getCollate());
 

src/Factory/JsonDatabaseFactory.php

Spacing +6 added lines, -6 removed lines

@@ -54,7 +54,7 @@ 
             if (isset($row['collate'])) {
                 $table->setCollate($dataTable['collate']);
             }
-            foreach ((array)$dataTable['columns'] as $columnName => $row) {
+            foreach ((array) $dataTable['columns'] as $columnName => $row) {
                 $column = new MysqlDatabaseColumn($columnName, $row['type'], $row['length'], $row['nullable'], $row['defaultValue'], $row['extra']);
                 if (isset($row['collate'])) {
                     $column->setCollate($row['collate']);
@@ -62,13 +62,13 @@ 
                 $table->addColumn($column);
 
             }
-            foreach ((array)$dataTable['indexes'] as $row) {
+            foreach ((array) $dataTable['indexes'] as $row) {
                 $table->addIndex($row['columns'], $row['name']);
             }
             if (isset($dataTable['primary'])) {
-                $table->addPrimary((array)$dataTable['primary']);
+                $table->addPrimary((array) $dataTable['primary']);
             }
-            foreach ((array)$dataTable['uniques'] as $row) {
+            foreach ((array) $dataTable['uniques'] as $row) {
                 $table->addUnique($row['columns'], $row['name']);
             }
             $tables[] = $table;
@@ -128,11 +128,11 @@ 
         $export = [];
         foreach ($data as $nomTable => $table) {
             $dataTable = $resolverTable->resolve($table);
-            foreach ((array)$dataTable['columns'] as $columnName => $column) {
+            foreach ((array) $dataTable['columns'] as $columnName => $column) {
                 $dataTable['columns'][$columnName] = $resolverColumns->resolve($column);
             }
             foreach (['indexes', 'uniques'] as $indexKey) {
-                foreach ((array)$dataTable[$indexKey] as $keyIndex => $index) {
+                foreach ((array) $dataTable[$indexKey] as $keyIndex => $index) {
                     $dataTable[$indexKey][$keyIndex] = $resolverIndex->resolve($index);
                 }
             }