DatabaseStratum / php-stratum-mysql

src/MySqlDataLayer.php

Indentation +1 added lines, -1 removed lines

@@ -1000,7 +1000,7 @@
       if (!$success) throw $this->queryError('mysqli::real_query', $query);
 
       $this->queryLog[] = ['query' => $query,
-                           'time'  => microtime(true) - $time0];
+                            'time'  => microtime(true) - $time0];
     }
     else
     {

Spacing +14 added lines, -14 removed lines

@@ -302,8 +302,8 @@ 
           $line = '';
           foreach ($row as $i => $field)
           {
-            if ($i>0) $line .= ' ';
-            $line .= str_pad((string)$field, $fields[$i]->max_length);
+            if ($i > 0) $line .= ' ';
+            $line .= str_pad((string) $field, $fields[$i]->max_length);
           }
           echo date('Y-m-d H:i:s'), ' ', $line, "\n";
           $n++;
@@ -640,10 +640,10 @@ 
       // with size $maxAllowedPacket bytes (but only $maxAllowedPacket - 8 bytes). But when setting the size of
       // $chunkSize less than $maxAllowedPacket than it is possible to transmit a LOB with size
       // $maxAllowedPacket bytes.
-      $this->chunkSize = (int)min($this->maxAllowedPacket - 8, 1024 * 1024);
+      $this->chunkSize = (int) min($this->maxAllowedPacket - 8, 1024 * 1024);
     }
 
-    return (int)$this->maxAllowedPacket;
+    return (int) $this->maxAllowedPacket;
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -723,7 +723,7 @@ 
   {
     if ($value===null || $value==='') return 'null';
 
-    if (is_int($value) || is_float($value)) return (string)$value;
+    if (is_int($value) || is_float($value)) return (string) $value;
 
     return "'".$this->mysqli->real_escape_string($value)."'";
   }
@@ -740,7 +740,7 @@ 
   {
     if ($value===null) return 'null';
 
-    return (string)$value;
+    return (string) $value;
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -755,7 +755,7 @@ 
   {
     if ($value===null) return 'null';
 
-    return (string)$value;
+    return (string) $value;
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -1027,7 +1027,7 @@ 
     {
       $n = strlen($data);
       $p = 0;
-      while ($p<$n)
+      while ($p < $n)
       {
         $success = @$statement->send_long_data($paramNr, substr($data, $p, $this->chunkSize));
         if (!$success) throw $this->dataLayerError('mysqli_stmt::send_long_data');
@@ -1067,13 +1067,13 @@ 
     foreach ($columns as $column)
     {
       $separator .= str_repeat('-', $column['length'] + 2).'+';
-      $spaces    = ($column['length'] + 2) - mb_strlen((string)$column['header']);
+      $spaces = ($column['length'] + 2) - mb_strlen((string) $column['header']);
 
-      $spacesLeft  = (int)floor($spaces / 2);
-      $spacesRight = (int)ceil($spaces / 2);
+      $spacesLeft  = (int) floor($spaces / 2);
+      $spacesRight = (int) ceil($spaces / 2);
 
-      $fillerLeft  = ($spacesLeft>0) ? str_repeat(' ', $spacesLeft) : '';
-      $fillerRight = ($spacesRight>0) ? str_repeat(' ', $spacesRight) : '';
+      $fillerLeft  = ($spacesLeft > 0) ? str_repeat(' ', $spacesLeft) : '';
+      $fillerRight = ($spacesRight > 0) ? str_repeat(' ', $spacesRight) : '';
 
       $header .= $fillerLeft.$column['header'].$fillerRight.'|';
     }
@@ -1092,7 +1092,7 @@ 
    */
   private function executeTableShowTableColumn(array $column, $value): void
   {
-    $spaces = str_repeat(' ', $column['length'] - mb_strlen((string)$value));
+    $spaces = str_repeat(' ', $column['length'] - mb_strlen((string) $value));
 
     switch ($column['type'])
     {

src/MySqlMetaDataLayer.php

Indentation +6 added lines, -6 removed lines

@@ -545,8 +545,8 @@ 
 where  TABLE_SCHEMA = %s
 and    TABLE_NAME   = %s
 order by ORDINAL_POSITION',
-                   $this->dl->quoteString($schemaName),
-                   $this->dl->quoteString($tableName));
+                    $this->dl->quoteString($schemaName),
+                    $this->dl->quoteString($tableName));
 
     return $this->executeRows($sql);
   }
@@ -567,8 +567,8 @@ 
     $sql = sprintf('
 show index from `%s`.`%s`
 where Key_name = \'PRIMARY\'',
-                   $schemaName,
-                   $tableName);
+                    $schemaName,
+                    $tableName);
 
     return $this->executeRows($sql);
   }
@@ -589,8 +589,8 @@ 
     $sql = sprintf('
 show index from `%s`.`%s`
 where Non_unique = 0',
-                   $schemaName,
-                   $tableName);
+                    $schemaName,
+                    $tableName);
 
     return $this->executeRows($sql);
   }

Spacing +1 added lines, -1 removed lines

@@ -400,7 +400,7 @@
   {
     $sql = 'select @@sql_mode';
 
-    return (string)$this->executeSingleton1($sql);
+    return (string) $this->executeSingleton1($sql);
   }
 
   //--------------------------------------------------------------------------------------------------------------------

src/Wrapper/FunctionWrapper.php

Indentation +4 added lines, -4 removed lines

@@ -46,14 +46,14 @@
     if ($this->routine['return']=='bool')
     {
       $this->codeStore->append(sprintf("return !empty(\$this->executeSingleton0('select %s(%s)'));",
-                                       $this->routine['routine_name'],
-                                       $this->getRoutineArgs()));
+                                        $this->routine['routine_name'],
+                                        $this->getRoutineArgs()));
     }
     else
     {
       $this->codeStore->append(sprintf("return \$this->executeSingleton0('select %s(%s)');",
-                                       $this->routine['routine_name'],
-                                       $this->getRoutineArgs()));
+                                        $this->routine['routine_name'],
+                                        $this->getRoutineArgs()));
     }
   }
 

src/Wrapper/Wrapper.php

Spacing +1 added lines, -1 removed lines

@@ -264,7 +264,7 @@
       }
     }
 
-    if ($blobArgumentIndex>0)
+    if ($blobArgumentIndex > 0)
     {
       $this->codeStore->append('');
     }

Indentation +4 added lines, -4 removed lines

@@ -483,9 +483,9 @@ 
       $mangledName = $this->nameMangler->getParameterName($parameter['parameter_name']);
 
       $parameters[] = ['php_name'             => '$'.$mangledName,
-                       'description'          => $parameter['description'],
-                       'php_type'             => $parameter['php_type'],
-                       'data_type_descriptor' => $parameter['data_type_descriptor']];
+                        'description'          => $parameter['description'],
+                        'php_type'             => $parameter['php_type'],
+                        'data_type_descriptor' => $parameter['data_type_descriptor']];
     }
 
     $this->enhancePhpDocBlockParameters($parameters);
@@ -505,7 +505,7 @@ 
 
       // Generate phpDoc for the parameters of the wrapper method.
 
-       foreach ($parameters as $parameter)
+        foreach ($parameters as $parameter)
       {
         $format = sprintf(' * %%-%ds %%-%ds %%-%ds %%s', mb_strlen('@param'), $maxTypeLength, $maxNameLength);
 

Braces +1 added lines, -1 removed lines

@@ -506,7 +506,7 @@
       // Generate phpDoc for the parameters of the wrapper method.
 
        foreach ($parameters as $parameter)
-      {
+       {
         $format = sprintf(' * %%-%ds %%-%ds %%-%ds %%s', mb_strlen('@param'), $maxTypeLength, $maxNameLength);
 
         $lines = $parameter['description'];

src/Helper/DataTypeHelper.php

Spacing +1 added lines, -1 removed lines

@@ -97,7 +97,7 @@
 
       case 'decimal':
         $ret = $dataTypeInfo['numeric_precision'];
-        if ($dataTypeInfo['numeric_scale']>0) $ret += 1;
+        if ($dataTypeInfo['numeric_scale'] > 0) $ret += 1;
         break;
 
       case 'char':

src/Helper/Crud/BaseRoutine.php

Indentation +2 added lines, -2 removed lines

@@ -264,7 +264,7 @@ 
                                                     $this->tableName,
                                                     $column['column_name'],
                                                     '%type')),
-                                 false);
+                                  false);
       }
 
       if ($column!=end($this->tableColumns))
@@ -314,7 +314,7 @@ 
                                                     $this->tableName,
                                                     $column['column_name'],
                                                     '%type')),
-                                 false);
+                                  false);
       }
 
       if ($column!=end($columns))

Spacing +1 added lines, -1 removed lines

@@ -207,7 +207,7 @@
     $keys = $this->keyList();
     if (!empty($keys))
     {
-      if (sizeof($keys)>1 || !isset($keys['PRIMARY']))
+      if (sizeof($keys) > 1 || !isset($keys['PRIMARY']))
       {
         $this->codeStore->append(' * ', false);
         $this->codeStore->append(' * Possible keys:', false);

src/Backend/MySqlRoutineLoaderWorker.php

Indentation +7 added lines, -7 removed lines

@@ -195,7 +195,7 @@ 
       }
 
       $this->io->error(sprintf("The following source files would result wrapper methods with equal name '%s'",
-                               $method));
+                                $method));
       $this->io->listing($tmp);
     }
 
@@ -231,8 +231,8 @@ 
       if (!isset($lookup[$oldRoutine['routine_name']]))
       {
         $this->io->logInfo('Dropping %s <dbo>%s</dbo>',
-                           strtolower($oldRoutine['routine_type']),
-                           $oldRoutine['routine_name']);
+                            strtolower($oldRoutine['routine_type']),
+                            $oldRoutine['routine_name']);
 
         $this->dl->dropRoutine($oldRoutine['routine_type'], $oldRoutine['routine_name']);
       }
@@ -428,7 +428,7 @@ 
       catch (RoutineLoaderException $e)
       {
         $messages = [$e->getMessage(),
-                     sprintf("Failed to load file '%s'", $filename['path_name'])];
+                      sprintf("Failed to load file '%s'", $filename['path_name'])];
         $this->io->error($messages);
 
         $this->errorFilenames[] = $filename['path_name'];
@@ -615,9 +615,9 @@ 
           if ($max!==null)
           {
             $value = sprintf('%s(%d) character set %s',
-                             $column['data_type'],
-                             $max,
-                             $column['character_set_name']);
+                              $column['data_type'],
+                              $max,
+                              $column['character_set_name']);
           }
           else
           {

Braces +2 added lines, -1 removed lines

@@ -401,7 +401,8 @@
   {
     $this->io->writeln('');
 
-    usort($this->sources, function ($a, $b) {
+    usort($this->sources, function ($a, $b)
+    {
       return strcmp($a['routine_name'], $b['routine_name']);
     });
 

Spacing +4 added lines, -4 removed lines

@@ -309,7 +309,7 @@ 
     $duplicatesMethods = [];
     foreach ($this->sources as $source)
     {
-      if (sizeof($lookup[$source['method_name']])>1)
+      if (sizeof($lookup[$source['method_name']]) > 1)
       {
         $duplicatesSources[$source['path_name']]   = $source;
         $duplicatesMethods[$source['method_name']] = $lookup[$source['method_name']];
@@ -400,7 +400,7 @@ 
   {
     $this->io->writeln('');
 
-    usort($this->sources, function ($a, $b) {
+    usort($this->sources, function($a, $b) {
       return strcmp($a['routine_name'], $b['routine_name']);
     });
 
@@ -480,7 +480,7 @@ 
 
     $size = $this->characterSets[$key]['maxlen'];
 
-    return (int)floor(self::MAX_COLUMN_SIZE / $size);
+    return (int) floor(self::MAX_COLUMN_SIZE / $size);
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -514,7 +514,7 @@ 
   {
     if (file_exists($this->phpStratumMetadataFilename))
     {
-      $this->phpStratumMetadata = (array)json_decode(file_get_contents($this->phpStratumMetadataFilename), true);
+      $this->phpStratumMetadata = (array) json_decode(file_get_contents($this->phpStratumMetadataFilename), true);
       if (json_last_error()!==JSON_ERROR_NONE)
       {
         throw new RuntimeException("Error decoding JSON: '%s'.", json_last_error_msg());

src/Helper/RoutineLoaderHelper.php

Indentation +7 added lines, -7 removed lines

@@ -563,9 +563,9 @@ 
     foreach ($this->parameters as $parameter)
     {
       $parameters[] = ['parameter_name'       => $parameter['parameter_name'],
-                       'php_type'             => DataTypeHelper::columnTypeToPhpTypeHinting($parameter).'|null',
-                       'data_type_descriptor' => $parameter['data_type_descriptor'],
-                       'description'          => $lookup[($parameter['parameter_name'])] ?? []];
+                        'php_type'             => DataTypeHelper::columnTypeToPhpTypeHinting($parameter).'|null',
+                        'data_type_descriptor' => $parameter['data_type_descriptor'],
+                        'description'          => $lookup[($parameter['parameter_name'])] ?? []];
     }
 
     return ['sort_description' => $this->docBlockReflection->getShortDescription(),
@@ -601,10 +601,10 @@ 
       }
 
       $this->extendedParameters[$parameterName] = ['name'      => $parameterName,
-                                                   'data_type' => $dataType,
-                                                   'delimiter' => $delimiter,
-                                                   'enclosure' => $enclosure,
-                                                   'escape'    => $escape];
+                                                    'data_type' => $dataType,
+                                                    'delimiter' => $delimiter,
+                                                    'enclosure' => $enclosure,
+                                                    'escape'    => $escape];
     }
   }
 

Spacing +5 added lines, -5 removed lines

@@ -473,7 +473,7 @@ 
     {
       throw new RoutineLoaderException('Tag @type not found in DocBlock.');
     }
-    elseif (count($tags)>1)
+    elseif (count($tags) > 1)
     {
       throw new RoutineLoaderException('Multiple @type tags found in DocBlock.');
     }
@@ -707,7 +707,7 @@ 
         $key1 = $this->findFirstMatchingLine('/^\s*(as|is)\s*$/i');
         $key2 = $this->findFirstMatchingLine('/^\s*begin\s*$/i');
 
-        if ($key1!==null && $key2!==null && $key1<$key2)
+        if ($key1!==null && $key2!==null && $key1 < $key2)
         {
           $this->syntax = self::PL_SQL_SYNTAX;
         }
@@ -856,11 +856,11 @@ 
     }
 
     $start = $this->findFirstMatchingLine('/^\s*\/\*\*\s*$/');
-    $end   = $this->findFirstMatchingLine('/^\s*\*\/\s*$/');;
-    if ($start!==null && $end!==null && $start<$end)
+    $end   = $this->findFirstMatchingLine('/^\s*\*\/\s*$/'); ;
+    if ($start!==null && $end!==null && $start < $end)
     {
       $lines    = array_slice($this->routineSourceCodeLines, $start, $end - $start + 1);
-      $docBlock = implode(PHP_EOL, (array)$lines);
+      $docBlock = implode(PHP_EOL, (array) $lines);
     }
     else
     {

src/Backend/MysqlConstantWorker.php

Indentation +2 added lines, -2 removed lines

@@ -364,8 +364,8 @@
           if ($n==0)
           {
             throw new RuntimeException("Illegal format at line %d in file '%s'.",
-                                       $lineNumber,
-                                       $this->constantsFilename);
+                                        $lineNumber,
+                                        $this->constantsFilename);
           }
 
           if (isset($matches[6]))

Spacing +6 added lines, -6 removed lines

@@ -221,7 +221,7 @@ 
             if ($token[0]==T_WHITESPACE)
             {
               $line2 = $token[2];
-              if (substr_count($token[1], "\n")>1)
+              if (substr_count($token[1], "\n") > 1)
               {
                 // Whitespace contains new line: end doc block without constants.
                 $step = 4;
@@ -248,7 +248,7 @@ 
           {
             if ($token[0]==T_WHITESPACE)
             {
-              if (substr_count($token[1], "\n")<=1)
+              if (substr_count($token[1], "\n") <= 1)
               {
                 // Ignore whitespace.
                 $line3 = $token[2];
@@ -430,7 +430,7 @@ 
     foreach ($this->constants as $constant => $value)
     {
       $width1 = max(mb_strlen($constant), $width1);
-      $width2 = max(mb_strlen((string)$value), $width2);
+      $width2 = max(mb_strlen((string) $value), $width2);
     }
 
     $format = sprintf('  const %%-%ds = %%%dd;', $width1, $width2);
@@ -477,7 +477,7 @@ 
       foreach ($table as $column)
       {
         $width1 = max(mb_strlen($column['column_name']), $width1);
-        $width2 = max(mb_strlen((string)$column['length']), $width2);
+        $width2 = max(mb_strlen((string) $column['length']), $width2);
       }
 
       foreach ($table as $column)
@@ -486,7 +486,7 @@ 
         {
           if (isset($column['constant_name']))
           {
-            $format  = sprintf("%%s.%%-%ds %%%dd %%s\n", $width1, $width2);
+            $format = sprintf("%%s.%%-%ds %%%dd %%s\n", $width1, $width2);
             $content .= sprintf($format,
                                 $column['table_name'],
                                 $column['column_name'],
@@ -495,7 +495,7 @@ 
           }
           else
           {
-            $format  = sprintf("%%s.%%-%ds %%%dd\n", $width1, $width2);
+            $format = sprintf("%%s.%%-%ds %%%dd\n", $width1, $width2);
             $content .= sprintf($format,
                                 $column['table_name'],
                                 $column['column_name'],