DatabaseStratum / php-stratum-mysql

src/MySqlDataLayer.php

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

Spacing +1 added lines, -1 removed lines

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

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

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

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

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

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

Spacing +4 added lines, -4 removed lines

@@ -469,7 +469,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.');
     }
@@ -631,7 +631,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;
       }
@@ -780,10 +780,10 @@ 
 
     $start = $this->findFirstMatchingLine('/^\s*\/\*\*\s*$/');
     $end   = $this->findFirstMatchingLine('/^\s*\*\/\s*$/');
-    if ($start!==null && $end!==null && $start<$end)
+    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
     {