DatabaseStratum / php-stratum-mysql

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/Exception/MySqlQueryErrorException.php

Indentation +3 added lines, -3 removed lines

@@ -98,9 +98,9 @@
   protected function composerMessage(): array
   {
     return array_merge($this->splitIntoTwoColumns('MySQL Errno', (string)$this->errno),
-                       $this->splitIntoTwoColumns('Error', $this->error),
-                       $this->splitIntoTwoColumns('Query', $this->query),
-                       $this->splitIntoTwoColumns('Method', $this->method));
+                        $this->splitIntoTwoColumns('Error', $this->error),
+                        $this->splitIntoTwoColumns('Query', $this->query),
+                        $this->splitIntoTwoColumns('Method', $this->method));
   }
 
   //--------------------------------------------------------------------------------------------------------------------

Spacing +1 added lines, -1 removed lines

@@ -97,7 +97,7 @@
    */
   protected function composerMessage(): array
   {
-    return array_merge($this->splitIntoTwoColumns('MySQL Errno', (string)$this->errno),
+    return array_merge($this->splitIntoTwoColumns('MySQL Errno', (string) $this->errno),
                        $this->splitIntoTwoColumns('Error', $this->error),
                        $this->splitIntoTwoColumns('Query', $this->query),
                        $this->splitIntoTwoColumns('Method', $this->method));

src/Exception/MySqlDataLayerException.php

Indentation +2 added lines, -2 removed lines

@@ -88,8 +88,8 @@
   protected function composerMessage(): array
   {
     return array_merge($this->splitIntoTwoColumns('MySQL Errno', (string)$this->errno),
-                       $this->splitIntoTwoColumns('Error', $this->error),
-                       $this->splitIntoTwoColumns('Method', $this->method));
+                        $this->splitIntoTwoColumns('Error', $this->error),
+                        $this->splitIntoTwoColumns('Method', $this->method));
   }
 
   //--------------------------------------------------------------------------------------------------------------------

Spacing +1 added lines, -1 removed lines

@@ -87,7 +87,7 @@
    */
   protected function composerMessage(): array
   {
-    return array_merge($this->splitIntoTwoColumns('MySQL Errno', (string)$this->errno),
+    return array_merge($this->splitIntoTwoColumns('MySQL Errno', (string) $this->errno),
                        $this->splitIntoTwoColumns('Error', $this->error),
                        $this->splitIntoTwoColumns('Method', $this->method));
   }

src/MySqlDataLayer.php

Indentation +1 added lines, -1 removed lines

@@ -1035,7 +1035,7 @@
     if ($this->logQueries)
     {
       $this->queryLog[] = ['query' => $query,
-                           'time'  => microtime(true) - $time0];
+                            'time'  => microtime(true) - $time0];
     }
   }
 

Spacing +16 added lines, -16 removed lines

@@ -326,11 +326,11 @@ 
           $line = '';
           foreach ($row as $i => $field)
           {
-            if ($i>0)
+            if ($i > 0)
             {
               $line .= ' ';
             }
-            $line .= str_pad((string)$field, $fields[$i]->max_length);
+            $line .= str_pad((string) $field, $fields[$i]->max_length);
           }
           echo date('Y-m-d H:i:s'), ' ', $line, "\n";
           $n++;
@@ -703,13 +703,13 @@ 
       $query            = "show variables like 'max_allowed_packet'";
       $maxAllowedPacket = $this->executeRow1($query);
 
-      $this->maxAllowedPacket = (int)$maxAllowedPacket['Value'];
+      $this->maxAllowedPacket = (int) $maxAllowedPacket['Value'];
 
       // Note: When setting $chunkSize equal to $maxAllowedPacket it is not possible to transmit a LOB
       // 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 $this->maxAllowedPacket;
@@ -791,7 +791,7 @@ 
    *
    * @return string
    */
-  public function quoteDecimal(int|float|string|null $value): string
+  public function quoteDecimal(int | float | string | null $value): string
   {
     if ($value===null || $value==='')
     {
@@ -800,7 +800,7 @@ 
 
     if (is_int($value) || is_float($value))
     {
-      return (string)$value;
+      return (string) $value;
     }
 
     return "'".$this->mysqli->real_escape_string($value)."'";
@@ -821,7 +821,7 @@ 
       return 'null';
     }
 
-    return (string)$value;
+    return (string) $value;
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -839,7 +839,7 @@ 
       return 'null';
     }
 
-    return (string)$value;
+    return (string) $value;
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -856,7 +856,7 @@ 
    *
    * @throws LogicException
    */
-  public function quoteListOfInt(array|string|null $list, string $delimiter, string $enclosure, string $escape): string
+  public function quoteListOfInt(array | string | null $list, string $delimiter, string $enclosure, string $escape): string
   {
     if ($list===null || $list==='' || $list===[])
     {
@@ -1130,7 +1130,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)
@@ -1173,13 +1173,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.'|';
     }
@@ -1198,7 +1198,7 @@ 
    */
   private function executeTableShowTableColumn(array $column, mixed $value): void
   {
-    $spaces = str_repeat(' ', max($column['length'] - mb_strlen((string)$value), 0));
+    $spaces = str_repeat(' ', max($column['length'] - mb_strlen((string) $value), 0));
 
     switch ($column['type'])
     {

src/Wrapper/MysqlWrapper.php

Spacing +1 added lines, -1 removed lines

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

src/Loader/MySqlRoutineLoader.php

Indentation +1 added lines, -1 removed lines

@@ -216,7 +216,7 @@
     if (!empty($context->oldRdbmsMetadata))
     {
       $this->dl->dropRoutine($context->oldRdbmsMetadata['routine_type'],
-                             $context->oldRdbmsMetadata['routine_name']);
+                              $context->oldRdbmsMetadata['routine_name']);
     }
   }
 

Spacing +1 added lines, -1 removed lines

@@ -364,7 +364,7 @@
       $key1 = $this->findFirstMatchingLine($context, '/^\s*(as|is)\s*$/i');
       $key2 = $this->findFirstMatchingLine($context, '/^\s*begin\s*$/i');
 
-      if ($key1!==null && $key2!==null && $key1<$key2)
+      if ($key1!==null && $key2!==null && $key1 < $key2)
       {
         $this->syntax = self::PL_SQL_SYNTAX;
       }

src/Loader/Helper/SqlModeHelper.php

Spacing +1 added lines, -1 removed lines

@@ -91,7 +91,7 @@
     if ($this->currentSqlMode!==$this->canonicalSqlModeWithOracle)
     {
       $this->dl->setSqlMode($this->canonicalSqlModeWithOracle);
-      $this->currentSqlMode = (string)$this->canonicalSqlModeWithOracle;
+      $this->currentSqlMode = (string) $this->canonicalSqlModeWithOracle;
     }
   }
 

src/Loader/Helper/MySqlDataTypeHelper.php

Spacing +1 added lines, -1 removed lines

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

src/Loader/Helper/RoutineParametersHelper.php

Indentation +7 added lines, -7 removed lines

@@ -133,8 +133,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;
@@ -170,7 +170,7 @@ 
       if ($n!==1)
       {
         throw new RoutineLoaderException('Expected: @paramAddendum <name> <type_of_list> <delimiter> <enclosure> <escape>. Found %s',
-                                         $tag);
+                                          $tag);
       }
 
       $parameterName = $matches['name'];
@@ -180,10 +180,10 @@ 
       }
 
       $this->parametersAddendum[$parameterName] = ['name'      => $parameterName,
-                                                   'data_type' => $matches['type'],
-                                                   'delimiter' => $matches['delimiter'],
-                                                   'enclosure' => $matches['enclosure'],
-                                                   'escape'    => $matches['escape']];
+                                                    'data_type' => $matches['type'],
+                                                    'delimiter' => $matches['delimiter'],
+                                                    'enclosure' => $matches['enclosure'],
+                                                    'escape'    => $matches['escape']];
     }
   }