starker-xp / database-checker

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());