Elimuswift / db-exporter

src/DbExporter/Commands/CopyToRemoteCommand.php

Spacing +8 added lines, -9 removed lines

@@ -36,7 +36,7 @@ 
             $this->line("\n");
             $this->info(ucfirst($type));
             foreach ($files as $file) {
-                $this->sectionMessage($type, $file.' uploaded.');
+                $this->sectionMessage($type, $file . ' uploaded.');
             }
         }
 
@@ -80,19 +80,18 @@ 
 
     protected function upload($what)
     {
-        $localPath = Config::get('db-exporter.export_path.'.$what);
+        $localPath = Config::get('db-exporter.export_path.' . $what);
         $dir = scandir($localPath);
-        $remotePath = Config::get('db-exporter.remote.'.$what);
+        $remotePath = Config::get('db-exporter.remote.' . $what);
         $this->line("\n");
         $this->info(ucfirst($what));
         // Reset file coounter
         static::$filesCount = 0;
         // Prepare the progress bar
-        array_walk($dir, function ($file) {
+        array_walk($dir, function($file) {
             if ($this->ignoredFile($file)) {
                 return;
-            }
-            ++static::$filesCount;
+            }++static::$filesCount;
         });
         $progress = $this->output->createProgressBar(static::$filesCount);
         foreach ($dir as $file) {
@@ -102,12 +101,12 @@ 
             }
 
             // Capture the uploaded files for displaying later
-            $this->uploadedFiles[$what][] = $remotePath.$file;
+            $this->uploadedFiles[$what][] = $remotePath . $file;
 
             // Copy the files
             Storage::disk($this->getDiskName())->put(
-                $remotePath.$file,
-                $localPath.'/'.$file
+                $remotePath . $file,
+                $localPath . '/' . $file
             );
             $progress->advance();
         }

src/DbExporter/Commands/GeneratorCommand.php

Doc Comments +9 added lines

@@ -32,6 +32,9 @@ 
 
 //end getDatabaseName()
 
+    /**
+     * @param string $title
+     */
     protected function blockMessage($title, $message, $style = 'info')
     {
         // Symfony style block messages
@@ -46,6 +49,9 @@ 
 
 //end blockMessage()
 
+    /**
+     * @param string $message
+     */
     protected function sectionMessage($title, $message)
     {
         $formatter = $this->getHelperSet()->get('formatter');
@@ -86,6 +92,9 @@ 
 
 //end getOptions()
 
+    /**
+     * @param string $action
+     */
     protected function fireAction($action, $database)
     {
         // Grab the options

src/DbExporter/Commands/MigrationsGeneratorCommand.php

Spacing +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
         $this->fireAction('migrate', $database);
 
         // Symfony style block messages
-        $this->blockMessage('Success!', 'Database migrations generated in: '.$this->handler->getMigrationsFilePath());
+        $this->blockMessage('Success!', 'Database migrations generated in: ' . $this->handler->getMigrationsFilePath());
     }
 
     //end fire()

src/DbExporter/Commands/SeedGeneratorCommand.php

Spacing +2 added lines, -2 removed lines

@@ -53,9 +53,9 @@
 
     private function getFilename()
     {
-        $filename = ucfirst(Str::camel($this->database)).'DatabaseSeeder';
+        $filename = ucfirst(Str::camel($this->database)) . 'DatabaseSeeder';
 
-        return Config::get('db-exporter.export_path.seeds')."/{$filename}.php";
+        return Config::get('db-exporter.export_path.seeds') . "/{$filename}.php";
     }
 
     //end getFilename()

src/DbExporter/DbExporter.php

Indentation +11 added lines, -11 removed lines

@@ -27,17 +27,17 @@
      * @var array
      **/
     protected $selects = [
-                          'column_name as Field',
-                          'column_type as Type',
-                          'is_nullable as Nullable',
-                          'column_key as Key',
-                          'column_default as Default',
-                          'extra as Extra',
-                          'data_type as Data_Type',
-                          'CHARACTER_MAXIMUM_LENGTH as Length',
-                          'NUMERIC_PRECISION as Precision',
-                          'NUMERIC_SCALE as Scale',
-                         ];
+                            'column_name as Field',
+                            'column_type as Type',
+                            'is_nullable as Nullable',
+                            'column_key as Key',
+                            'column_default as Default',
+                            'extra as Extra',
+                            'data_type as Data_Type',
+                            'CHARACTER_MAXIMUM_LENGTH as Length',
+                            'NUMERIC_PRECISION as Precision',
+                            'NUMERIC_SCALE as Scale',
+                            ];
     /**
      * Select fields from  constraints.
      *

Spacing +4 added lines, -4 removed lines

@@ -56,14 +56,14 @@ 
     {
         $pdo = DB::connection()->getPdo();
 
-        return $pdo->query('SELECT table_name FROM information_schema.tables WHERE table_schema="'.$this->database.'"');
+        return $pdo->query('SELECT table_name FROM information_schema.tables WHERE table_schema="' . $this->database . '"');
     }
 
     public function getTableIndexes($table)
     {
         $pdo = DB::connection()->getPdo();
 
-        return $pdo->query('SHOW INDEX FROM '.$this->database.'.'.$table.' WHERE Key_name != "PRIMARY"');
+        return $pdo->query('SHOW INDEX FROM ' . $this->database . '.' . $table . ' WHERE Key_name != "PRIMARY"');
     }
 
     /**
@@ -107,7 +107,7 @@ 
      */
     protected function getTableData($table)
     {
-        return DB::table($this->database.'.'.$table)->get();
+        return DB::table($this->database . '.' . $table)->get();
     }
 
     /**
@@ -122,7 +122,7 @@ 
         $directories = explode($del, $path);
         foreach ($directories as $directory) {
             if (!empty($directory)) {
-                $dir .= $del.$directory;
+                $dir .= $del . $directory;
             }
 
             if (!is_dir($dir)) {

src/DbExporter/DbMigrations.php

Spacing +13 added lines, -13 removed lines

@@ -108,8 +108,8 @@ 
         $schema = $this->compile();
         $absolutePath = Config::get('db-exporter.export_path.migrations');
         $this->makePath($absolutePath);
-        $this->filename = date('Y_m_d_His').'_create_'.$this->database.'_database.php';
-        static::$filePath = $absolutePath."/{$this->filename}";
+        $this->filename = date('Y_m_d_His') . '_create_' . $this->database . '_database.php';
+        static::$filePath = $absolutePath . "/{$this->filename}";
         file_put_contents(static::$filePath, $schema);
 
         return static::$filePath;
@@ -142,7 +142,7 @@ 
             }
 
             $down = "Schema::dropIfExists('{$value['table_name']}');";
-            $up = "Schema::create('{$value['table_name']}', function(Blueprint $"."table) {\n";
+            $up = "Schema::create('{$value['table_name']}', function(Blueprint $" . "table) {\n";
 
             $tableDescribes = $this->getTableDescribes($value['table_name']);
             // Loop over the tables fields
@@ -162,15 +162,15 @@ 
                     }
                 }
 
-                $up .= '                $'."table->{$this->methodName}('{$values->Field}'{$this->defaultLength}){$this->primaryKey}{$nullable}{$default}{$unsigned};\n";
+                $up .= '                $' . "table->{$this->methodName}('{$values->Field}'{$this->defaultLength}){$this->primaryKey}{$nullable}{$default}{$unsigned};\n";
                 $this->unsetData();
             }//end foreach
 
-            $tableIndexes = (array) $this->getTableIndexes($value['table_name']);
+            $tableIndexes = (array)$this->getTableIndexes($value['table_name']);
             if (!is_null($tableIndexes) && count($tableIndexes)) {
                 foreach ($tableIndexes as $index) {
                     if (Str::endsWith(@$index['Key_name'], '_index')) {
-                        $up .= '                $'."table->index('".$index['Column_name']."');\n";
+                        $up .= '                $' . "table->index('" . $index['Column_name'] . "');\n";
                     }
                 }
             }
@@ -183,13 +183,13 @@ 
             $tableConstraints = $this->getTableConstraints($value['table_name']);
             if (!is_null($tableConstraints) && $tableConstraints->count()) {
                 $Constraint = $ConstraintDown = "
-            Schema::table('{$value['table_name']}', function(Blueprint $"."table) {\n";
+            Schema::table('{$value['table_name']}', function(Blueprint $" . "table) {\n";
                 $tables = [];
                 foreach ($tableConstraints as $foreign) {
                     if (!in_array($foreign->Field, $tables)) {
                         $field = "{$foreign->Table}_{$foreign->Field}_foreign";
-                        $ConstraintDown .= '                $'."table->dropForeign('".$field."');\n";
-                        $Constraint .= '                $'."table->foreign('".$foreign->Field."')->references('".$foreign->References."')->on('".$foreign->ON."')->onDelete('".$foreign->onDelete."');\n";
+                        $ConstraintDown .= '                $' . "table->dropForeign('" . $field . "');\n";
+                        $Constraint .= '                $' . "table->foreign('" . $foreign->Field . "')->references('" . $foreign->References . "')->on('" . $foreign->ON . "')->onDelete('" . $foreign->onDelete . "');\n";
                         $tables[$foreign->Field] = $foreign->Field;
                     }
                 }
@@ -256,10 +256,10 @@ 
         }//end if
 
         // Grab the template
-        $template = File::get(__DIR__.'/stubs/migration.stub');
+        $template = File::get(__DIR__ . '/stubs/migration.stub');
 
         // Replace the classname
-        $template = str_replace('{{name}}', 'Create'.ucfirst(Str::camel($this->database)).'Database', $template);
+        $template = str_replace('{{name}}', 'Create' . ucfirst(Str::camel($this->database)) . 'Database', $template);
 
         // Replace the up and down values
         $template = str_replace('{{up}}', $upSchema, $template);
@@ -281,14 +281,14 @@ 
             $values = substr($column->Type, ($hasSize + 1), -1);
             switch ($type) {
                 case 'enum':
-                  $this->defaultLength = ', array('.$values.')';
+                  $this->defaultLength = ', array(' . $values . ')';
                     break;
                 case 'char':
                 case 'varchar':
                 case 'text':
                 case 'mediumtext':
                 case 'longtext':
-                    $this->defaultLength = ', '.$column->Length;
+                    $this->defaultLength = ', ' . $column->Length;
                 break;
                 case 'double':
                 case 'float':

src/DbExporter/DbSeeding.php

Doc Comments +1 added lines, -1 removed lines

@@ -128,7 +128,7 @@
     /**
      * Compile the current seedingStub with the seed template.
      *
-     * @return mixed
+     * @return string
      */
     protected function compile($table)
     {

Spacing +8 added lines, -8 removed lines

@@ -85,23 +85,23 @@ 
         // Get tables to ignore
         $config = config('db-exporter.seeds');
         $ignore_tables = collect([]);
-        if(!is_null($config) && isset($config['ignore_tables']) && !is_null($config['ignore_tables'])) {
+        if (!is_null($config) && isset($config['ignore_tables']) && !is_null($config['ignore_tables'])) {
             $ignore_tables = collect($config['ignore_tables']);
         }
 
         $show_tables = collect([]);
-        if(!is_null($config) && isset($config['use_tables']) && !is_null($config['use_tables'])) {
+        if (!is_null($config) && isset($config['use_tables']) && !is_null($config['use_tables'])) {
             $show_tables = collect($config['use_tables']);
         }
 
         // Loop over the tables
         foreach ($tables as $key => $value) 
         {
-            if($show_tables->count() > 0 && !$show_tables->contains($value['table_name'])) {
+            if ($show_tables->count() > 0 && !$show_tables->contains($value['table_name'])) {
                 continue;
             }
 
-            if($ignore_tables->contains($value['table_name'])) {
+            if ($ignore_tables->contains($value['table_name'])) {
                 continue;
             }
 
@@ -134,11 +134,11 @@ 
         ];";
 
             if ($this->hasTableData($tableData)) {
-                $stub = $insertStub.'
+                $stub = $insertStub . '
 
         foreach($data as $item) 
         {
-            $this->saveData("'.$tableName.'", $item);
+            $this->saveData("'.$tableName . '", $item);
         }'; 
                 $result[$tableName] = $stub; 
             }
@@ -172,13 +172,13 @@ 
 
     private function insertPropertyAndValue($prop, $value)
     {
-        if(strlen($prop) > 0) {
+        if (strlen($prop) > 0) {
             $prop = "'{$prop}'";
         } else {
             $prop = 'null';
         }
 
-        if(strlen($value) > 0) {
+        if (strlen($value) > 0) {
             $value = str_replace("'", "\'", $value);
             $value = "'{$value}'";
         } else {

src/DbExporter/SeederHelper.php

Indentation +31 added lines, -31 removed lines

@@ -7,42 +7,42 @@
     
     public function saveData($table, $item) 
     {
-    	// If have primary id
-    	if(isset($item['id'])) 
-    	{
-    		if(\DB::table($table)->where('id', $item['id'])->count() > 0) 
-    		{
-    			\DB::table($table)->where('id', $item['id'])->update($item);
-    		} 
-    		else 
-    		{
-    			\DB::table($table)->insert($item);
-    		}
+        // If have primary id
+        if(isset($item['id'])) 
+        {
+            if(\DB::table($table)->where('id', $item['id'])->count() > 0) 
+            {
+                \DB::table($table)->where('id', $item['id'])->update($item);
+            } 
+            else 
+            {
+                \DB::table($table)->insert($item);
+            }
         } 
         else 
         {
-        	$ids = collect($item)->filter(function($item, $key) {
-        		return str_contains($key, '_id');
-        	})->keys()->values();
+            $ids = collect($item)->filter(function($item, $key) {
+                return str_contains($key, '_id');
+            })->keys()->values();
 
-        	// If there isnt any column with _id, so check that every column matches
-        	if($ids->count() <= 0) {
-        		$ids = collect($item)->keys()->values();
-        	}
-        	$object = \DB::table($table);
-        	foreach ($ids as $id) {
-        		$object = $object->where($id, $item[$id]);
-        	}
+            // If there isnt any column with _id, so check that every column matches
+            if($ids->count() <= 0) {
+                $ids = collect($item)->keys()->values();
+            }
+            $object = \DB::table($table);
+            foreach ($ids as $id) {
+                $object = $object->where($id, $item[$id]);
+            }
 
-        	// save or update
-        	if($object->count() > 0) 
-    		{
-    			$object->update($item);
-    		} 
-    		else 
-    		{
-    			$object->insert($item);
-    		}
+            // save or update
+            if($object->count() > 0) 
+            {
+                $object->update($item);
+            } 
+            else 
+            {
+                $object->insert($item);
+            }
         	
         }
     }   

Spacing +4 added lines, -4 removed lines

@@ -8,9 +8,9 @@ 
     public function saveData($table, $item) 
     {
     	// If have primary id
-    	if(isset($item['id'])) 
+    	if (isset($item['id'])) 
     	{
-    		if(\DB::table($table)->where('id', $item['id'])->count() > 0) 
+    		if (\DB::table($table)->where('id', $item['id'])->count() > 0) 
     		{
     			\DB::table($table)->where('id', $item['id'])->update($item);
     		} 
@@ -26,7 +26,7 @@ 
         	})->keys()->values();
 
         	// If there isnt any column with _id, so check that every column matches
-        	if($ids->count() <= 0) {
+        	if ($ids->count() <= 0) {
         		$ids = collect($item)->keys()->values();
         	}
         	$object = \DB::table($table);
@@ -35,7 +35,7 @@ 
         	}
 
         	// save or update
-        	if($object->count() > 0) 
+        	if ($object->count() > 0) 
     		{
     			$object->update($item);
     		} 

Braces +3 added lines, -6 removed lines

@@ -13,13 +13,11 @@ 
     		if(\DB::table($table)->where('id', $item['id'])->count() > 0) 
     		{
     			\DB::table($table)->where('id', $item['id'])->update($item);
-    		} 
-    		else 
+    		} else 
     		{
     			\DB::table($table)->insert($item);
     		}
-        } 
-        else 
+        } else 
         {
         	$ids = collect($item)->filter(function($item, $key) {
         		return str_contains($key, '_id');
@@ -38,8 +36,7 @@ 
         	if($object->count() > 0) 
     		{
     			$object->update($item);
-    		} 
-    		else 
+    		} else 
     		{
     			$object->insert($item);
     		}