thecodingmachine / DBFaker

src/Helpers/SchemaHelper.php

Spacing +5 added lines, -5 removed lines

@@ -74,8 +74,8 @@ 
     public function getForeignKeyConstraintByLocal(Table $table, Column $column) : ?ForeignKeyConstraint
     {
         $table = $this->schema->getTable($table->getName());
-        foreach ($table->getForeignKeys() as $foreignKeyConstraint){
-            if (\in_array($column->getName(), $foreignKeyConstraint->getLocalColumns(), true)){
+        foreach ($table->getForeignKeys() as $foreignKeyConstraint) {
+            if (\in_array($column->getName(), $foreignKeyConstraint->getLocalColumns(), true)) {
                 return $foreignKeyConstraint;
             }
         }
@@ -108,13 +108,13 @@ 
     public function isForeignKeyAlsoUniqueIndex(ForeignKeyConstraint $fk) : bool
     {
         $table = $fk->getLocalTable();
-        foreach ($table->getIndexes() as $index){
-            if ($index->isUnique() && count($index->getColumns()) === count($fk->getLocalColumns())){
+        foreach ($table->getIndexes() as $index) {
+            if ($index->isUnique() && count($index->getColumns()) === count($fk->getLocalColumns())) {
                 $indexCols = $index->getColumns();
                 $fkCols = $fk->getColumns();
                 sort($indexCols);
                 sort($fkCols);
-                if ($indexCols == $fkCols){
+                if ($indexCols == $fkCols) {
                     return true;
                 }
             }

src/Helpers/NumericColumnLimitHelper.php

Spacing +9 added lines, -9 removed lines

@@ -34,7 +34,7 @@ 
      */
     public function __construct(Column $column)
     {
-        if (!\in_array($column->getType()->getName(), self::$handledNumberTypes, true)){
+        if (!\in_array($column->getType()->getName(), self::$handledNumberTypes, true)) {
             throw new UnsupportedDataTypeException('Unsupported column type : ' .
                 $column->getType()->getName() . 'only ' .
                 implode("', '", self::$handledNumberTypes) . ' types are supported.'
@@ -50,15 +50,15 @@ 
     public function getMinNumericValue()
     {
         $precisionValue = $this->getAbsValueByLengthPrecision($this->column);
-        switch ($this->column->getType()->getName()){
+        switch ($this->column->getType()->getName()) {
             case Type::BIGINT:
                 return $this->column->getUnsigned() ? 0 : bcmul('-1', bcpow('2', '63'));
                 break;
             case Type::INTEGER:
-                return $this->column->getUnsigned() ? 0 : max(-1 * $precisionValue, bcmul('-1' , bcpow('2', '31')));
+                return $this->column->getUnsigned() ? 0 : max(-1 * $precisionValue, bcmul('-1', bcpow('2', '31')));
                 break;
             case Type::SMALLINT:
-                return $this->column->getUnsigned() ? 0 : bcmul('-1' , bcpow('2', '15'));
+                return $this->column->getUnsigned() ? 0 : bcmul('-1', bcpow('2', '15'));
                 break;
             case Type::DECIMAL:
                 return $this->column->getUnsigned() ? 0 : -1 * $precisionValue;
@@ -76,13 +76,13 @@ 
     public function getMaxNumericValue()
     {
         $precisionValue = $this->getAbsValueByLengthPrecision($this->column);
-        switch ($this->column->getType()->getName()){
+        switch ($this->column->getType()->getName()) {
             case Type::BIGINT:
-                return $this->column->getUnsigned() ? bcsub(bcpow('2', '64'), '1') : bcsub(bcpow('2', '63') , '1');
+                return $this->column->getUnsigned() ? bcsub(bcpow('2', '64'), '1') : bcsub(bcpow('2', '63'), '1');
             case Type::INTEGER:
-                return $this->column->getUnsigned() ? bcsub(bcpow('2', '32'), '1') : min($precisionValue, bcsub( bcpow('2', '31') , '1'));
+                return $this->column->getUnsigned() ? bcsub(bcpow('2', '32'), '1') : min($precisionValue, bcsub(bcpow('2', '31'), '1'));
             case Type::SMALLINT:
-                return $this->column->getUnsigned() ? bcsub(bcpow('2', '16'), '1') : bcsub( bcpow('2', '15') , '1');
+                return $this->column->getUnsigned() ? bcsub(bcpow('2', '16'), '1') : bcsub(bcpow('2', '15'), '1');
             case Type::DECIMAL:
                 return $this->column->getUnsigned() ? 0 : $precisionValue;
             case Type::FLOAT:
@@ -96,7 +96,7 @@ 
      */
     private function getAbsValueByLengthPrecision(Column $column)
     {
-        switch ($column->getType()->getName()){
+        switch ($column->getType()->getName()) {
             case Type::DECIMAL:
                 $str = str_repeat('9', $column->getScale());
                 return (double) substr_replace($str, '.', $column->getScale() - $column->getPrecision(), 0);

src/DBFaker.php

Spacing +45 added lines, -45 removed lines

@@ -112,7 +112,7 @@ 
      */
     public function fakeDB() : void
     {
-        set_time_limit(0);//Import may take a looooooong time :)
+        set_time_limit(0); //Import may take a looooooong time :)
         $data = $this->generateFakeData();
         $extensionContraints = $this->getExtensionConstraints();
         $foreignKeys = $this->dropForeignKeys();
@@ -165,9 +165,9 @@ 
                 }
                 //Other data will be Faked depending of column's type and attributes. FKs to, but their values wil be overridden.
                 else {
-                    if (!$column->getNotnull() && $this->nullProbabilityOccured()){
+                    if (!$column->getNotnull() && $this->nullProbabilityOccured()) {
                         $value = null;
-                    }else{
+                    }else {
                         $generator = $this->getSimpleColumnGenerator($table, $column);
                         $value = $generator();
                     }
@@ -220,14 +220,14 @@ 
     private function insertWithoutFksAndUniqueIndexes(array $data): void
     {
         $plateform = $this->connection->getDatabasePlatform();
-        foreach ($data as $tableName => $rows){
+        foreach ($data as $tableName => $rows) {
             $table = $this->schemaManager->listTableDetails($tableName);
 
             //initiate column types for insert : only get the first array to retrieve column names
             $types = [];
             $first = reset($rows);
-            if ($first){
-                foreach ($first as $columnName => $value){
+            if ($first) {
+                foreach ($first as $columnName => $value) {
                     /** @var Column $column */
                     $column = $table->getColumn($columnName);
                     $types[] = $column->getType()->getBindingType();
@@ -236,9 +236,9 @@ 
 
             //insert faked data
             $cnt = count($rows);
-            foreach ($rows as $index => $row){
+            foreach ($rows as $index => $row) {
                 $dbRow = [];
-                foreach ($row as $columnName => $value){
+                foreach ($row as $columnName => $value) {
                     $column = $table->getColumn($columnName);
                     $newVal = $column->getType()->convertToDatabaseValue($value, $plateform);
                     $dbRow[$column->getQuotedName($this->connection->getDatabasePlatform())] = $newVal;
@@ -247,10 +247,10 @@ 
                 $this->connection->insert($table->getName(), $dbRow, $types);
             }
             //if autoincrement, add the new ID to the PKRegistry
-            if ($table->hasPrimaryKey()){
+            if ($table->hasPrimaryKey()) {
                 $pkColumnName = $table->getPrimaryKeyColumns()[0];
                 $pkColumn = $table->getColumn($pkColumnName);
-                if ($pkColumn->getAutoincrement() && $this->schemaHelper->isPrimaryKeyColumn($table, $pkColumn)){
+                if ($pkColumn->getAutoincrement() && $this->schemaHelper->isPrimaryKeyColumn($table, $pkColumn)) {
                     $this->getPkRegistry($table)->addValue([$pkColumnName => $this->connection->lastInsertId()]);
                 }
             }
@@ -265,7 +265,7 @@ 
      */
     public function getPkRegistry(Table $table, bool $isSelfReferencing = false) : PrimaryKeyRegistry
     {
-        $index = $table->getName().($isSelfReferencing ? 'dbfacker_self_referencing' :'');
+        $index = $table->getName() . ($isSelfReferencing ? 'dbfacker_self_referencing' : '');
         if (!isset($this->primaryKeyRegistries[$index])) {
             $this->primaryKeyRegistries[$index] = new PrimaryKeyRegistry($this->connection, $table, $this->schemaHelper, $isSelfReferencing);
         }
@@ -312,10 +312,10 @@ 
         $this->log->info('Step 2.1 : Drop FKs ...');
         $foreignKeys = [];
         $tables = $this->schemaManager->listTables();
-        foreach ($tables as $table){
-            foreach ($table->getForeignKeys() as $fk){
+        foreach ($tables as $table) {
+            foreach ($table->getForeignKeys() as $fk) {
                 $foreignTable = $this->schemaManager->listTableDetails($fk->getForeignTableName());
-                foreach ($fk->getColumns() as $localColumnName){
+                foreach ($fk->getColumns() as $localColumnName) {
                     $localColumn = $table->getColumn($localColumnName);
                     $selfReferencing = $fk->getForeignTableName() === $table->getName();
                     $fkValueGenerator = new ForeignKeyColumnGenerator($table, $localColumn, $this->getPkRegistry($foreignTable, $selfReferencing), $fk, $this->fakerManagerHelper, $this->schemaHelper);
@@ -335,8 +335,8 @@ 
     private function restoreForeignKeys($foreignKeys) : void
     {
         $this->log->info('Step 4 : restore foreign keys');
-        foreach ($foreignKeys as $tableName => $fks){
-            foreach ($fks as $fk){
+        foreach ($foreignKeys as $tableName => $fks) {
+            foreach ($fks as $fk) {
                 $this->schemaManager->createForeignKey($fk, $tableName);
             }
         }
@@ -351,9 +351,9 @@ 
         $this->log->info('Step 2.2 : Drop Multiple indexes ...');
         $multipleUniqueContraints = [];
         $tables = $this->schemaManager->listTables();
-        foreach ($tables as $table){
-            foreach ($table->getIndexes() as $index){
-                if ($index->isUnique() && count($index->getColumns()) > 1){
+        foreach ($tables as $table) {
+            foreach ($table->getIndexes() as $index) {
+                if ($index->isUnique() && count($index->getColumns()) > 1) {
                     $multipleUniqueContraints[$table->getName()][] = $index;
                     $this->schemaManager->dropIndex($index->getQuotedName($this->connection->getDatabasePlatform()), $table->getName());
                 }
@@ -368,8 +368,8 @@ 
     private function restoreMultipleUniqueContraints(array $multipleUniqueContraints): void
     {
         $this->log->info('Step 5 : restore multiple unique indexes keys');
-        foreach ($multipleUniqueContraints as $tableName => $indexes){
-            foreach ($indexes as $index){
+        foreach ($multipleUniqueContraints as $tableName => $indexes) {
+            foreach ($indexes as $index) {
                 $this->schemaManager->createIndex($index, $tableName);
             }
         }
@@ -387,24 +387,24 @@ 
     private function updateMultipleUniqueIndexedColumns(array $multipleUniqueContraints, array $handledFKColumns) : array
     {
 
-        foreach ($multipleUniqueContraints as $tableName => $indexes){
+        foreach ($multipleUniqueContraints as $tableName => $indexes) {
             $table = $this->schemaManager->listTableDetails($tableName);
 
-            foreach ($indexes as $index){
-                foreach ($index->getColumns() as $columnName){
-                    $fullColumnName = $tableName. '.' .$columnName;
-                    if (!\in_array($fullColumnName, $handledFKColumns, true)){
+            foreach ($indexes as $index) {
+                foreach ($index->getColumns() as $columnName) {
+                    $fullColumnName = $tableName . '.' . $columnName;
+                    if (!\in_array($fullColumnName, $handledFKColumns, true)) {
                         $handledFKColumns[] = $fullColumnName;
                     }
                 }
             }
 
-            $stmt = $this->connection->query('SELECT * FROM ' .$tableName);
-            $count = $this->connection->fetchColumn('SELECT count(*) FROM ' .$tableName);
+            $stmt = $this->connection->query('SELECT * FROM ' . $tableName);
+            $count = $this->connection->fetchColumn('SELECT count(*) FROM ' . $tableName);
             $i = 1;
             while ($row = $stmt->fetch()) {
                 $newValues = [];
-                foreach ($indexes as $index){
+                foreach ($indexes as $index) {
                     /** @var Index $index */
                     $compoundColumnGenerator = $this->getCompoundColumnGenerator($table, $index, $count);
                     $newValues = array_merge($newValues, $compoundColumnGenerator());
@@ -426,23 +426,23 @@ 
      */
     private function updateRemainingForeignKeys(array $foreignKeys, array $handledFKColumns): void
     {
-        foreach ($foreignKeys as $tableName => $fks){
-            if (!array_key_exists($tableName, $this->fakeTableRowNumbers)){
+        foreach ($foreignKeys as $tableName => $fks) {
+            if (!array_key_exists($tableName, $this->fakeTableRowNumbers)) {
                 //only update tables where data has been inserted
                 continue;
             }
 
             $table = $this->schemaManager->listTableDetails($tableName);
 
-            $stmt = $this->connection->query('SELECT * FROM ' .$tableName);
-            $count = $this->connection->fetchColumn("SELECT count(*) FROM ".$tableName);
+            $stmt = $this->connection->query('SELECT * FROM ' . $tableName);
+            $count = $this->connection->fetchColumn("SELECT count(*) FROM " . $tableName);
             $i = 1;
             while ($row = $stmt->fetch()) {
                 $newValues = [];
                 foreach ($fks as $fk) {
                     $localColumns = $fk->getLocalColumns();
                     foreach ($localColumns as $index => $localColumn) {
-                        if (\in_array($tableName . '.' . $localColumn, $handledFKColumns)){
+                        if (\in_array($tableName . '.' . $localColumn, $handledFKColumns)) {
                             continue;
                         }
                         $column = $table->getColumn($localColumn);
@@ -451,8 +451,8 @@ 
                     }
                 }
                 $row = $this->stripUnselectableColumns($table, $row);
-                if (count($newValues) && $this->connection->update($tableName, $newValues, $row) === 0){
-                    throw new DBFakerException("Row has not been updated $tableName - ". var_export($newValues,true) . ' - ' . var_export($row, true));
+                if (count($newValues) && $this->connection->update($tableName, $newValues, $row) === 0) {
+                    throw new DBFakerException("Row has not been updated $tableName - " . var_export($newValues, true) . ' - ' . var_export($row, true));
                 };
                 $this->log->info("Step 3.3 : updated $i of $count for $tableName");
                 $i++;
@@ -471,10 +471,10 @@ 
     private function updateExtensionContraints(array $extensionConstraints) : array
     {
         $handledFKColumns = [];
-        foreach ($extensionConstraints as $fk){
+        foreach ($extensionConstraints as $fk) {
             $localTableName = $fk->getLocalTable()->getQuotedName($this->connection->getDatabasePlatform());
             $stmt = $this->connection->query('SELECT * FROM ' . $localTableName);
-            $count = $this->connection->fetchColumn('SELECT count(*) FROM ' .$localTableName);
+            $count = $this->connection->fetchColumn('SELECT count(*) FROM ' . $localTableName);
             $i = 1;
             while ($row = $stmt->fetch()) {
                 $newValues = [];
@@ -486,8 +486,8 @@ 
                     $newValues[$localColumn] = $fkValueGenerator();
                 }
                 $row = $this->stripUnselectableColumns($fk->getLocalTable(), $row);
-                if ($this->connection->update($localTableName, $newValues, $row) === 0){
-                    throw new DBFakerException("Row has not been updated $localTableName - ". var_export($newValues,true) . ' - ' . var_export($row, true));
+                if ($this->connection->update($localTableName, $newValues, $row) === 0) {
+                    throw new DBFakerException("Row has not been updated $localTableName - " . var_export($newValues, true) . ' - ' . var_export($row, true));
                 };
                 $this->log->info("Updated $i of $count for $localTableName");
                 $i++;
@@ -506,7 +506,7 @@ 
      */
     private function getCompoundColumnGenerator(Table $table, Index $index, int $count): CompoundColumnGenerator
     {
-        if (!isset($this->compoundColumnGenerators[$table->getName() . "." . $index->getName()])){
+        if (!isset($this->compoundColumnGenerators[$table->getName() . "." . $index->getName()])) {
             $compoundGenerator = new CompoundColumnGenerator($table, $index, $this->schemaHelper, $this, $this->schemaManager, $this->fakerManagerHelper, $count);
             $this->compoundColumnGenerators[$table->getName() . '.' . $index->getName()] = $compoundGenerator;
         }
@@ -547,7 +547,7 @@ 
         return array_filter($row, function(string $columnName) use ($table) {
             return !\in_array($table->getColumn($columnName)->getType()->getName(), [
                 Type::BINARY, Type::JSON, Type::JSON_ARRAY, Type::SIMPLE_ARRAY, Type::TARRAY, Type::BLOB, Type::JSON, Type::OBJECT
-            ],true);
+            ], true);
         }, ARRAY_FILTER_USE_KEY);
     }
 
@@ -560,9 +560,9 @@ 
         $this->log->info('Step 2.1 : store extension constraints ...');
         $extensionConstraints = [];
         $tables = $this->schemaManager->listTables();
-        foreach ($tables as $table){
-            foreach ($table->getForeignKeys() as $fk){
-                if ($this->schemaHelper->isExtendingKey($fk)){
+        foreach ($tables as $table) {
+            foreach ($table->getForeignKeys() as $fk) {
+                if ($this->schemaHelper->isExtendingKey($fk)) {
                     $extensionConstraints[] = $fk;
                 }
             }