gggeek / db-3v4l

app/src/Command/UserList.php

Spacing +2 added lines, -2 removed lines

@@ -47,7 +47,7 @@ 
 
         $this->writeResults($results, $time);
 
-        return (int)$results['failed'];
+        return (int) $results['failed'];
     }
 
     /**
@@ -60,7 +60,7 @@ 
         return $this->executeSqlAction(
             $instanceList,
             'Listing of users',
-            function ($schemaManager, $instanceName) {
+            function($schemaManager, $instanceName) {
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getListUsersSqlAction();
             }

app/src/Command/SqlExecute.php

Spacing +12 added lines, -12 removed lines

@@ -81,13 +81,13 @@ 
 
             /// @todo inject more randomness in the username, by allowing more chars than bin2hex produces
 
-            $userName = 'db3v4l_' . substr(bin2hex(random_bytes(5)), 0, 9); // some mysql versions have a limitation of 16 chars for usernames
+            $userName = 'db3v4l_'.substr(bin2hex(random_bytes(5)), 0, 9); // some mysql versions have a limitation of 16 chars for usernames
             $password = bin2hex(random_bytes(16));
             //$dbName = bin2hex(random_bytes(31));
             $dbName = $userName; // $userName will be used as db name
 
             $tempDbSpecs = [];
-            foreach($instanceList as $instanceName => $instanceSpecs) {
+            foreach ($instanceList as $instanceName => $instanceSpecs) {
                 $tempDbSpecs[$instanceName] = [
                     'dbname' => $dbName,
                     'user' => $userName,
@@ -96,7 +96,7 @@ 
             }
 
             if (($charset = $input->getOption('charset')) != '') {
-                foreach($instanceList as $instanceName) {
+                foreach ($instanceList as $instanceName) {
                     $tempDbSpecs[$instanceName]['charset'] = $charset;
                 }
             }
@@ -118,7 +118,7 @@ 
             ];
 
             $dbConnectionSpecs = [];
-            foreach($instanceList as $instanceName => $instanceSpecs) {
+            foreach ($instanceList as $instanceName => $instanceSpecs) {
                 $dbConnectionSpecs[$instanceName] = array_merge($instanceSpecs, $dbConfig);
             }
         }
@@ -133,7 +133,7 @@ 
             if ($createDB) {
                 $results['failed'] += $creationResults['failed'];
 
-                foreach($instanceList as $instanceName  => $instanceSpecs) {
+                foreach ($instanceList as $instanceName  => $instanceSpecs) {
                     if (!isset($dbConnectionSpecs[$instanceName])) {
                         unset($instanceList[$instanceName]);
                     }
@@ -141,14 +141,14 @@ 
                 $this->dropDatabases($instanceList, $dbConnectionSpecs, true);
             }
         } else {
-            $results = ['succeeded' => 0,  'failed' => 0, 'data' => null];
+            $results = ['succeeded' => 0, 'failed' => 0, 'data' => null];
         }
 
         $time = microtime(true) - $start;
 
         $this->writeResults($results, $time);
 
-        return (int)$results['failed'];
+        return (int) $results['failed'];
     }
 
     /**
@@ -166,11 +166,11 @@ 
         return $this->executeSqlAction(
             $dbConnectionSpecs,
             'Execution of SQL',
-            function ($schemaManager, $instanceName) use ($sql, $filename) {
+            function($schemaManager, $instanceName) use ($sql, $filename) {
                 if ($sql != null) {
                     return new Command(
                         $sql,
-                        function ($output, $executor) {
+                        function($output, $executor) {
                             /** @var TimedExecutor $executor */
                             return array_merge(['stdout' => $output], $executor->getTimingData());
                         }
@@ -183,7 +183,7 @@ 
                     }
                     return new File(
                         $realFileName,
-                        function ($output, $executor) {
+                        function($output, $executor) {
                             /** @var TimedExecutor $executor */
                             return array_merge(['stdout' => $output], $executor->getTimingData());
                         }
@@ -218,13 +218,13 @@ 
             if (trim($line) !== '') {
                 if ($type === 'err') {
                     $this->writeErrorln(
-                        '[' . $processIndex . '][' . $pid . '] ' . trim($line),
+                        '['.$processIndex.']['.$pid.'] '.trim($line),
                         OutputInterface::VERBOSITY_VERBOSE,
                         OutputInterface::OUTPUT_RAW
                     );
                 } else {
                     $this->writeln(
-                        '[' . $processIndex . '][' . $pid . '] ' . trim($line),
+                        '['.$processIndex.']['.$pid.'] '.trim($line),
                         OutputInterface::VERBOSITY_VERBOSE,
                         OutputInterface::OUTPUT_RAW
                     );

app/src/Command/CollationList.php

Spacing +2 added lines, -2 removed lines

@@ -47,7 +47,7 @@ 
 
         $this->writeResults($results, $time);
 
-        return (int)$results['failed'];
+        return (int) $results['failed'];
     }
 
     /**
@@ -60,7 +60,7 @@ 
         return $this->executeSqlAction(
             $instanceList,
             'Listing of collations',
-            function ($schemaManager, $instanceName) {
+            function($schemaManager, $instanceName) {
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getListCollationsSqlAction();
             }

app/src/Command/DatabaseList.php

Spacing +2 added lines, -2 removed lines

@@ -47,7 +47,7 @@ 
 
         $this->writeResults($results, $time);
 
-        return (int)$results['failed'];
+        return (int) $results['failed'];
     }
 
     /**
@@ -60,7 +60,7 @@ 
         return $this->executeSqlAction(
             $instanceList,
             'Listing of databases',
-            function ($schemaManager, $instanceName) {
+            function($schemaManager, $instanceName) {
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getListDatabasesSqlAction();
             }

app/src/Command/UserDrop.php

Spacing +3 added lines, -3 removed lines

@@ -50,7 +50,7 @@ 
         }
 
         $userToDropSpecs = [];
-        foreach($instanceList as $instanceName => $instanceSpecs) {
+        foreach ($instanceList as $instanceName => $instanceSpecs) {
             $userToDropSpecs[$instanceName] = [
                 'user' => $userName
             ];
@@ -64,7 +64,7 @@ 
 
         $this->writeResults($results, $time);
 
-        return (int)$results['failed'];
+        return (int) $results['failed'];
     }
 
     /**
@@ -79,7 +79,7 @@ 
         return $this->executeSqlAction(
             $instanceList,
             'Dropping of user',
-            function ($schemaManager, $instanceName) use ($userToDropSpecs, $ifExists) {
+            function($schemaManager, $instanceName) use ($userToDropSpecs, $ifExists) {
                 $dbConnectionSpec = $userToDropSpecs[$instanceName];
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getDropUserSqlAction(

app/src/Command/DatabaseManagingCommand.php

Spacing +3 added lines, -3 removed lines

@@ -20,7 +20,7 @@ 
         $results = $this->executeSqlAction(
             $instanceList,
             'Creating new database & user',
-            function ($schemaManager, $instanceName) use ($dbSpecList) {
+            function($schemaManager, $instanceName) use ($dbSpecList) {
                 $dbConnectionSpec = $dbSpecList[$instanceName];
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getCreateDatabaseSqlAction(
@@ -33,7 +33,7 @@ 
         );
 
         $finalData = [];
-        foreach($results['data'] as $instanceName => $data) {
+        foreach ($results['data'] as $instanceName => $data) {
             $dbConnectionSpec = $dbSpecList[$instanceName];
             $finalData[$instanceName] = $instanceList[$instanceName];
             $finalData[$instanceName]['dbname'] = $dbConnectionSpec['dbname'];
@@ -64,7 +64,7 @@ 
         return $this->executeSqlAction(
             $instanceList,
             'Dropping of database & user',
-            function ($schemaManager, $instanceName) use ($dbSpecList, $ifExists) {
+            function($schemaManager, $instanceName) use ($dbSpecList, $ifExists) {
                 $dbConnectionSpec = $dbSpecList[$instanceName];
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getDropDatabaseSqlAction(

app/src/Command/SqlShell.php

Spacing +1 added lines, -1 removed lines

@@ -52,7 +52,7 @@
         }
         $executor = $this->executorFactory->createForkedExecutor($dbConnectionSpec, 'NativeClient', false);
 
-        if (! $executor instanceof ShellExecutor) {
+        if (!$executor instanceof ShellExecutor) {
             throw new \Exception("Can not start an interactive shell for databases of type '{$dbConnectionSpec['vendor']}'");
         }
 

app/src/Command/InstanceList.php

Spacing +4 added lines, -4 removed lines

@@ -37,7 +37,7 @@ 
         $result = $this->listInstances($instanceList);
 
         $extraResults = $this->listDatabasesVersion($instanceList)['data'];
-        foreach($result as $instanceName => $instanceDesc) {
+        foreach ($result as $instanceName => $instanceDesc) {
             if (isset($extraResults[$instanceName])) {
                 $result[$instanceName]['version'] = $extraResults[$instanceName];
             }
@@ -56,7 +56,7 @@ 
     protected function listInstances($instanceList)
     {
         $out = [];
-        foreach($instanceList as $instanceName => $connectionSpec) {
+        foreach ($instanceList as $instanceName => $connectionSpec) {
             //$connectionSpec = $this->dbConfigurationManager->getInstanceConfiguration($instanceName);
             $out[$instanceName] = [
                 'vendor' => $connectionSpec['vendor'],
@@ -71,7 +71,7 @@ 
         return $this->executeSqlAction(
             $instanceList,
             'Getting database version information',
-            function ($schemaManager, $instanceName) {
+            function($schemaManager, $instanceName) {
                 /** @var DatabaseSchemaManager $schemaManager */
                 return $schemaManager->getRetrieveVersionInfoSqlAction();
             }
@@ -101,7 +101,7 @@ 
             file_put_contents($this->outputFile, $data);
             $this->writeln("Results saved to file {$this->outputFile}");
         } else {
-            $this->writeln($data, OutputInterface::VERBOSITY_QUIET,  OutputInterface::OUTPUT_RAW);
+            $this->writeln($data, OutputInterface::VERBOSITY_QUIET, OutputInterface::OUTPUT_RAW);
         }
 
     }

app/src/Command/SQLExecutingCommand.php

Spacing +12 added lines, -12 removed lines

@@ -49,8 +49,8 @@ 
     protected function addCommonOptions()
     {
         $this
-            ->addOption('only-instances', 'o', InputOption::VALUE_REQUIRED|InputOption::VALUE_IS_ARRAY, 'Filter the database servers to run this command against. Usage of * and ? wildcards is allowed. To see all instances available, use `instance:list`', null)
-            ->addOption('except-instances', 'x', InputOption::VALUE_REQUIRED|InputOption::VALUE_IS_ARRAY, 'Filter the database servers to run this command against', null)
+            ->addOption('only-instances', 'o', InputOption::VALUE_REQUIRED | InputOption::VALUE_IS_ARRAY, 'Filter the database servers to run this command against. Usage of * and ? wildcards is allowed. To see all instances available, use `instance:list`', null)
+            ->addOption('except-instances', 'x', InputOption::VALUE_REQUIRED | InputOption::VALUE_IS_ARRAY, 'Filter the database servers to run this command against', null)
             ->addOption('output-type', null, InputOption::VALUE_REQUIRED, 'The format for the output: json, php, text or yml', self::DEFAULT_OUTPUT_FORMAT)
             ->addOption('output-file', null, InputOption::VALUE_REQUIRED, 'Save output to a file instead of writing it to stdout. NB: take care that dbconsole runs in a container, which has a different view of the filesystem. A good dir for output is ./shared')
             ->addOption('timeout', null, InputOption::VALUE_REQUIRED, 'The maximum time to wait for subprocess execution (secs)', self::DEFAULT_PROCESS_TIMEOUT)
@@ -77,7 +77,7 @@ 
         // On Debian, which we use by default, SF has troubles understanding that php was compiled with --enable-sigchild
         // We thus force it, but give end users an option to disable this
         // For more details, see comment 12 at https://bugs.launchpad.net/ubuntu/+source/php5/+bug/516061
-        if (! $input->getOption('dont-force-enabled-sigchild')) {
+        if (!$input->getOption('dont-force-enabled-sigchild')) {
             Process::forceSigchildEnabled(true);
         }
 
@@ -121,7 +121,7 @@ 
                     $sql = null;
                 } else {
                     // this is a coding error, not a sql execution error
-                    throw new \Exception("Unsupported action type: " . get_class($sqlAction));
+                    throw new \Exception("Unsupported action type: ".get_class($sqlAction));
                 }
                 $filterCallable = $sqlAction->getResultsFilterCallable();
 
@@ -132,7 +132,7 @@ 
                     $outputFilters[$instanceName] = $filterCallable;
 
                     if ($filename === null && !$sqlAction->isSingleStatement()) {
-                        $filename = tempnam(sys_get_temp_dir(), 'db3v4l_') . '.sql';
+                        $filename = tempnam(sys_get_temp_dir(), 'db3v4l_').'.sql';
                         file_put_contents($filename, $sql);
                         $tempSQLFileNames[] = $filename;
                     }
@@ -155,7 +155,7 @@ 
                         }
 
                         if ($this->outputFormat === 'text') {
-                            $this->writeln('Command line: ' . $process->getCommandLine(), OutputInterface::VERBOSITY_VERY_VERBOSE);
+                            $this->writeln('Command line: '.$process->getCommandLine(), OutputInterface::VERBOSITY_VERY_VERBOSE);
                         }
 
                         $process->setTimeout($this->processTimeout);
@@ -177,7 +177,7 @@ 
                     $succeeded++;
                 } catch (\Throwable $t) {
                     $failed++;
-                    $this->writeErrorln("\n<error>$actionName in instance '$instanceName' failed! Reason: " . $t->getMessage() . "</error>\n", OutputInterface::VERBOSITY_NORMAL);
+                    $this->writeErrorln("\n<error>$actionName in instance '$instanceName' failed! Reason: ".$t->getMessage()."</error>\n", OutputInterface::VERBOSITY_NORMAL);
                 }
             }
 
@@ -199,7 +199,7 @@ 
                                 //$result = null;
                                 $failed++;
                                 $succeeded--;
-                                $this->writeErrorln("\n<error>$actionName in instance '$instanceName' failed! Reason: " . $t->getMessage() . "</error>\n", OutputInterface::VERBOSITY_NORMAL);
+                                $this->writeErrorln("\n<error>$actionName in instance '$instanceName' failed! Reason: ".$t->getMessage()."</error>\n", OutputInterface::VERBOSITY_NORMAL);
                             }
                         }
                         $results[$instanceName] = $output;
@@ -210,14 +210,14 @@ 
                             'exitcode' => $process->getExitCode()
                         ];
                         $failed++;
-                        $this->writeErrorln("\n<error>$actionName in instance '$instanceName' failed! Reason: " . $process->getErrorOutput() . "</error>\n", OutputInterface::VERBOSITY_NORMAL);
+                        $this->writeErrorln("\n<error>$actionName in instance '$instanceName' failed! Reason: ".$process->getErrorOutput()."</error>\n", OutputInterface::VERBOSITY_NORMAL);
                     }
                 }
             }
 
         } finally {
             // make sure that we clean up temp files, as they might contain sensitive data
-            foreach($tempSQLFileNames as $tempSQLFileName) {
+            foreach ($tempSQLFileNames as $tempSQLFileName) {
                 unlink($tempSQLFileName);
             }
         }
@@ -266,11 +266,11 @@ 
         if ($this->outputFile != null) {
             file_put_contents($this->outputFile, $formattedResults);
         } else {
-            $this->writeln($formattedResults, OutputInterface::VERBOSITY_QUIET,  OutputInterface::OUTPUT_RAW);
+            $this->writeln($formattedResults, OutputInterface::VERBOSITY_QUIET, OutputInterface::OUTPUT_RAW);
         }
 
         if ($this->outputFormat === 'text' || $this->outputFile != null) {
-            $this->writeln($results['succeeded'] . ' succeeded, ' . $results['failed'] . ' failed');
+            $this->writeln($results['succeeded'].' succeeded, '.$results['failed'].' failed');
             if ($this->outputFile != null) {
                 $this->writeln("Results saved to file {$this->outputFile}");
             }