vakata / database

src/driver/sphinx/Statement.php

Spacing +5 added lines, -5 removed lines

@@ -40,23 +40,23 @@
                             break;
                         case 'array':
                             $par = implode(',', $par);
-                            $par = "'" . $this->lnk->escape_string($par) . "'";
+                            $par = "'".$this->lnk->escape_string($par)."'";
                             break;
                         case 'object':
                             $par = serialize($par);
-                            $par = "'" . $this->lnk->escape_string($par) . "'";
+                            $par = "'".$this->lnk->escape_string($par)."'";
                             break;
                         case 'resource':
                             if (is_resource($par) && get_resource_type($par) === 'stream') {
                                 $par = stream_get_contents($par);
-                                $par = "'" . $this->lnk->escape_string($par) . "'";
+                                $par = "'".$this->lnk->escape_string($par)."'";
                             } else {
                                 $par = serialize($par);
-                                $par = "'" . $this->lnk->escape_string($par) . "'";
+                                $par = "'".$this->lnk->escape_string($par)."'";
                             }
                             break;
                         default:
-                            $par = "'" . $this->lnk->escape_string((string)$par) . "'";
+                            $par = "'".$this->lnk->escape_string((string) $par)."'";
                             break;
                     }
                     $sql .= $par;

src/driver/odbc/Result.php

Spacing +1 added lines, -1 removed lines

@@ -78,7 +78,7 @@
     }
     public function next(): void
     {
-        $this->fetched ++;
+        $this->fetched++;
         $temp = \odbc_fetch_row($this->statement);
         if (!$temp) {
             $this->last = null;

src/driver/sqlite/Result.php

Spacing +2 added lines, -2 removed lines

@@ -62,8 +62,8 @@
     }
     public function next(): void
     {
-        $this->fetched ++;
-        $this->last = $this->statement->fetchArray(\SQLITE3_ASSOC)?:null;
+        $this->fetched++;
+        $this->last = $this->statement->fetchArray(\SQLITE3_ASSOC) ?: null;
     }
     public function valid(): bool
     {

src/driver/ibase/Result.php

Spacing +2 added lines, -2 removed lines

@@ -67,8 +67,8 @@
     }
     public function next(): void
     {
-        $this->fetched ++;
-        $this->last = \ibase_fetch_assoc($this->result, \IBASE_TEXT)?:null;
+        $this->fetched++;
+        $this->last = \ibase_fetch_assoc($this->result, \IBASE_TEXT) ?: null;
     }
     public function valid(): bool
     {

src/schema/Table.php

Spacing +9 added lines, -9 removed lines

@@ -79,10 +79,10 @@ 
      * @param  array|string        $column either a single column name or an array of column names
      * @return  static
      */
-    public function setPrimaryKey(array|string $column): static
+    public function setPrimaryKey(array | string $column): static
     {
         if (!is_array($column)) {
-            $column = [ $column ];
+            $column = [$column];
         }
         $this->data['primary'] = array_values($column);
         return $this;
@@ -109,7 +109,7 @@ 
      */
     public function getFullName(): string
     {
-        return ($this->data['schema'] ? $this->data['schema'] . '.' : '') . $this->data['name'];
+        return ($this->data['schema'] ? $this->data['schema'].'.' : '').$this->data['name'];
     }
     /**
      * Get a column definition
@@ -156,7 +156,7 @@ 
     public function hasOne(
         Table $toTable,
         string $name = null,
-        string|array|null $toTableColumn = null,
+        string | array | null $toTableColumn = null,
         string $sql = null,
         array $par = []
     ) : static {
@@ -184,7 +184,7 @@ 
         }
 
         if (!isset($name)) {
-            $name = $toTable->getName() . '_' . implode('_', array_keys($keymap));
+            $name = $toTable->getName().'_'.implode('_', array_keys($keymap));
         }
         $this->addRelation(new TableRelation(
             $name,
@@ -210,7 +210,7 @@ 
     public function hasMany(
         Table $toTable,
         string $name = null,
-        string|array|null $toTableColumn = null,
+        string | array | null $toTableColumn = null,
         ?string $sql = null,
         array $par = []
     ): static {
@@ -264,7 +264,7 @@ 
     public function belongsTo(
         Table $toTable,
         string $name = null,
-        string|array|null $localColumn = null,
+        string | array | null $localColumn = null,
         ?string $sql = null,
         array $par = []
     ): static {
@@ -319,8 +319,8 @@ 
         Table $toTable,
         Table $pivot,
         ?string $name = null,
-        string|array|null $toTableColumn = null,
-        string|array|null $localColumn = null
+        string | array | null $toTableColumn = null,
+        string | array | null $localColumn = null
     ): static {
         $pivotColumns = $pivot->getColumns();
 

src/driver/ibase/Driver.php

Spacing +1 added lines, -1 removed lines

@@ -71,7 +71,7 @@
         $this->softDetect($sql);
         $statement = \ibase_prepare($this->transaction !== null ? $this->transaction : $this->lnk, $sql);
         if ($statement === false) {
-            throw new DBException('Prepare error: ' . \ibase_errmsg());
+            throw new DBException('Prepare error: '.\ibase_errmsg());
         }
         return new Statement(
             $statement,

src/driver/oracle/Driver.php

Spacing +4 added lines, -4 removed lines

@@ -44,7 +44,7 @@ 
                 $this->query("ALTER SESSION SET time_zone = '".addslashes($timezone)."'");
             }
             if ($schema = $this->option('schema')) {
-                $this->query("ALTER SESSION SET CURRENT_SCHEMA = " . $schema);
+                $this->query("ALTER SESSION SET CURRENT_SCHEMA = ".$schema);
             }
         }
     }
@@ -81,11 +81,11 @@ 
         );
         if ($log) {
             $tm = microtime(true) - $tm;
-            if ($tm >= (float)$this->option('log_slow', 0)) {
+            if ($tm >= (float) $this->option('log_slow', 0)) {
                 @file_put_contents(
                     $log,
-                    '--' . date('Y-m-d H:i:s') . ' ' . sprintf('%01.6f', $tm) . "s\r\n" .
-                    $sql . "\r\n" .
+                    '--'.date('Y-m-d H:i:s').' '.sprintf('%01.6f', $tm)."s\r\n".
+                    $sql."\r\n".
                     "\r\n",
                     FILE_APPEND
                 );

src/driver/oracle/Result.php

Spacing +10 added lines, -10 removed lines

@@ -24,7 +24,7 @@ 
     }
     public function affected() : int
     {
-        return (int)\oci_num_rows($this->statement);
+        return (int) \oci_num_rows($this->statement);
     }
     public function insertID(string $sequence = null): mixed
     {
@@ -37,7 +37,7 @@ 
 
     public function count(): int
     {
-        return (int)\oci_num_rows($this->statement);
+        return (int) \oci_num_rows($this->statement);
     }
 
     public function key(): mixed
@@ -65,8 +65,8 @@ 
     }
     public function next(): void
     {
-        $this->fetched ++;
-        $this->last = \oci_fetch_array($this->statement, \OCI_ASSOC + \OCI_RETURN_NULLS + \OCI_RETURN_LOBS)?:null;
+        $this->fetched++;
+        $this->last = \oci_fetch_array($this->statement, \OCI_ASSOC +\OCI_RETURN_NULLS +\OCI_RETURN_LOBS) ?: null;
         if (is_array($this->last)) {
             $this->cast();
         }
@@ -78,23 +78,23 @@ 
     protected function cast(): void
     {
         if (!count($this->types)) {
-            foreach (array_keys($this->last??[]) as $k => $v) {
+            foreach (array_keys($this->last ?? []) as $k => $v) {
                 $this->types[$v] = \oci_field_type($this->statement, $k + 1);
                 if ($this->types[$v] === 'NUMBER') {
                     $scale = \oci_field_scale($this->statement, $k + 1);
                     $precision = \oci_field_precision($this->statement, $k + 1);
                     // true float
-                    if ((int)$scale === -127 && (int)$precision !== 0) {
+                    if ((int) $scale === -127 && (int) $precision !== 0) {
                         $this->types[$v] = 'FLOAT';
                     }
                     // TODO: decimal
-                    if ((int)$scale > 0) {
+                    if ((int) $scale > 0) {
                         $this->types[$v] = 'DECIMAL';
                     }
                 }
             }
         }
-        foreach ($this->last??[] as $k => $v) {
+        foreach ($this->last ?? [] as $k => $v) {
             if (!isset($this->types[$k])) {
                 continue;
             }
@@ -109,10 +109,10 @@ 
             }
             switch ($this->types[$k]) {
                 case 'NUMBER':
-                    $this->last[$k] = (int)$v;
+                    $this->last[$k] = (int) $v;
                     break;
                 case 'FLOAT':
-                    $this->last[$k] = (float)$v;
+                    $this->last[$k] = (float) $v;
                     break;
             }
         }

src/driver/postgre/Schema.php

Spacing +29 added lines, -29 removed lines

@@ -29,8 +29,8 @@ 
             $table = $temp[1];
         }
 
-        if (isset($tables[$schema . '.' . $table])) {
-            return $tables[$schema . '.' . $table];
+        if (isset($tables[$schema.'.'.$table])) {
+            return $tables[$schema.'.'.$table];
         }
 
         static $relationsT = null;
@@ -61,7 +61,7 @@ 
                         (kc.table_schema = ? OR ct.table_schema = ?) AND
                         kc.table_name IS NOT NULL AND
                         kc.position_in_unique_constraint IS NOT NULL",
-                    [ $catalog, $main, $main ]
+                    [$catalog, $main, $main]
                 )
             )->toArray();
             foreach ($col as $row) {
@@ -71,8 +71,8 @@ 
                 if ($row['referenced_table_schema'] !== $main) {
                     $additional[] = $row['referenced_table_schema'];
                 }
-                $relationsT[$row['table_schema'] . '.' . $row['table_name']][] = $row;
-                $relationsR[$row['referenced_table_schema'] . '.' . $row['referenced_table_name']][] = $row;
+                $relationsT[$row['table_schema'].'.'.$row['table_name']][] = $row;
+                $relationsR[$row['referenced_table_schema'].'.'.$row['referenced_table_name']][] = $row;
             }
             foreach (array_filter(array_unique($additional)) as $s) {
                 $col = Collection::from(
@@ -97,12 +97,12 @@ 
                             (kc.table_schema = ? AND ct.table_schema = ?) AND
                             kc.table_name IS NOT NULL AND
                             kc.position_in_unique_constraint IS NOT NULL",
-                        [ $catalog, $s, $s ]
+                        [$catalog, $s, $s]
                     )
                 )->toArray();
                 foreach ($col as $row) {
-                    $relationsT[$row['table_schema'] . '.' . $row['table_name']][] = $row;
-                    $relationsR[$row['referenced_table_schema'] . '.' . $row['referenced_table_name']][] = $row;
+                    $relationsT[$row['table_schema'].'.'.$row['table_name']][] = $row;
+                    $relationsR[$row['referenced_table_schema'].'.'.$row['referenced_table_name']][] = $row;
                 }
             }
         }
@@ -111,12 +111,12 @@ 
             ->query(
                 "SELECT * FROM information_schema.columns
                  WHERE table_name = ? AND table_schema = ? AND table_catalog = ?",
-                [ $table, $schema, $catalog ]
+                [$table, $schema, $catalog]
             ))
-            ->mapKey(function ($v) {
+            ->mapKey(function($v) {
                 return $v['column_name'];
             })
-            ->map(function ($v) {
+            ->map(function($v) {
                 $v['length'] = null;
                 if (!isset($v['data_type'])) {
                     return $v;
@@ -124,20 +124,20 @@ 
                 switch ($v['data_type']) {
                     case 'character':
                     case 'character varying':
-                        $v['length'] = (int)$v['character_maximum_length'];
+                        $v['length'] = (int) $v['character_maximum_length'];
                         break;
                 }
                 return $v;
             })
             ->toArray();
         if (!count($columns)) {
-            throw new DBException('Table not found by name: ' . implode('.', [$schema,$table]));
+            throw new DBException('Table not found by name: '.implode('.', [$schema, $table]));
         }
         $pkname = Collection::from($this
             ->query(
                 "SELECT constraint_name FROM information_schema.table_constraints
                 WHERE table_name = ? AND constraint_type = ? AND table_schema = ? AND table_catalog = ?",
-                [ $table, 'PRIMARY KEY', $schema, $catalog ]
+                [$table, 'PRIMARY KEY', $schema, $catalog]
             ))
             ->pluck('constraint_name')
             ->value();
@@ -147,12 +147,12 @@ 
                 ->query(
                     "SELECT column_name FROM information_schema.constraint_column_usage
                      WHERE table_name = ? AND constraint_name = ? AND table_schema = ? AND table_catalog = ?",
-                    [ $table, $pkname, $schema, $catalog ]
+                    [$table, $pkname, $schema, $catalog]
                 ))
                 ->pluck('column_name')
                 ->toArray();
         }
-        $tables[$schema . '.' .$table] = $definition = (new Table($table, $schema))
+        $tables[$schema.'.'.$table] = $definition = (new Table($table, $schema))
             ->addColumns($columns)
             ->setPrimaryKey($primary)
             ->setComment('');
@@ -162,8 +162,8 @@ 
             // assuming current table is on the "one" end having "many" records in the referencing table
             // resulting in a "hasMany" or "manyToMany" relationship (if a pivot table is detected)
             $relations = [];
-            foreach ($relationsR[$schema . '.' . $table] ?? [] as $relation) {
-                $relations[$relation['constraint_name']]['table'] = $relation['table_schema'] . '.' .
+            foreach ($relationsR[$schema.'.'.$table] ?? [] as $relation) {
+                $relations[$relation['constraint_name']]['table'] = $relation['table_schema'].'.'.
                     $relation['table_name'];
                 $relations[$relation['constraint_name']]['keymap'][$relation['referenced_column_name']] =
                     $relation['column_name'];
@@ -180,11 +180,11 @@ 
                 $usedcol = [];
                 if (count($columns)) {
                     foreach (Collection::from($relationsT[$data['table']] ?? [])
-                        ->filter(function ($v) use ($columns) {
+                        ->filter(function($v) use ($columns) {
                             return in_array($v['column_name'], $columns);
                         }) as $relation
                     ) {
-                        $foreign[$relation['constraint_name']]['table'] = $relation['referenced_table_schema'] . '.' .
+                        $foreign[$relation['constraint_name']]['table'] = $relation['referenced_table_schema'].'.'.
                             $relation['referenced_table_name'];
                         $foreign[$relation['constraint_name']]['keymap'][$relation['column_name']] =
                             $relation['referenced_column_name'];
@@ -204,7 +204,7 @@ 
                         $definition->getName() == $relname ||
                         $definition->getColumn($relname)
                     ) {
-                        $relname = $orig . '_' . (++ $cntr);
+                        $relname = $orig.'_'.(++$cntr);
                     }
                     $definition->addRelation(
                         new TableRelation(
@@ -228,7 +228,7 @@ 
                         $definition->getName() == $relname ||
                         $definition->getColumn($relname)
                     ) {
-                        $relname = $orig . '_' . (++ $cntr);
+                        $relname = $orig.'_'.(++$cntr);
                     }
                     $definition->addRelation(
                         new TableRelation(
@@ -244,8 +244,8 @@ 
             // assuming current table is linked to "one" record in the referenced table
             // resulting in a "belongsTo" relationship
             $relations = [];
-            foreach ($relationsT[$schema . '.' . $table] ?? [] as $relation) {
-                $relations[$relation['constraint_name']]['table'] = $relation['referenced_table_schema'] . '.' .
+            foreach ($relationsT[$schema.'.'.$table] ?? [] as $relation) {
+                $relations[$relation['constraint_name']]['table'] = $relation['referenced_table_schema'].'.'.
                     $relation['referenced_table_name'];
                 $relations[$relation['constraint_name']]['keymap'][$relation['column_name']] =
                     $relation['referenced_column_name'];
@@ -262,7 +262,7 @@ 
                     $definition->getName() == $relname ||
                     $definition->getColumn($relname)
                 ) {
-                    $relname = $orig . '_' . (++ $cntr);
+                    $relname = $orig.'_'.(++$cntr);
                 }
                 $definition->addRelation(
                     new TableRelation(
@@ -281,19 +281,19 @@ 
         $tables = Collection::from($this
             ->query(
                 "SELECT table_name FROM information_schema.tables where table_schema = ? AND table_catalog = ?",
-                [ $this->connection['opts']['schema'] ?? 'public', $this->connection['name'] ]
+                [$this->connection['opts']['schema'] ?? 'public', $this->connection['name']]
             ))
-            ->mapKey(function ($v) {
+            ->mapKey(function($v) {
                 return strtolower($v['table_name']);
             })
             ->pluck('table_name')
-            ->map(function ($v) {
+            ->map(function($v) {
                 return $this->table($v)->toLowerCase();
             })
             ->toArray();
 
         foreach (array_keys($tables) as $k) {
-            $tables[($this->connection['opts']['schema'] ?? 'public') . '.' . $k] = &$tables[$k];
+            $tables[($this->connection['opts']['schema'] ?? 'public').'.'.$k] = &$tables[$k];
         }
         return $tables;
     }