platine-php / database

src/Query/Query.php

Spacing +19 added lines, -19 removed lines

@@ -64,7 +64,7 @@ 
     /**
      * @var string|array<string>
      */
-    protected string|array $tables;
+    protected string | array $tables;
 
     /**
      * Query constructor.
@@ -74,7 +74,7 @@ 
      */
     public function __construct(
         Connection $connection,
-        string|array $tables,
+        string | array $tables,
         ?QueryStatement $queryStatement = null
     ) {
         parent::__construct($queryStatement);
@@ -88,7 +88,7 @@ 
      *
      * @return Select|SelectStatement
      */
-    public function distinct(bool $value = true): Select|SelectStatement
+    public function distinct(bool $value = true): Select | SelectStatement
     {
         return $this->buildSelect()->distinct($value);
     }
@@ -98,7 +98,7 @@ 
      *
      * @return Select|SelectStatement
      */
-    public function groupBy(string|array|Closure|Expression $columns): Select|SelectStatement
+    public function groupBy(string | array | Closure | Expression $columns): Select | SelectStatement
     {
         return $this->buildSelect()->groupBy($columns);
     }
@@ -109,7 +109,7 @@ 
      *
      * @return Select|SelectStatement
      */
-    public function having(string|Expression $column, ?Closure $value = null): Select|SelectStatement
+    public function having(string | Expression $column, ?Closure $value = null): Select | SelectStatement
     {
         return $this->buildSelect()->having($column, $value);
     }
@@ -120,7 +120,7 @@ 
      *
      * @return Select|SelectStatement
      */
-    public function orHaving(string|Expression $column, ?Closure $value = null): Select|SelectStatement
+    public function orHaving(string | Expression $column, ?Closure $value = null): Select | SelectStatement
     {
         return $this->buildSelect()->orHaving($column, $value);
     }
@@ -132,9 +132,9 @@ 
      * @return Select|SelectStatement
      */
     public function orderBy(
-        string|array|Closure|Expression $columns,
+        string | array | Closure | Expression $columns,
         string $order = 'ASC'
-    ): Select|SelectStatement {
+    ): Select | SelectStatement {
         return $this->buildSelect()->orderBy($columns, $order);
     }
 
@@ -143,7 +143,7 @@ 
      *
      * @return Select|SelectStatement
      */
-    public function limit(int $value): Select|SelectStatement
+    public function limit(int $value): Select | SelectStatement
     {
         return $this->buildSelect()->limit($value);
     }
@@ -153,7 +153,7 @@ 
      *
      * @return Select|SelectStatement
      */
-    public function offset(int $value): Select|SelectStatement
+    public function offset(int $value): Select | SelectStatement
     {
         return $this->buildSelect()->offset($value);
     }
@@ -162,7 +162,7 @@ 
      * @param string $table
      * @return Select|SelectStatement
      */
-    public function into(string $table): Select|SelectStatement
+    public function into(string $table): Select | SelectStatement
     {
         return $this->buildSelect()->into($table);
     }
@@ -172,7 +172,7 @@ 
      *
      * @return ResultSet
      */
-    public function select(string|array|Expression|Closure $columns = []): ResultSet
+    public function select(string | array | Expression | Closure $columns = []): ResultSet
     {
         return $this->buildSelect()->select($columns);
     }
@@ -181,7 +181,7 @@ 
      * @param string|array<string> $tables
      * @return int
      */
-    public function delete(string|array $tables): int
+    public function delete(string | array $tables): int
     {
         return $this->buildDelete()->delete($tables);
     }
@@ -191,7 +191,7 @@ 
      *
      * @return mixed
      */
-    public function column(string|Closure|Expression $name): mixed
+    public function column(string | Closure | Expression $name): mixed
     {
         return $this->buildSelect()->column($name);
     }
@@ -202,7 +202,7 @@ 
      *
      * @return int
      */
-    public function count(string|Expression|Closure $column = '*', bool $distinct = false): int
+    public function count(string | Expression | Closure $column = '*', bool $distinct = false): int
     {
         return $this->buildSelect()->count($column, $distinct);
     }
@@ -213,7 +213,7 @@ 
      *
      * @return int|float
      */
-    public function avg(string|Expression|Closure $column, bool $distinct = false): int|float
+    public function avg(string | Expression | Closure $column, bool $distinct = false): int | float
     {
         return $this->buildSelect()->avg($column, $distinct);
     }
@@ -224,7 +224,7 @@ 
      *
      * @return int|float
      */
-    public function sum(string|Expression|Closure $column, bool $distinct = false): int|float
+    public function sum(string | Expression | Closure $column, bool $distinct = false): int | float
     {
         return $this->buildSelect()->sum($column, $distinct);
     }
@@ -235,7 +235,7 @@ 
      *
      * @return mixed
      */
-    public function min(string|Expression|Closure $column, bool $distinct = false): mixed
+    public function min(string | Expression | Closure $column, bool $distinct = false): mixed
     {
         return $this->buildSelect()->min($column, $distinct);
     }
@@ -246,7 +246,7 @@ 
      *
      * @return mixed
      */
-    public function max(string|Expression|Closure $column, bool $distinct = false)
+    public function max(string | Expression | Closure $column, bool $distinct = false)
     {
         return $this->buildSelect()->max($column, $distinct);
     }

src/Query/DeleteStatement.php

Spacing +2 added lines, -2 removed lines

@@ -58,7 +58,7 @@ 
      * @param QueryStatement|null $queryStatement
      */
     public function __construct(
-        string|array $from,
+        string | array $from,
         ?QueryStatement $queryStatement = null
     ) {
         parent::__construct($queryStatement);
@@ -74,7 +74,7 @@ 
      * @param string|array<string> $tables
      * @return mixed
      */
-    public function delete(string|array $tables = []): mixed
+    public function delete(string | array $tables = []): mixed
     {
         if (!is_array($tables)) {
             $tables = [$tables];

src/Query/HavingStatement.php

Spacing +3 added lines, -3 removed lines

@@ -89,7 +89,7 @@ 
      * @param Closure|null $value
      * @return $this
      */
-    public function having(string|Expression|Closure $column, ?Closure $value = null): self
+    public function having(string | Expression | Closure $column, ?Closure $value = null): self
     {
         return $this->addCondition($column, $value, 'AND');
     }
@@ -99,7 +99,7 @@ 
      * @param Closure|null $value
      * @return $this
      */
-    public function orHaving(string|Expression|Closure $column, ?Closure $value = null): self
+    public function orHaving(string | Expression | Closure $column, ?Closure $value = null): self
     {
         return $this->addCondition($column, $value, 'OR');
     }
@@ -120,7 +120,7 @@ 
      * @return $this
      */
     protected function addCondition(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         ?Closure $value = null,
         string $separator = 'AND'
     ): self {

src/Query/Update.php

Spacing +6 added lines, -6 removed lines

@@ -67,7 +67,7 @@ 
      */
     public function __construct(
         Connection $connection,
-        string|array $table,
+        string | array $table,
         ?QueryStatement $queryStatement = null
     ) {
         parent::__construct($table, $queryStatement);
@@ -96,7 +96,7 @@ 
      * @param mixed $value
      * @return int
      */
-    public function increment(string|array $column, mixed $value = 1): int
+    public function increment(string | array $column, mixed $value = 1): int
     {
         return $this->incrementOrDecrement('+', $column, $value);
     }
@@ -106,7 +106,7 @@ 
      * @param mixed $value
      * @return int
      */
-    public function decrement(string|array $column, mixed $value = 1): int
+    public function decrement(string | array $column, mixed $value = 1): int
     {
         return $this->incrementOrDecrement('-', $column, $value);
     }
@@ -119,7 +119,7 @@ 
      */
     protected function incrementOrDecrement(
         string $sign,
-        string|array $columns,
+        string | array $columns,
         mixed $value
     ): int {
         if (!is_array($columns)) {
@@ -130,11 +130,11 @@ 
 
         foreach ($columns as $key => $val) {
             if (is_numeric($key)) {
-                $values[$val] = function (Expression $expr) use ($sign, $val, $value) {
+                $values[$val] = function(Expression $expr) use ($sign, $val, $value) {
                     $expr->column($val)->op($sign)->value($value);
                 };
             } else {
-                $values[$key] = function (Expression $expr) use ($sign, $key, $val) {
+                $values[$key] = function(Expression $expr) use ($sign, $key, $val) {
                     $expr->column($key)->op($sign)->value($val);
                 };
             }

src/Query/HavingExpression.php

Spacing +2 added lines, -2 removed lines

@@ -72,7 +72,7 @@ 
     /**
      * @var string|Expression
      */
-    protected string|Expression $column;
+    protected string | Expression $column;
 
     /**
      * @var string
@@ -95,7 +95,7 @@ 
      * @param string $separator
      * @return $this
      */
-    public function init(string|Expression|Closure $column, string $separator): self
+    public function init(string | Expression | Closure $column, string $separator): self
     {
         if ($column instanceof Closure) {
             $column = Expression::fromClosure($column);

src/Query/UpdateStatement.php

Spacing +1 added lines, -1 removed lines

@@ -64,7 +64,7 @@
      * @param QueryStatement|null $queryStatement
      */
     public function __construct(
-        string|array $table,
+        string | array $table,
         ?QueryStatement $queryStatement = null
     ) {
         parent::__construct($queryStatement);

src/Query/Select.php

Spacing +12 added lines, -12 removed lines

@@ -69,7 +69,7 @@ 
      */
     public function __construct(
         Connection $connection,
-        string|array $tables,
+        string | array $tables,
         ?QueryStatement $queryStatement = null
     ) {
         parent::__construct($tables, $queryStatement);
@@ -81,7 +81,7 @@ 
      *
      * @return ResultSet
      */
-    public function select(string|Expression|Closure|array $columns = []): ResultSet
+    public function select(string | Expression | Closure | array $columns = []): ResultSet
     {
         parent::select($columns);
         $driver = $this->connection->getDriver();
@@ -97,7 +97,7 @@ 
      *
      * @return mixed
      */
-    public function column(string|Expression|Closure $name): mixed
+    public function column(string | Expression | Closure $name): mixed
     {
         parent::column($name);
 
@@ -111,7 +111,7 @@ 
      * @return int
      */
     public function count(
-        string|Expression|Closure $column = '*',
+        string | Expression | Closure $column = '*',
         bool $distinct = false
     ): int {
         parent::count($column, $distinct);
@@ -125,9 +125,9 @@ 
      * @return int|float
      */
     public function avg(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         bool $distinct = false
-    ): int|float {
+    ): int | float {
         parent::avg($column, $distinct);
         return $this->getColumnResult();
     }
@@ -139,9 +139,9 @@ 
      * @return int|float
      */
     public function sum(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         bool $distinct = false
-    ): int|float {
+    ): int | float {
         parent::sum($column, $distinct);
         return $this->getColumnResult();
     }
@@ -153,9 +153,9 @@ 
      * @return int|float
      */
     public function min(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         bool $distinct = false
-    ): int|float {
+    ): int | float {
         parent::min($column, $distinct);
         return $this->getColumnResult();
     }
@@ -167,9 +167,9 @@ 
      * @return int|float
      */
     public function max(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         bool $distinct = false
-    ): int|float {
+    ): int | float {
         parent::max($column, $distinct);
         return $this->getColumnResult();
     }

src/Schema/AlterTable.php

Spacing +5 added lines, -5 removed lines

@@ -164,7 +164,7 @@ 
      * @param string|null $name
      * @return $this
      */
-    public function primary(string|array $columns, ?string $name = null): self
+    public function primary(string | array $columns, ?string $name = null): self
     {
         return $this->addKey('addPrimary', $columns, $name);
     }
@@ -175,7 +175,7 @@ 
      * @param string|null $name
      * @return $this
      */
-    public function unique(string|array $columns, ?string $name = null): self
+    public function unique(string | array $columns, ?string $name = null): self
     {
         return $this->addKey('addUnique', $columns, $name);
     }
@@ -186,7 +186,7 @@ 
      * @param string|null $name
      * @return $this
      */
-    public function index(string|array $columns, ?string $name = null): self
+    public function index(string | array $columns, ?string $name = null): self
     {
         return $this->addKey('addIndex', $columns, $name);
     }
@@ -197,7 +197,7 @@ 
      * @param string|null $name
      * @return ForeignKey
      */
-    public function foreign(string|array $columns, ?string $name = null): ForeignKey
+    public function foreign(string | array $columns, ?string $name = null): ForeignKey
     {
         if (!is_array($columns)) {
             $columns = [$columns];
@@ -561,7 +561,7 @@ 
      */
     protected function addKey(
         string $type,
-        string|array $columns,
+        string | array $columns,
         ?string $name = null
     ): self {
         static $maps = [

src/Query/Where.php

Spacing +26 added lines, -26 removed lines

@@ -57,7 +57,7 @@ 
     /**
      * @var string|Expression
      */
-    protected string|Expression $column;
+    protected string | Expression $column;
 
     /**
      * @var string
@@ -80,7 +80,7 @@ 
      * @param string $separator
      * @return $this
      */
-    public function init(string|Expression|Closure $column, string $separator): self
+    public function init(string | Expression | Closure $column, string $separator): self
     {
         if ($column instanceof Closure) {
             $column = Expression::fromClosure($column);
@@ -101,7 +101,7 @@ 
         string $literal,
         mixed $value,
         bool $isColumn = false
-    ): WhereStatement|Select|Delete|Update {
+    ): WhereStatement | Select | Delete | Update {
         return $this->addCondition($value, $literal, $isColumn);
     }
 
@@ -110,7 +110,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function is(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function is(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->addCondition($value, '=', $isColumn);
     }
@@ -120,7 +120,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function eq(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function eq(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->is($value, $isColumn);
     }
@@ -130,7 +130,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function isNot(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function isNot(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->addCondition($value, '!=', $isColumn);
     }
@@ -140,7 +140,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function neq(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function neq(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->isNot($value, $isColumn);
     }
@@ -150,7 +150,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function lt(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function lt(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->addCondition($value, '<', $isColumn);
     }
@@ -160,7 +160,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function gt(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function gt(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->addCondition($value, '>', $isColumn);
     }
@@ -170,7 +170,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function lte(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function lte(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->addCondition($value, '<=', $isColumn);
     }
@@ -180,7 +180,7 @@ 
      * @param bool $isColumn
      * @return WhereStatement|Select|Delete|Update
      */
-    public function gte(mixed $value, bool $isColumn = false): WhereStatement|Select|Delete|Update
+    public function gte(mixed $value, bool $isColumn = false): WhereStatement | Select | Delete | Update
     {
         return $this->addCondition($value, '>=', $isColumn);
     }
@@ -190,7 +190,7 @@ 
      * @param mixed $value2
      * @return WhereStatement|Select|Delete|Update
      */
-    public function between(mixed $value1, mixed $value2): WhereStatement|Select|Delete|Update
+    public function between(mixed $value1, mixed $value2): WhereStatement | Select | Delete | Update
     {
         return $this->addBetweenCondition($value1, $value2, false);
     }
@@ -200,7 +200,7 @@ 
      * @param mixed $value2
      * @return WhereStatement|Select|Delete|Update
      */
-    public function notBetween(mixed $value1, mixed $value2): WhereStatement|Select|Delete|Update
+    public function notBetween(mixed $value1, mixed $value2): WhereStatement | Select | Delete | Update
     {
         return $this->addBetweenCondition($value1, $value2, true);
     }
@@ -209,7 +209,7 @@ 
      * @param mixed $value
      * @return WhereStatement|Select|Delete|Update
      */
-    public function like(mixed $value): WhereStatement|Select|Delete|Update
+    public function like(mixed $value): WhereStatement | Select | Delete | Update
     {
         return $this->addLikeCondition($value, false);
     }
@@ -218,7 +218,7 @@ 
      * @param mixed $value
      * @return WhereStatement|Select|Delete|Update
      */
-    public function notLike(mixed $value): WhereStatement|Select|Delete|Update
+    public function notLike(mixed $value): WhereStatement | Select | Delete | Update
     {
         return $this->addLikeCondition($value, true);
     }
@@ -227,7 +227,7 @@ 
      * @param array<int, mixed>|Closure $value
      * @return WhereStatement
      */
-    public function in(array|Closure $value): WhereStatement
+    public function in(array | Closure $value): WhereStatement
     {
         return $this->addInCondition($value, false);
     }
@@ -236,7 +236,7 @@ 
      * @param array<int, mixed>|Closure $value
      * @return WhereStatement
      */
-    public function notIn(array|Closure $value): WhereStatement
+    public function notIn(array | Closure $value): WhereStatement
     {
         return $this->addInCondition($value, true);
     }
@@ -244,7 +244,7 @@ 
     /**
      * @return WhereStatement|Select|Delete|Update
      */
-    public function isNull(): WhereStatement|Select|Delete|Update
+    public function isNull(): WhereStatement | Select | Delete | Update
     {
         return $this->addNullCondition(false);
     }
@@ -252,7 +252,7 @@ 
     /**
      * @return WhereStatement|Select|Delete|Update
      */
-    public function isNotNull(): WhereStatement|Select|Delete|Update
+    public function isNotNull(): WhereStatement | Select | Delete | Update
     {
         return $this->addNullCondition(true);
     }
@@ -260,7 +260,7 @@ 
     /**
      * @return WhereStatement|Select|Delete|Update
      */
-    public function nop(): WhereStatement|Select|Delete|Update
+    public function nop(): WhereStatement | Select | Delete | Update
     {
         $this->queryStatement->addWhereNop($this->column, $this->separator);
 
@@ -289,9 +289,9 @@ 
         mixed $value,
         string $operator,
         bool $isColumn = false
-    ): WhereStatement|Select|Delete|Update {
+    ): WhereStatement | Select | Delete | Update {
         if ($isColumn && is_string($value)) {
-            $value = function (Expression $expr) use ($value) {
+            $value = function(Expression $expr) use ($value) {
                 return $expr->column($value);
             };
         }
@@ -315,7 +315,7 @@ 
         mixed $value1,
         mixed $value2,
         bool $not
-    ): WhereStatement|Select|Delete|update {
+    ): WhereStatement | Select | Delete | update {
         $this->queryStatement->addWhereBetween(
             $this->column,
             $value1,
@@ -332,7 +332,7 @@ 
      * @param bool $not
      * @return WhereStatement|Select|Delete|update
      */
-    protected function addLikeCondition(string $pattern, bool $not): WhereStatement|Select|Delete|update
+    protected function addLikeCondition(string $pattern, bool $not): WhereStatement | Select | Delete | update
     {
         $this->queryStatement->addWhereLike(
             $this->column,
@@ -349,7 +349,7 @@ 
      * @param bool $not
      * @return WhereStatement|Select|Delete|update
      */
-    protected function addInCondition(mixed $value, bool $not): WhereStatement|Select|Delete|update
+    protected function addInCondition(mixed $value, bool $not): WhereStatement | Select | Delete | update
     {
         $this->queryStatement->addWhereIn(
             $this->column,
@@ -365,7 +365,7 @@ 
      * @param bool $not
      * @return WhereStatement|Select|Delete|Update
      */
-    protected function addNullCondition(bool $not): WhereStatement|Select|Delete|Update
+    protected function addNullCondition(bool $not): WhereStatement | Select | Delete | Update
     {
         $this->queryStatement->addWhereNull(
             $this->column,