platine-php / database

src/Query/Delete.php

Spacing +2 added lines, -2 removed lines

@@ -68,7 +68,7 @@ 
      */
     public function __construct(
         Connection $connection,
-        string|array $from,
+        string | array $from,
         ?QueryStatement $queryStatement = null
     ) {
         parent::__construct($from, $queryStatement);
@@ -83,7 +83,7 @@ 
      * @return int
      * @throws QueryException
      */
-    public function delete(string|array $tables = []): int
+    public function delete(string | array $tables = []): int
     {
         parent::delete($tables);
         $driver = $this->connection->getDriver();

Braces +1 added lines, -2 removed lines

@@ -53,8 +53,7 @@
  * @class Delete
  * @package Platine\Database\Query
  */
-class Delete extends DeleteStatement
-{
+class Delete extends DeleteStatement {
     /**
      * @var Connection
      */

src/Query/Update.php

Braces +1 added lines, -2 removed lines

@@ -52,8 +52,7 @@
  * @class Update
  * @package Platine\Database\Query
  */
-class Update extends UpdateStatement
-{
+class Update extends UpdateStatement {
     /**
      * @var Connection
      */

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

Braces +2 added lines, -4 removed lines

@@ -55,8 +55,7 @@ 
  * @class HavingExpression
  * @package Platine\Database\Query
  */
-class HavingExpression
-{
+class HavingExpression {
     /**
      * The Query statement instance
      * @var QueryStatement
@@ -83,8 +82,7 @@ 
      * HavingExpression constructor.
      * @param QueryStatement $queryStatement
      */
-    public function __construct(QueryStatement $queryStatement)
-    {
+    public function __construct(QueryStatement $queryStatement) {
         $this->queryStatement = $queryStatement;
 
         $this->having = new Having($queryStatement);

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

Spacing +1 added lines, -1 removed lines

@@ -62,7 +62,7 @@
      * @param string|array<int, string> $tables
      * @return SelectStatement
      */
-    public function from(string|array $tables): SelectStatement
+    public function from(string | array $tables): SelectStatement
     {
         return $this->select = new SelectStatement($tables);
     }

Braces +1 added lines, -2 removed lines

@@ -50,8 +50,7 @@
  * @class SubQuery
  * @package Platine\Database\Query
  */
-class SubQuery
-{
+class SubQuery {
     /**
      * The SelectStatement instance
      * @var SelectStatement

src/Query/Having.php

Spacing +4 added lines, -4 removed lines

@@ -57,7 +57,7 @@ 
     /**
      * @var string|Expression
      */
-    protected string|Expression $aggregate;
+    protected string | Expression $aggregate;
 
     /**
      * @var string
@@ -84,7 +84,7 @@ 
      * @param string $separator
      * @return self
      */
-    public function init(string|Expression|Closure $aggregate, string $separator): self
+    public function init(string | Expression | Closure $aggregate, string $separator): self
     {
         if ($aggregate instanceof Closure) {
             $aggregate = Expression::fromClosure($aggregate);
@@ -211,7 +211,7 @@ 
      * @param array<int, mixed>|Closure $value
      * @return void
      */
-    public function in(array|Closure $value): void
+    public function in(array | Closure $value): void
     {
         $this->queryStatement->addHavingIn(
             $this->aggregate,
@@ -225,7 +225,7 @@ 
      * @param array<int, mixed>|Closure $value
      * @return void
      */
-    public function notIn(array|Closure $value): void
+    public function notIn(array | Closure $value): void
     {
         $this->queryStatement->addHavingIn(
             $this->aggregate,

Braces +2 added lines, -4 removed lines

@@ -52,8 +52,7 @@ 
  * @class Having
  * @package Platine\Database\Query
  */
-class Having
-{
+class Having {
     /**
      * @var string|Expression
      */
@@ -68,8 +67,7 @@ 
      * Having constructor.
      * @param QueryStatement $queryStatement
      */
-    public function __construct(protected QueryStatement $queryStatement)
-    {
+    public function __construct(protected QueryStatement $queryStatement) {
     }
 
     /**

src/Query/BaseStatement.php

Spacing +5 added lines, -5 removed lines

@@ -60,7 +60,7 @@ 
      *
      * @return Delete|Select|BaseStatement
      */
-    public function join(array|string $table, Closure $closure): Delete|Select|BaseStatement
+    public function join(array | string $table, Closure $closure): Delete | Select | BaseStatement
     {
         $this->queryStatement->addJoinClause('INNER', $table, $closure);
 
@@ -73,7 +73,7 @@ 
      *
      * @return Delete|Select|BaseStatement
      */
-    public function leftJoin(array|string $table, Closure $closure): Delete|Select|BaseStatement
+    public function leftJoin(array | string $table, Closure $closure): Delete | Select | BaseStatement
     {
         $this->queryStatement->addJoinClause('LEFT', $table, $closure);
 
@@ -86,7 +86,7 @@ 
      *
      * @return Delete|Select|BaseStatement
      */
-    public function rightJoin(array|string $table, Closure $closure): Delete|Select|BaseStatement
+    public function rightJoin(array | string $table, Closure $closure): Delete | Select | BaseStatement
     {
         $this->queryStatement->addJoinClause('RIGHT', $table, $closure);
 
@@ -99,7 +99,7 @@ 
      *
      * @return Delete|Select|BaseStatement
      */
-    public function fullJoin(array|string $table, Closure $closure): Delete|Select|BaseStatement
+    public function fullJoin(array | string $table, Closure $closure): Delete | Select | BaseStatement
     {
         $this->queryStatement->addJoinClause('FULL', $table, $closure);
 
@@ -112,7 +112,7 @@ 
      *
      * @return Delete|Select|BaseStatement
      */
-    public function crossJoin(array|string $table, Closure $closure): Delete|Select|BaseStatement
+    public function crossJoin(array | string $table, Closure $closure): Delete | Select | BaseStatement
     {
         $this->queryStatement->addJoinClause('CROSS', $table, $closure);
 

Braces +1 added lines, -2 removed lines

@@ -52,8 +52,7 @@
  * @class BaseStatement
  * @package Platine\Database\Query
  */
-class BaseStatement extends WhereStatement
-{
+class BaseStatement extends WhereStatement {
     /**
      * @param string|string[] $table
      * @param Closure $closure

src/Query/Insert.php

Braces +1 added lines, -2 removed lines

@@ -52,8 +52,7 @@
  * @class Insert
  * @package Platine\Database\Query
  */
-class Insert extends InsertStatement
-{
+class Insert extends InsertStatement {
     /**
      * @var Connection
      */

src/Query/SelectStatement.php

Spacing +12 added lines, -12 removed lines

@@ -64,7 +64,7 @@ 
      * @param string|array<int, string> $tables
      * @param QueryStatement|null $queryStatement
      */
-    public function __construct(string|array $tables, ?QueryStatement $queryStatement = null)
+    public function __construct(string | array $tables, ?QueryStatement $queryStatement = null)
     {
         parent::__construct($queryStatement);
 
@@ -102,7 +102,7 @@ 
      * @param string|Expression|Closure|string[]|Expression[]|Closure[] $columns
      * @return $this
      */
-    public function groupBy(string|Expression|Closure|array $columns): self
+    public function groupBy(string | Expression | Closure | array $columns): self
     {
         if (!is_array($columns)) {
             $columns = [$columns];
@@ -117,7 +117,7 @@ 
      * @param Closure|null $closure
      * @return $this
      */
-    public function having(string|Expression|Closure $column, ?Closure $closure = null): self
+    public function having(string | Expression | Closure $column, ?Closure $closure = null): self
     {
         $this->havingStatement->having($column, $closure);
 
@@ -130,7 +130,7 @@ 
      * @return $this
      */
     public function orHaving(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         ?Closure $closure = null
     ): self {
         $this->havingStatement->orHaving($column, $closure);
@@ -144,7 +144,7 @@ 
      * @return $this
      */
     public function orderBy(
-        string|Closure|Expression|array $columns,
+        string | Closure | Expression | array $columns,
         string $order = 'ASC'
     ): self {
         if (!is_array($columns)) {
@@ -182,7 +182,7 @@ 
      * @param string|Expression|Closure|string[]|Expression[]|Closure[] $columns
      * @return mixed
      */
-    public function select(string|Expression|Closure|array $columns = []): mixed
+    public function select(string | Expression | Closure | array $columns = []): mixed
     {
         $expr = new ColumnExpression($this->queryStatement);
 
@@ -202,7 +202,7 @@ 
      * @param string|Expression|Closure $name
      * @return mixed
      */
-    public function column(string|Expression|Closure $name): mixed
+    public function column(string | Expression | Closure $name): mixed
     {
         (new ColumnExpression($this->queryStatement))->column($name);
 
@@ -215,7 +215,7 @@ 
      * @return mixed
      */
     public function count(
-        string|Expression|Closure $column = '*',
+        string | Expression | Closure $column = '*',
         bool $distinct = false
     ): mixed {
         (new ColumnExpression($this->queryStatement))->count($column, null, $distinct);
@@ -229,7 +229,7 @@ 
      * @return mixed
      */
     public function avg(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         bool $distinct = false
     ): mixed {
         (new ColumnExpression($this->queryStatement))->avg($column, null, $distinct);
@@ -242,7 +242,7 @@ 
      * @param bool $distinct
      * @return mixed
      */
-    public function sum(string|Expression|Closure $column, bool $distinct = false): mixed
+    public function sum(string | Expression | Closure $column, bool $distinct = false): mixed
     {
         (new ColumnExpression($this->queryStatement))->sum($column, null, $distinct);
 
@@ -254,7 +254,7 @@ 
      * @param bool $distinct
      * @return mixed
      */
-    public function min(string|Expression|Closure $column, bool $distinct = false): mixed
+    public function min(string | Expression | Closure $column, bool $distinct = false): mixed
     {
         (new ColumnExpression($this->queryStatement))->min($column, null, $distinct);
 
@@ -266,7 +266,7 @@ 
      * @param bool $distinct
      * @return mixed
      */
-    public function max(string|Expression|Closure $column, bool $distinct = false): mixed
+    public function max(string | Expression | Closure $column, bool $distinct = false): mixed
     {
         (new ColumnExpression($this->queryStatement))->max($column, null, $distinct);
 

Braces +2 added lines, -4 removed lines

@@ -52,8 +52,7 @@ 
  * @class SelectStatement
  * @package Platine\Database\Query
  */
-class SelectStatement extends BaseStatement
-{
+class SelectStatement extends BaseStatement {
     /**
      * @var HavingStatement
      */
@@ -64,8 +63,7 @@ 
      * @param string|array<int, string> $tables
      * @param QueryStatement|null $queryStatement
      */
-    public function __construct(string|array $tables, ?QueryStatement $queryStatement = null)
-    {
+    public function __construct(string|array $tables, ?QueryStatement $queryStatement = null) {
         parent::__construct($queryStatement);
 
         if (!is_array($tables)) {

src/Query/QueryStatement.php

Braces +1 added lines, -2 removed lines

@@ -53,8 +53,7 @@
  *
  * @package Platine\Database\Query
  */
-class QueryStatement
-{
+class QueryStatement {
     /**
      * The where SQL parts
      * @var array<int, mixed>

Spacing +11 added lines, -11 removed lines

@@ -156,7 +156,7 @@ 
      * @param string $separator
      */
     public function addWhere(
-        string|Closure|Expression $column,
+        string | Closure | Expression $column,
         mixed $value,
         string $operator,
         string $separator
@@ -179,7 +179,7 @@ 
      * @return void
      */
     public function addWhereLike(
-        string|Closure|Expression $column,
+        string | Closure | Expression $column,
         string $pattern,
         string $separator,
         bool $not
@@ -203,7 +203,7 @@ 
      * @return void
      */
     public function addWhereBetween(
-        string|Closure|Expression $column,
+        string | Closure | Expression $column,
         mixed $value1,
         mixed $value2,
         string $separator,
@@ -228,7 +228,7 @@ 
      * @return void
      */
     public function addWhereIn(
-        string|Closure|Expression $column,
+        string | Closure | Expression $column,
         mixed $value,
         string $separator,
         bool $not
@@ -265,7 +265,7 @@ 
      * @return void
      */
     public function addWhereNull(
-        string|Closure|Expression $column,
+        string | Closure | Expression $column,
         string $separator,
         bool $not
     ): void {
@@ -284,7 +284,7 @@ 
      * @return void
      */
     public function addWhereNop(
-        string|Closure|Expression $column,
+        string | Closure | Expression $column,
         string $separator
     ): void {
         $this->wheres[] = [
@@ -321,7 +321,7 @@ 
      */
     public function addJoinClause(
         string $type,
-        string|array|Closure $table,
+        string | array | Closure $table,
         ?Closure $closure = null
     ): void {
         $join = null;
@@ -372,7 +372,7 @@ 
      * @return void
      */
     public function addHaving(
-        string|Closure|Expression $aggregate,
+        string | Closure | Expression $aggregate,
         mixed $value,
         string $operator,
         string $separator
@@ -395,7 +395,7 @@ 
      * @return void
      */
     public function addHavingIn(
-        string|Closure|Expression $aggregate,
+        string | Closure | Expression $aggregate,
         mixed $value,
         string $separator,
         bool $not
@@ -434,7 +434,7 @@ 
      * @return void
      */
     public function addHavingBetween(
-        string|Closure|Expression $aggregate,
+        string | Closure | Expression $aggregate,
         mixed $value1,
         mixed $value2,
         string $separator,
@@ -516,7 +516,7 @@ 
      * @return void
      */
     public function addColumn(
-        string|Expression|Closure $column,
+        string | Expression | Closure $column,
         ?string $alias = null
     ): void {
         $this->columns[] = [