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/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 +3 added lines, -3 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'],
-                       'dtd_identifier' => $parameter['dtd_identifier']];
+                        'description'    => $parameter['description'],
+                        'php_type'       => $parameter['php_type'],
+                        'dtd_identifier' => $parameter['dtd_identifier']];
     }
 
     $this->enhancePhpDocBlockParameters($parameters);

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/MySqlMetaDataLayer.php

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

Indentation +9 added lines, -9 removed lines

@@ -543,9 +543,9 @@ 
 where  TABLE_SCHEMA = ifnull(%s, database())
 and    TABLE_NAME   = %s
 and    COLUMN_NAME  = %s',
-                   $this->dl->quoteString($schemaName),
-                   $this->dl->quoteString($tableName),
-                   $this->dl->quoteString($columnName));
+                    $this->dl->quoteString($schemaName),
+                    $this->dl->quoteString($tableName),
+                    $this->dl->quoteString($columnName));
 
     return $this->executeRow1($sql);
   }
@@ -574,8 +574,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);
   }
@@ -596,8 +596,8 @@ 
     $sql = sprintf('
 show index from `%s`.`%s`
 where Key_name = \'PRIMARY\'',
-                   $schemaName,
-                   $tableName);
+                    $schemaName,
+                    $tableName);
 
     return $this->executeRows($sql);
   }
@@ -618,8 +618,8 @@ 
     $sql = sprintf('
 show index from `%s`.`%s`
 where Non_unique = 0',
-                   $schemaName,
-                   $tableName);
+                    $schemaName,
+                    $tableName);
 
     return $this->executeRows($sql);
   }

src/Backend/MySqlRoutineLoaderWorker.php

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']);
     });
 

Indentation +6 added lines, -6 removed lines

@@ -189,7 +189,7 @@ 
       }
 
       $this->io->error(sprintf("The following source files would result wrapper methods with equal name '%s'",
-                               $method));
+                                $method));
       $this->io->listing($tmp);
     }
 
@@ -225,8 +225,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']);
       }
@@ -585,9 +585,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
           {

Spacing +3 added lines, -3 removed lines

@@ -304,7 +304,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']];
@@ -393,7 +393,7 @@ 
   {
     $this->io->writeln('');
 
-    usort($this->sources, function ($a, $b) {
+    usort($this->sources, function($a, $b) {
       return strcmp($a['routine_name'], $b['routine_name']);
     });
 
@@ -473,7 +473,7 @@ 
 
     $size = $this->characterSets[$key]['maxlen'];
 
-    return (int)floor(self::MAX_COLUMN_SIZE / $size);
+    return (int) floor(self::MAX_COLUMN_SIZE / $size);
   }
 
   //--------------------------------------------------------------------------------------------------------------------

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'],

src/Helper/RoutineParametersHelper.php

Indentation +9 added lines, -9 removed lines

@@ -95,9 +95,9 @@ 
     foreach ($this->parameters as $parameter)
     {
       $parameters[] = ['parameter_name' => $parameter['parameter_name'],
-                       'php_type'       => DataTypeHelper::columnTypeToPhpTypeHinting($parameter).'|null',
-                       'dtd_identifier' => $parameter['dtd_identifier'],
-                       'description'    => $lookup[($parameter['parameter_name'])] ?? []];
+                        'php_type'       => DataTypeHelper::columnTypeToPhpTypeHinting($parameter).'|null',
+                        'dtd_identifier' => $parameter['dtd_identifier'],
+                        'description'    => $lookup[($parameter['parameter_name'])] ?? []];
     }
 
     return $parameters;
@@ -201,8 +201,8 @@ 
         if ($n!==1)
         {
           throw new RoutineLoaderException('Unable to parse data type description %s of parameter %s.',
-                                           $parameter['dtd_identifier'],
-                                           $parameter['parameter_name']);
+                                            $parameter['dtd_identifier'],
+                                            $parameter['parameter_name']);
         }
 
         $schemaName = $matches['schema'] ?? null;
@@ -249,10 +249,10 @@ 
       }
 
       $this->parametersAddendum[$parameterName] = ['name'      => $parameterName,
-                                                   'data_type' => $dataType,
-                                                   'delimiter' => $delimiter,
-                                                   'enclosure' => $enclosure,
-                                                   'escape'    => $escape];
+                                                    'data_type' => $dataType,
+                                                    'delimiter' => $delimiter,
+                                                    'enclosure' => $enclosure,
+                                                    'escape'    => $escape];
     }
   }