vakata / database

src/driver/mysql/Statement.php

Spacing +8 added lines, -8 removed lines

@@ -77,7 +77,7 @@ 
             foreach ($lng as $index) {
                 if (is_resource($data[$index]) && get_resource_type($data[$index]) === 'stream') {
                     while (!feof($data[$index])) {
-                        $this->statement->send_long_data($index, (string)fread($data[$index], $lds));
+                        $this->statement->send_long_data($index, (string) fread($data[$index], $lds));
                     }
                 } else {
                     $data[$index] = str_split($data[$index], $lds);
@@ -97,24 +97,24 @@ 
             $res = false;
         }
         if (!$res) {
-            if ($log && (int)$this->driver->option('log_errors', 1)) {
+            if ($log && (int) $this->driver->option('log_errors', 1)) {
                 @file_put_contents(
                     $log,
-                    '--' . date('Y-m-d H:i:s') . ' ERROR: ' . $this->statement->error . "\r\n" .
-                    $this->sql . "\r\n" .
+                    '--'.date('Y-m-d H:i:s').' ERROR: '.$this->statement->error."\r\n".
+                    $this->sql."\r\n".
                     "\r\n",
                     FILE_APPEND
                 );
             }
-            throw new DBException('Prepared execute error: ' . $this->statement->error);
+            throw new DBException('Prepared execute error: '.$this->statement->error);
         }
         if ($log) {
             $tm = microtime(true) - $tm;
-            if ($tm >= (float)$this->driver->option('log_slow', 0)) {
+            if ($tm >= (float) $this->driver->option('log_slow', 0)) {
                 @file_put_contents(
                     $log,
-                    '--' . date('Y-m-d H:i:s') . ' ' . sprintf('%01.6f', $tm) . "s\r\n" .
-                    $this->sql . "\r\n" .
+                    '--'.date('Y-m-d H:i:s').' '.sprintf('%01.6f', $tm)."s\r\n".
+                    $this->sql."\r\n".
                     "\r\n",
                     FILE_APPEND
                 );

src/driver/sqlite/Driver.php

Spacing +1 added lines, -1 removed lines

@@ -38,7 +38,7 @@
         if ($this->lnk === null) {
             try {
                 $this->lnk = new \SQLite3($this->connection['name']);
-                $this->lnk->exec('PRAGMA encoding = "'.$this->option('charset', 'utf-8') . '"');
+                $this->lnk->exec('PRAGMA encoding = "'.$this->option('charset', 'utf-8').'"');
             } catch (\Exception $e) {
                 if ($this->lnk !== null) {
                     throw new DBException('Connect error: '.$this->lnk->lastErrorMsg());

src/schema/TableColumn.php

Spacing +4 added lines, -4 removed lines

@@ -42,7 +42,7 @@ 
             $instance->setNullable($data['nullable']);
         }
         if (isset($data['notnull'])) {
-            $instance->setNullable(!((int)$data['notnull']));
+            $instance->setNullable(!((int) $data['notnull']));
         }
         if (isset($data['Default'])) {
             $instance->setDefault($data['Default']);
@@ -57,7 +57,7 @@ 
             $instance->setLength($data['length']);
         }
         if ($instance->getBasicType() === 'enum' && strpos($instance->getType(), 'enum(') === 0) {
-            $temp = array_map(function ($v) {
+            $temp = array_map(function($v) {
                 return str_replace("''", "'", $v);
             }, explode("','", substr($instance->getType(), 6, -2)));
             $instance->setValues($temp);
@@ -86,7 +86,7 @@ 
                 $instance->setDefault(null);
             }
         }
-        if ($instance->getBasicType() === 'text' && isset($data['CHAR_LENGTH']) && (int)$data['CHAR_LENGTH']) {
+        if ($instance->getBasicType() === 'text' && isset($data['CHAR_LENGTH']) && (int) $data['CHAR_LENGTH']) {
             $instance->setLength($data['CHAR_LENGTH']);
         }
         return $instance;
@@ -183,7 +183,7 @@ 
     }
     public function getLength(): int
     {
-        return (int)$this->length;
+        return (int) $this->length;
     }
     public function setLength(int $length): static
     {

src/schema/TableQueryMapped.php

Spacing +2 added lines, -2 removed lines

@@ -19,7 +19,7 @@ 
 
     public function __construct(
         DBInterface $db,
-        Table|string $table,
+        Table | string $table,
         bool $findRelations = false,
         ?MapperInterface $mapper = null
     ) {
@@ -34,7 +34,7 @@ 
     public function iterator(array $fields = null, array $collectionKey = null): Collection
     {
         return Collection::from(parent::iterator($fields, $collectionKey))
-            ->map(function ($v) {
+            ->map(function($v) {
                 return $this->mapper->entity($v);
             })
             ->values();

src/DB.php

Spacing +27 added lines, -29 removed lines

@@ -74,19 +74,19 @@ 
                 ];
             }
         }
-        $connection['type'] = isset($temp['scheme']) && strlen((string)$temp['scheme']) ? $temp['scheme'] : null;
-        $connection['user'] = isset($temp['user']) && strlen((string)$temp['user']) ? $temp['user'] : null;
-        $connection['pass'] = isset($temp['pass']) && strlen((string)$temp['pass']) ? $temp['pass'] : null;
-        $connection['host'] = isset($temp['host']) && strlen((string)$temp['host']) ? $temp['host'] : null;
-        $connection['name'] = isset($temp['path']) && strlen((string)$temp['path']) ?
-            trim((string)$temp['path'], '/') : null;
-        $connection['port'] = isset($temp['port']) && (int)$temp['port'] ? (int)$temp['port'] : null;
-        if (isset($temp['query']) && strlen((string)$temp['query'])) {
-            parse_str((string)$temp['query'], $connection['opts']);
+        $connection['type'] = isset($temp['scheme']) && strlen((string) $temp['scheme']) ? $temp['scheme'] : null;
+        $connection['user'] = isset($temp['user']) && strlen((string) $temp['user']) ? $temp['user'] : null;
+        $connection['pass'] = isset($temp['pass']) && strlen((string) $temp['pass']) ? $temp['pass'] : null;
+        $connection['host'] = isset($temp['host']) && strlen((string) $temp['host']) ? $temp['host'] : null;
+        $connection['name'] = isset($temp['path']) && strlen((string) $temp['path']) ?
+            trim((string) $temp['path'], '/') : null;
+        $connection['port'] = isset($temp['port']) && (int) $temp['port'] ? (int) $temp['port'] : null;
+        if (isset($temp['query']) && strlen((string) $temp['query'])) {
+            parse_str((string) $temp['query'], $connection['opts']);
         }
         // create the driver
         $connection['type'] = $aliases[$connection['type']] ?? $connection['type'];
-        $tmp = '\\vakata\\database\\driver\\'.strtolower((string)$connection['type']).'\\Driver';
+        $tmp = '\\vakata\\database\\driver\\'.strtolower((string) $connection['type']).'\\Driver';
         if (!class_exists($tmp)) {
             throw new DBException('Unknown DB backend');
         }
@@ -124,7 +124,7 @@ 
         $new = '';
         $par = array_values($par);
         if (substr_count($sql, '?') === 2 && !is_array($par[0])) {
-            $par = [ $par ];
+            $par = [$par];
         }
         $parts = explode('??', $sql);
         $index = 0;
@@ -134,7 +134,7 @@ 
             $index += count($tmp) - 1;
             if (isset($par[$index])) {
                 if (!is_array($par[$index])) {
-                    $par[$index] = [ $par[$index] ];
+                    $par[$index] = [$par[$index]];
                 }
                 $params = $par[$index];
                 array_splice($par, $index, 1, $params);
@@ -142,7 +142,7 @@ 
                 $new .= implode(',', array_fill(0, count($params), '?'));
             }
         }
-        return [ $new, $par ];
+        return [$new, $par];
     }
     /**
      * Run a query (prepare & execute).
@@ -191,7 +191,7 @@ 
     ): Collection {
         $coll = Collection::from($this->query($sql, $par, $buff));
         if (($keys = $this->driver->option('mode')) && in_array($keys, ['strtoupper', 'strtolower'])) {
-            $coll->map(function ($v) use ($keys) {
+            $coll->map(function($v) use ($keys) {
                 $new = [];
                 foreach ($v as $k => $vv) {
                     $new[call_user_func($keys, $k)] = $vv;
@@ -200,18 +200,18 @@ 
             });
         }
         if ($key !== null) {
-            $coll->mapKey(function ($v) use ($key): int|string {
+            $coll->mapKey(function($v) use ($key): int | string {
                 return $v[$key];
             });
         }
         if ($skip) {
-            $coll->map(function ($v) use ($key) {
+            $coll->map(function($v) use ($key) {
                 unset($v[$key]);
                 return $v;
             });
         }
         if ($opti) {
-            $coll->map(function ($v) {
+            $coll->map(function($v) {
                 return count($v) === 1 ? current($v) : $v;
             });
         }
@@ -328,8 +328,7 @@ 
     public function definition(string $table, bool $detectRelations = true) : Table
     {
         return isset($this->schema) ?
-            $this->schema->getTable($table) :
-            $this->driver->table($table, $detectRelations);
+            $this->schema->getTable($table) : $this->driver->table($table, $detectRelations);
     }
 
     public function hasSchema(): bool
@@ -439,11 +438,11 @@ 
      * @param class-string<T>|Table|string $table
      * @return ($table is class-string ? MapperInterface<T> : MapperInterface<Entity>)
      */
-    public function getMapper(Table|string $table): MapperInterface
+    public function getMapper(Table | string $table): MapperInterface
     {
         if (is_string($table)) {
-            if (isset($this->mappers['::' . $table])) {
-                return $this->mappers['::' . $table];
+            if (isset($this->mappers['::'.$table])) {
+                return $this->mappers['::'.$table];
             }
             $table = $this->definition($table);
         }
@@ -452,14 +451,14 @@ 
         }
         return $this->mappers[$table->getFullName()] = new Mapper($this, $table);
     }
-    public function setMapper(Table|string $table, MapperInterface $mapper, ?string $class = null): static
+    public function setMapper(Table | string $table, MapperInterface $mapper, ?string $class = null): static
     {
         if (is_string($table)) {
             $table = $this->definition($table);
         }
         $this->mappers[$table->getFullName()] = $mapper;
         if (isset($class)) {
-            $this->mappers['::' . $class] = $mapper;
+            $this->mappers['::'.$class] = $mapper;
         }
         return $this;
     }
@@ -470,11 +469,10 @@ 
     ): TableQueryMapped {
         return new TableQueryMapped($this, $this->definition($table), $findRelations, $mapper);
     }
-    public function __call(string $method, array $args): TableQuery|TableQueryMapped
+    public function __call(string $method, array $args): TableQuery | TableQueryMapped
     {
         return ($args[0] ?? false) ?
-            $this->tableMapped($method, $args[1] ?? false, $args[2] ?? null) :
-            $this->table($method, $args[1] ?? false);
+            $this->tableMapped($method, $args[1] ?? false, $args[2] ?? null) : $this->table($method, $args[1] ?? false);
     }
     public function findRelation(string $start, string $end): array
     {
@@ -510,12 +508,12 @@ 
                     $relations[$t] = $w;
                 }
                 if (!isset($schema[$name])) {
-                    $schema[$name] = [ 'edges' => [] ];
+                    $schema[$name] = ['edges' => []];
                 }
                 foreach ($relations as $t => $w) {
                     $schema[$name]['edges'][$t] = $w;
                     if (!isset($schema[$t])) {
-                        $schema[$t] = [ 'edges' => [] ];
+                        $schema[$t] = ['edges' => []];
                     }
                     $schema[$t]['edges'][$name] = $w;
                 }

src/schema/MapperInterface.php

Spacing +2 added lines, -2 removed lines

@@ -58,12 +58,12 @@
      * @param array|T $entity
      * @return bool
      */
-    public function deleted(array|object $entity): bool;
+    public function deleted(array | object $entity): bool;
     /**
      * @param array|T $entity
      * @return bool
      */
-    public function exists(array|object $entity): bool;
+    public function exists(array | object $entity): bool;
     /**
      * @return array<int,T>
      */

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(
             $this,
@@ -211,7 +211,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 {
@@ -266,7 +266,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 {
@@ -322,8 +322,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/schema/Mapper.php

Indentation +1 added lines, -1 removed lines

@@ -539,7 +539,7 @@
                                         (isset($value) && is_array($value) && !in_array($e, $value, true)) ||
                                         (($value instanceof Collection) && !$value->contains($e))
                                     )
-                                 ) {
+                                    ) {
                                     $mapper->delete($e, true);
                                 }
                             }

Spacing +20 added lines, -21 removed lines

@@ -27,7 +27,7 @@ 
      * @param class-string<T> $clss
      * @return void
      */
-    public function __construct(DBInterface $db, string|Table|null $table = '', string $clss = Entity::class)
+    public function __construct(DBInterface $db, string | Table | null $table = '', string $clss = Entity::class)
     {
         $this->db = $db;
         if (!$table) {
@@ -63,7 +63,7 @@ 
         $temp = [];
         foreach ($this->table->getPrimaryKey() as $column) {
             try {
-                $temp[(string)$column] = $entity->{$column} ?? null;
+                $temp[(string) $column] = $entity->{$column} ?? null;
                 /** @phpstan-ignore-next-line */
             } catch (\Throwable $ignore) {
             }
@@ -93,7 +93,7 @@ 
 
         // BEG: ugly hack to get relations changed directly on the object (not hydrated)
         $hack = [];
-        foreach ((array)$entity as $k => $v) {
+        foreach ((array) $entity as $k => $v) {
             $hack[$k[0] === "\0" ? substr($k, strrpos($k, "\0", 1) + 1) : $k] = $v;
         }
         $hack = $hack['changed'] ?? [];
@@ -104,7 +104,7 @@ 
         foreach ($columns as $column) {
             try {
                 if (in_array($column, $fetched) || array_key_exists($column, $hack) || $fetch) {
-                    $temp[(string)$column] = $entity->{$column};
+                    $temp[(string) $column] = $entity->{$column};
                 }
             } catch (\Throwable $ignore) {
             }
@@ -114,7 +114,7 @@ 
         foreach ($relations as $relation) {
             try {
                 if (array_key_exists($relation, $fetched) || array_key_exists($relation, $hack) || $fetch) {
-                    $temp[(string)$relation] = $entity->{$relation};
+                    $temp[(string) $relation] = $entity->{$relation};
                 }
             } catch (\Throwable $ignore) {
             }
@@ -135,7 +135,7 @@ 
                         $v = [];
                     }
                     if ($v instanceof Entity) {
-                        $v = [ $v ];
+                        $v = [$v];
                     }
                     if (is_array($v)) {
                         foreach ($v as $kk => $vv) {
@@ -184,10 +184,10 @@ 
         $temp = [];
         foreach ($this->table->getColumns() as $column) {
             if (array_key_exists($column, $data)) {
-                $temp[(string)$column] = $data[$column];
+                $temp[(string) $column] = $data[$column];
             } else {
                 if ($empty) {
-                    $temp[(string)$column] = null;
+                    $temp[(string) $column] = null;
                 }
             }
         }
@@ -215,7 +215,7 @@ 
         $lazy = [];
         foreach ($this->table->getColumns() as $column) {
             if (!array_key_exists($column, $data)) {
-                $lazy[$column] = function ($entity) use ($column) {
+                $lazy[$column] = function($entity) use ($column) {
                     $query = $this->db->table($this->table->getFullName());
                     foreach ($this->id($entity) as $k => $v) {
                         $query->filter($k, $v);
@@ -238,7 +238,7 @@ 
     {
         $relations = [];
         foreach ($this->table->getRelations() as $name => $relation) {
-            $relations[$name] = function (
+            $relations[$name] = function(
                 $entity,
                 bool $queryOnly = false
             ) use (
@@ -252,10 +252,10 @@ 
                         return $this->objects[spl_object_hash($entity)][4][$name] = null;
                     }
                     $value = $relation->many ?
-                        Collection::from(array_map(function ($v) use ($mapper) {
+                        Collection::from(array_map(function($v) use ($mapper) {
                             return $mapper->entity($v);
                         }, $data[$name]))
-                            ->filter(function ($v) use ($mapper) {
+                            ->filter(function($v) use ($mapper) {
                                 return !$mapper->deleted($v);
                             }) :
                         ($mapper->deleted($data[$name]) ? null : $mapper->entity($data[$name]));
@@ -264,7 +264,7 @@ 
                 }
                 $query = $this->db->tableMapped($relation->table->getFullName());
                 if ($relation->sql) {
-                    $query->where($relation->sql, $relation->par?:[]);
+                    $query->where($relation->sql, $relation->par ?: []);
                 }
                 if ($relation->pivot) {
                     $nm = null;
@@ -285,7 +285,7 @@ 
                     }
                     $pk = $this->id($entity);
                     foreach ($pk as $k => $v) {
-                        $query->filter($nm . '.' . $k, $v);
+                        $query->filter($nm.'.'.$k, $v);
                     }
                 } else {
                     $temp = $this->toArray($entity, array_keys($relation->keymap));
@@ -297,10 +297,9 @@ 
                     return $query;
                 }
                 $value = $relation->many ?
-                    $query->iterator() :
-                    ($query[0] ?? null);
+                    $query->iterator() : ($query[0] ?? null);
                 if ($value instanceof Collection) {
-                    $value->filter(function ($v) use ($mapper) {
+                    $value->filter(function($v) use ($mapper) {
                         return !$mapper->deleted($v);
                     });
                 } elseif (isset($value) && $mapper->deleted($value)) {
@@ -320,7 +319,7 @@ 
     {
         // BEG: ugly hack to get changed columns
         $hack = [];
-        foreach ((array)$entity as $k => $v) {
+        foreach ((array) $entity as $k => $v) {
             $hack[$k[0] === "\0" ? substr($k, strrpos($k, "\0", 1) + 1) : $k] = $v;
         }
         $hack = $hack['changed'] ?? [];
@@ -611,7 +610,7 @@ 
             }
         }
     }
-    public function exists(array|object $entity): bool
+    public function exists(array | object $entity): bool
     {
         if (is_array($entity)) {
             $primary = [];
@@ -625,7 +624,7 @@ 
         return isset($this->objects[spl_object_hash($entity)]) &&
             $this->objects[spl_object_hash($entity)][5] === false;
     }
-    public function deleted(array|object $entity): bool
+    public function deleted(array | object $entity): bool
     {
         if (is_array($entity)) {
             $primary = [];
@@ -711,7 +710,7 @@ 
         return array_filter(
             array_values(
                 array_map(
-                    function ($v) {
+                    function($v) {
                         return $v[5] ? null : ($v[1] ?? null);
                     },
                     $this->objects

src/Schema.php

Spacing +5 added lines, -5 removed lines

@@ -31,7 +31,7 @@ 
     public function getTable(string $table): Table
     {
         if (!$this->hasTable($table)) {
-            throw new DBException('Invalid table name: ' . $table);
+            throw new DBException('Invalid table name: '.$table);
         }
         return $this->tables[$table] ??
             $this->tables[strtoupper($table)] ??
@@ -64,13 +64,13 @@ 
     
     public function toArray(): array
     {
-        return array_map(function ($table) {
+        return array_map(function($table) {
             return [
                 'name' => $table->getName(),
                 'schema' => $table->getSchema(),
                 'pkey' => $table->getPrimaryKey(),
                 'comment' => $table->getComment(),
-                'columns' => array_map(function ($column) {
+                'columns' => array_map(function($column) {
                     return [
                         'name' => $column->getName(),
                         'type' => $column->getType(),
@@ -81,9 +81,9 @@ 
                         'nullable' => $column->isNullable()
                     ];
                 }, $table->getFullColumns()),
-                'relations' => array_map(function ($rel) {
+                'relations' => array_map(function($rel) {
                     $relation = clone $rel;
-                    $relation = (array)$relation;
+                    $relation = (array) $relation;
                     $relation['table'] = $rel->table->getName();
                     if ($rel->pivot) {
                         $relation['pivot'] = $rel->pivot->getName();