thecodingmachine / DBFaker

src/DBFaker.php

Spacing +18 added lines, -18 removed lines

@@ -90,7 +90,7 @@ 
      */
     public function fakeDB() : void
     {
-        set_time_limit(0);//Import may take a looooong time
+        set_time_limit(0); //Import may take a looooong time
         $this->generateFakeData();
         $this->dropForeignKeys();
         $this->insertFakeData();
@@ -127,9 +127,9 @@ 
                 }
                 //Other data will be Faked depending of column's type and attributes
                 else {
-                    if (!$column->getNotnull() && $this->nullProbabilityOccured()){
+                    if (!$column->getNotnull() && $this->nullProbabilityOccured()) {
                         $value = null;
-                    }else{
+                    }else {
                         $value = $this->generatorFactory->getGenerator($table, $column)($column);
                     }
                 }
@@ -148,8 +148,8 @@ 
     {
         $this->foreignKeyStore = [];
         $tables = $this->schemaManager->listTables();
-        foreach ($tables as $table){
-            foreach ($table->getForeignKeys() as $fk){
+        foreach ($tables as $table) {
+            foreach ($table->getForeignKeys() as $fk) {
                 $this->foreignKeyStore[$table->getName()][] = $fk;
                 $this->schemaManager->dropForeignKey($fk, $table);
             }
@@ -161,8 +161,8 @@ 
      */
     private function restoreForeignKeys() : void
     {
-        foreach ($this->foreignKeyStore as $tableName => $fks){
-            foreach ($fks as $fk){
+        foreach ($this->foreignKeyStore as $tableName => $fks) {
+            foreach ($fks as $fk) {
                 $this->schemaManager->createForeignKey($fk, $tableName);
             }
         }
@@ -177,14 +177,14 @@ 
     {
         $plateform = $this->connection->getDatabasePlatform();
         //1 - First insert data with no FKs, and null PKs. This will generate primary keys
-        foreach ($this->data as $tableName => $rows){
+        foreach ($this->data as $tableName => $rows) {
             $table = $this->schemaManager->listTableDetails($tableName);
 
             //initiate column types for insert
             $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();
@@ -192,9 +192,9 @@ 
             }
 
             //insert faked data
-            foreach ($rows as $row){
+            foreach ($rows as $row) {
                 $dbRow = [];
-                foreach ($row as $columnName => $value){
+                foreach ($row as $columnName => $value) {
                     $column = $table->getColumn($columnName);
                     $newVal = $column->getType()->convertToDatabaseValue($value, $plateform);
                     $dbRow[$columnName] = $newVal;
@@ -207,8 +207,8 @@ 
         }
 
         //2 - loop again on table to set FKs now that all PK have been loaded
-        foreach ($this->foreignKeyStore as $tableName => $fks){
-            if (array_search($tableName, array_keys($this->fakeTableRowNumbers)) === false){
+        foreach ($this->foreignKeyStore as $tableName => $fks) {
+            if (array_search($tableName, array_keys($this->fakeTableRowNumbers)) === false) {
                 //only update tables where data has been inserted
                 continue;
             }
@@ -224,11 +224,11 @@ 
              * foreign tables' PKRegistries will provide final values for local FKs columns
              */
             $fkInfo = [];
-            foreach ($fks as $fk){
+            foreach ($fks as $fk) {
                 $localColums = $fk->getLocalColumns();
                 $foreignColumns = $fk->getForeignColumns();
                 $foreignTable = $this->schemaManager->listTableDetails($fk->getForeignTableName());
-                foreach ($localColums as $index => $localColumn){
+                foreach ($localColums as $index => $localColumn) {
                     $foreignColumn = $foreignColumns[$index];
                     $fkInfo[$localColumn] = [
                         "table" => $foreignTable,
@@ -239,9 +239,9 @@ 
 
             //Get all the PKs in the table (ie all the lines to update), and update the FKs with random PK values
             $pkValues = $this->getPkRegistry($table)->loadValuesFromTable()->getAllValues();
-            foreach ($pkValues as $pkValue){
+            foreach ($pkValues as $pkValue) {
                 $newValues = [];
-                foreach ($fkInfo as $localColumn => $foreignData){
+                foreach ($fkInfo as $localColumn => $foreignData) {
                     $foreignTable = $foreignData["table"];
                     $foreignColumn = $foreignData["column"];
                     $fkPkRegistry = $this->getPkRegistry($foreignTable);

Braces +1 added lines, -1 removed lines

@@ -129,7 +129,7 @@
                 else {
                     if (!$column->getNotnull() && $this->nullProbabilityOccured()){
                         $value = null;
-                    }else{
+                    } else{
                         $value = $this->generatorFactory->getGenerator($table, $column)($column);
                     }
                 }

src/Helpers/PrimaryKeyRegistry.php

Spacing +4 added lines, -4 removed lines

@@ -51,9 +51,9 @@ 
         $this->values = [];
         $colNames = implode(",", $this->columns);
         $rows = $this->connection->query("SELECT $colNames FROM " . $this->table->getName())->fetchAll();
-        foreach ($rows as $row){
+        foreach ($rows as $row) {
             $pk = [];
-            foreach ($this->columns as $column){
+            foreach ($this->columns as $column) {
                 $pk[$column] = $row[$column];
             }
             $this->values[] = $pk;
@@ -71,7 +71,7 @@ 
     {
         $keys = array_keys($value);
         sort($keys);
-        if ($this->columns == $keys){
+        if ($this->columns == $keys) {
             throw new PrimaryKeyColumnMismatchException("PrimaryKeys do not match between PKStore and addValue");
         }
         $this->values[] = $value;
@@ -82,7 +82,7 @@ 
      */
     public function getRandomValue() : array
     {
-        return $this->values[random_int(0, count($this->values) -1)];
+        return $this->values[random_int(0, count($this->values) - 1)];
     }
 
     /**

src/Helpers/NumericColumnLimitHelper.php

Spacing +5 added lines, -5 removed lines

@@ -41,10 +41,10 @@ 
      */
     public function __construct(Column $column)
     {
-        if (array_search($column->getType()->getName(), self::$handledNumberTypes) === false){
+        if (array_search($column->getType()->getName(), self::$handledNumberTypes) === false) {
             throw new UnsupportedDataTypeException("Unsupported column type : " .
                 $column->getType()->getName() . "only " .
-                implode("', '", self::$handledNumberTypes) ." types are supported."
+                implode("', '", self::$handledNumberTypes) . " types are supported."
             );
         }
         $this->column = $column;
@@ -57,7 +57,7 @@ 
     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 : bcpow(2, 63);
                 break;
@@ -83,7 +83,7 @@ 
     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() ? bcpow(2, 64) : bcpow(2, 63) - 1;
                 break;
@@ -108,7 +108,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/Generators/ComplexObjectGenerator.php

Spacing +6 added lines, -6 removed lines

@@ -41,11 +41,11 @@ 
      */
     public function __invoke(Column $column)
     {
-        if ($this->depth === null){
+        if ($this->depth === null) {
             $this->depth = random_int(2, 5);
         }
         $object = $this->generateRandomObject($this->depth);
-        if ($this->toArray){
+        if ($this->toArray) {
             $object = json_decode(json_encode($object, JSON_OBJECT_AS_ARRAY), true);
         }
         return $object;
@@ -60,13 +60,13 @@ 
         $obj = new \stdClass();
         $nbProps = random_int(2, 5);
         $hasGoneDeeper = false;
-        for ($i = 0; $i < $nbProps; $i++){
+        for ($i = 0; $i < $nbProps; $i++) {
             $propName = $this->randomPropName();
-            $goDeeper = $depth != 0 && (random_int(0,10) > 7 || !$hasGoneDeeper);
-            if ($goDeeper){
+            $goDeeper = $depth != 0 && (random_int(0, 10) > 7 || !$hasGoneDeeper);
+            if ($goDeeper) {
                 $hasGoneDeeper = true;
                 $value = $this->generateRandomObject($depth - 1);
-            }else{
+            }else {
                 $value = $this->randomValue();
             }
             $obj->$propName = $value;

Braces +1 added lines, -1 removed lines

@@ -66,7 +66,7 @@
             if ($goDeeper){
                 $hasGoneDeeper = true;
                 $value = $this->generateRandomObject($depth - 1);
-            }else{
+            } else{
                 $value = $this->randomValue();
             }
             $obj->$propName = $value;

src/Generators/GeneratorFactory.php

Spacing +13 added lines, -13 removed lines

@@ -64,20 +64,20 @@ 
     {
         $generator = null;
         $identifier = $table->getName() . "." . $column->getName();
-        foreach ($this->dynamicGenerators as $dynamicGenerator){
-            if ($dynamicGenerator["conditionCallback"]($column)){
+        foreach ($this->dynamicGenerators as $dynamicGenerator) {
+            if ($dynamicGenerator["conditionCallback"]($column)) {
                 $generator = $dynamicGenerator["generator"];
             }
         }
-        if (!$generator){
+        if (!$generator) {
             if (isset($this->columnGenerators[$identifier])) {
                 $generator = $this->columnGenerators[$identifier];
-            }else{
+            }else {
                 $generator = $this->getDefaultGenerator($column->getType());
             }
         }
-        if ($generator === null){
-            throw new \RuntimeException("No colum, type nor default generator found for column '".$identifier."' of type '".$column->getType()->getName()."', you must provide it !");
+        if ($generator === null) {
+            throw new \RuntimeException("No colum, type nor default generator found for column '" . $identifier . "' of type '" . $column->getType()->getName() . "', you must provide it !");
         }
         return $generator;
     }
@@ -90,8 +90,8 @@ 
     {
         $faker = $this->faker;
         $type = $type->getName();
-        if (!isset($this->defaultGenerators[$type])){
-            switch ($type){
+        if (!isset($this->defaultGenerators[$type])) {
+            switch ($type) {
                 case Type::TARRAY :
                     $generator = new ComplexObjectGenerator($faker);
                     break;
@@ -128,11 +128,11 @@ 
                 case Type::GUID :
                     $generator = new SimpleGenerator(function() {
                         $chars = "0123456789abcdef";
-                        $groups = [8 ,4, 4, 4, 12];
+                        $groups = [8, 4, 4, 4, 12];
                         $guid = [];
-                        foreach ($groups as $length){
+                        foreach ($groups as $length) {
                             $sub = "";
-                            for ($i = 0; $i < $length; $i++){
+                            for ($i = 0; $i < $length; $i++) {
                                 $sub .= $chars[random_int(0, count($chars) - 1)];
                             }
                             $guid[] = $sub;
@@ -166,7 +166,7 @@ 
      */
     public function setGeneratorForColumn(string $table, string $column, callable $generator) : void
     {
-        if (!$generator instanceof FakeDataGeneratorInterface){
+        if (!$generator instanceof FakeDataGeneratorInterface) {
             $generator = new SimpleGenerator($generator);
         }
         $this->columnGenerators[$table . "." . $column] = $generator;
@@ -178,7 +178,7 @@ 
      */
     public function setGenerator(callable $conditionCallback, callable $generator) : void
     {
-        if (!$generator instanceof FakeDataGeneratorInterface){
+        if (!$generator instanceof FakeDataGeneratorInterface) {
             $generator = new SimpleGenerator($generator);
         }
         $this->dynamicGenerators[] = [

Braces +1 added lines, -1 removed lines

@@ -72,7 +72,7 @@
         if (!$generator){
             if (isset($this->columnGenerators[$identifier])) {
                 $generator = $this->columnGenerators[$identifier];
-            }else{
+            } else{
                 $generator = $this->getDefaultGenerator($column->getType());
             }
         }

test.php

Spacing +3 added lines, -3 removed lines

@@ -37,7 +37,7 @@ 
 /* Don't hesitate to use the Faker package to generate random data,
    there is plenty of data types available (IBAN, address, country code, ...).
 */
-$generator = \Faker\Factory::create();//you could pass the locale to generate localized data !
+$generator = \Faker\Factory::create(); //you could pass the locale to generate localized data !
 
 // address.postal_code column is a varchar, so default generated data will be text. Here we want a postal code :
 $generatorFactory->setGeneratorForColumn(
@@ -46,7 +46,7 @@ 
 
 // all columns that end with "_email" or are named exactly "email" should be emails
 $generatorFactory->setGenerator(
-    function(\Doctrine\DBAL\Schema\Column $column){
+    function(\Doctrine\DBAL\Schema\Column $column) {
         return preg_match("/([(.*_)|_|]|^)email$/", $column->getName()) === 1;
     }, function() use ($generator){
         return $generator->email;
@@ -61,7 +61,7 @@ 
     "community_spending" => 100,
     "cron_flag" => 10,
     "project" => 50,
-    "project_note" => 200 ,
+    "project_note" => 200,
     "project_steps" => 10,
     "project_tasks" => 35,
     "request_hollidays" => 20,