thecodingmachine / DBFaker

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/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;

test.php

Spacing +4 added lines, -4 removed lines

@@ -19,11 +19,11 @@ 
 /* Don't hesitate to use the Faker package to generate random data,
    there is plenty of data types available (IBAN, address, country code, ...).
 */
-$dataFaker = \Faker\Factory::create();//you could pass the locale to generate localized data !
+$dataFaker = \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 :
 $generatorFinderBuilder->addGenerator(
-    new \DBFaker\Generators\Conditions\CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table,  \Doctrine\DBAL\Schema\Column $column){
+    new \DBFaker\Generators\Conditions\CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table, \Doctrine\DBAL\Schema\Column $column) {
         return $table->getName() == "address" && $column->getName() == "postal_code";
     }),
     function() use ($dataFaker){
@@ -33,7 +33,7 @@ 
 
 // all columns that end with "_email" or are named exactly "email" should be emails
 $generatorFinderBuilder->addGenerator(
-    new \DBFaker\Generators\Conditions\CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table,  \Doctrine\DBAL\Schema\Column $column){
+    new \DBFaker\Generators\Conditions\CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table, \Doctrine\DBAL\Schema\Column $column) {
         return preg_match("/([(.*_)|_|]|^)email$/", $column->getName()) === 1;
     }),
     function() use ($dataFaker){
@@ -49,7 +49,7 @@ 
     "community_spending" => 100,
     "cron_flag" => 10,
     "project" => 50,
-    "project_note" => 200 ,
+    "project_note" => 200,
     "project_steps" => 10,
     "project_tasks" => 35,
     "request_hollidays" => 20,

tests/DBFakerTest.php

Spacing +4 added lines, -4 removed lines

@@ -60,7 +60,7 @@ 
             ->column("population")->bigInt()
             ->column("birthrate")->float()
             ->column("president_id")->references("persons")
-            ->column("population_density")->decimal(10,2)
+            ->column("population_density")->decimal(10, 2)
             ->column("summary")->text();
 
         $users->column("country_id")->references("countries");
@@ -103,11 +103,11 @@ 
         /* Don't hesitate to use the Faker package to generate random data,
            there is plenty of data types available (IBAN, address, country code, ...).
         */
-        $dataFaker = \Faker\Factory::create();//you could pass the locale to generate localized data !
+        $dataFaker = \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 :
         $generatorFinderBuilder->addGenerator(
-            new \DBFaker\Generators\Conditions\CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table,  \Doctrine\DBAL\Schema\Column $column){
+            new \DBFaker\Generators\Conditions\CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table, \Doctrine\DBAL\Schema\Column $column) {
                 return $table->getName() == "address" && $column->getName() == "postal_code";
             }),
             new SimpleGenerator(
@@ -119,7 +119,7 @@ 
 
         // all columns that end with "_email" or are named exactly "email" should be emails
         $generatorFinderBuilder->addGenerator(
-            new CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table,  \Doctrine\DBAL\Schema\Column $column){
+            new CallBackCondition(function(\Doctrine\DBAL\Schema\Table $table, \Doctrine\DBAL\Schema\Column $column) {
                 return preg_match("/([(.*_)|_|]|^)email$/", $column->getName()) === 1;
             }),
             new SimpleGenerator(

tests/Generators/Conditions/CheckTypeConditionTest.php

Spacing +1 added lines, -1 removed lines

@@ -8,7 +8,7 @@
 
 class CheckTypeConditionTest extends TestCase
 {
-    public function testCanApply(){
+    public function testCanApply() {
         $table = new Table("foo");
         $column = new Column("bar", Type::getType(Type::DECIMAL));
 

src/Helpers/NumericColumnLimitHelper.php

Spacing +5 added lines, -5 removed lines

@@ -34,10 +34,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;
@@ -50,7 +50,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;
@@ -76,7 +76,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;
             case Type::INTEGER:
@@ -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 +20 added lines, -20 removed lines

@@ -92,7 +92,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();
@@ -125,17 +125,17 @@ 
             foreach ($table->getColumns() as $column) {
                 //Check column isn't a PK : PK will be set automatically (NO UUID support)
                 if (array_search($column->getName(), $table->getPrimaryKeyColumns()) !== false) {
-                    if ($column->getAutoincrement()){
+                    if ($column->getAutoincrement()) {
                         $value = null;
-                    }else{
+                    }else {
                         return $this->getUniqueValue($table, $column);
                     }
                 }
                 //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->generatorFinder->findGenerator($table, $column)($column);
                     }
                 }
@@ -154,8 +154,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);
             }
@@ -167,8 +167,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);
             }
         }
@@ -183,14 +183,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();
@@ -198,9 +198,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;
@@ -213,8 +213,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;
             }
@@ -230,11 +230,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,
@@ -245,9 +245,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 +2 added lines, -2 removed lines

@@ -127,7 +127,7 @@ 
                 if (array_search($column->getName(), $table->getPrimaryKeyColumns()) !== false) {
                     if ($column->getAutoincrement()){
                         $value = null;
-                    }else{
+                    } else{
                         return $this->getUniqueValue($table, $column);
                     }
                 }
@@ -135,7 +135,7 @@ 
                 else {
                     if (!$column->getNotnull() && $this->nullProbabilityOccured()){
                         $value = null;
-                    }else{
+                    } else{
                         $value = $this->generatorFinder->findGenerator($table, $column)($column);
                     }
                 }

src/Generators/NumericGenerator.php

Spacing +3 added lines, -3 removed lines

@@ -25,7 +25,7 @@ 
         $inspector = new NumericColumnLimitHelper($column);
         $min = $inspector->getMinNumericValue();
         $max = $inspector->getMaxNumericValue();
-        switch ($column->getType()->getName()){
+        switch ($column->getType()->getName()) {
             case Type::BIGINT:
                 return $this->bigRandomNumber($min, $max);
             case Type::INTEGER:
@@ -35,12 +35,12 @@ 
             case Type::FLOAT:
                 return $this->faker->randomFloat(10, $min, $max);
             default:
-                throw new UnsupportedDataTypeException("Cannot generate numeric value for Type : '".$column->getType()->getName()."'");
+                throw new UnsupportedDataTypeException("Cannot generate numeric value for Type : '" . $column->getType()->getName() . "'");
         }
     }
 
     private function bigRandomNumber($min, $max) {
-        $difference   = bcadd(bcsub($max,$min),1);
+        $difference   = bcadd(bcsub($max, $min), 1);
         $rand_percent = bcdiv(mt_rand(), mt_getrandmax(), 8); // 0 - 1.0
         return bcadd($min, bcmul($difference, $rand_percent, 8), 0);
     }

src/Generators/BlobGenerator.php

Spacing +3 added lines, -3 removed lines

@@ -20,11 +20,11 @@
     public function __invoke(Column $column)
     {
         $files = glob($this->globExpression, GLOB_MARK);
-        $files = array_filter($files, function ($fileName){
+        $files = array_filter($files, function($fileName) {
             return strrpos($fileName, DIRECTORY_SEPARATOR) !== strlen($fileName) - 1;
         });
-        if (count($files) == 0){
-            throw new NoTestFilesFoundException("No files found for glob expression '".$this->globExpression."'");
+        if (count($files) == 0) {
+            throw new NoTestFilesFoundException("No files found for glob expression '" . $this->globExpression . "'");
         }
         $files = array_values($files);
         $chosenFile = $files[random_int(0, count($files) - 1)];