@@ -33,13 +33,13 @@ |
||
| 33 | 33 | |
| 34 | 34 | public function toString(): string |
| 35 | 35 | { |
| 36 | - if(empty($this->sets)) |
|
| 36 | + if (empty($this->sets)) |
|
| 37 | 37 | { |
| 38 | 38 | return ''; |
| 39 | 39 | } |
| 40 | 40 | |
| 41 | 41 | $sets = array(); |
| 42 | - foreach($this->sets as $columnName => $value) |
|
| 42 | + foreach ($this->sets as $columnName => $value) |
|
| 43 | 43 | { |
| 44 | 44 | $type = $this->guessType($columnName, $value); |
| 45 | 45 | |
@@ -22,7 +22,7 @@ discard block |
||
| 22 | 22 | { |
| 23 | 23 | $this->values = []; |
| 24 | 24 | |
| 25 | - if(! empty($values)) |
|
| 25 | + if (!empty($values)) |
|
| 26 | 26 | { |
| 27 | 27 | $this->values($values); |
| 28 | 28 | } |
@@ -37,7 +37,7 @@ discard block |
||
| 37 | 37 | |
| 38 | 38 | public function toString(): string |
| 39 | 39 | { |
| 40 | - if(empty($this->values)) |
|
| 40 | + if (empty($this->values)) |
|
| 41 | 41 | { |
| 42 | 42 | throw new \RuntimeException('No values to insert'); |
| 43 | 43 | } |
@@ -46,9 +46,9 @@ discard block |
||
| 46 | 46 | |
| 47 | 47 | $values = []; |
| 48 | 48 | |
| 49 | - foreach($this->values as $valuesSet) |
|
| 49 | + foreach ($this->values as $valuesSet) |
|
| 50 | 50 | { |
| 51 | - if($columnsNameList !== array_keys($valuesSet)) |
|
| 51 | + if ($columnsNameList !== array_keys($valuesSet)) |
|
| 52 | 52 | { |
| 53 | 53 | throw new \RuntimeException('Cannot insert different schema on the same table.'); |
| 54 | 54 | } |
@@ -67,9 +67,9 @@ discard block |
||
| 67 | 67 | { |
| 68 | 68 | $valuesSet = []; |
| 69 | 69 | |
| 70 | - foreach($values as $columnName => $value) |
|
| 70 | + foreach ($values as $columnName => $value) |
|
| 71 | 71 | { |
| 72 | - if(! empty($columnName)) |
|
| 72 | + if (!empty($columnName)) |
|
| 73 | 73 | { |
| 74 | 74 | $type = $this->guessType($columnName, $value); |
| 75 | 75 | |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | |
| 83 | 83 | private function formatValue(Type $type, $value) |
| 84 | 84 | { |
| 85 | - if(is_null($value)) |
|
| 85 | + if (is_null($value)) |
|
| 86 | 86 | { |
| 87 | 87 | return 'NULL'; |
| 88 | 88 | } |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | { |
| 95 | 95 | $value = $type->format($value); |
| 96 | 96 | |
| 97 | - if($type->isEscapeRequired()) |
|
| 97 | + if ($type->isEscapeRequired()) |
|
| 98 | 98 | { |
| 99 | 99 | $value = $this->escaper->escape($value); |
| 100 | 100 | } |
@@ -9,7 +9,7 @@ |
||
| 9 | 9 | protected |
| 10 | 10 | $groupBy; |
| 11 | 11 | |
| 12 | - public function groupBy(?string $column): self |
|
| 12 | + public function groupBy(? string $column) : self |
|
| 13 | 13 | { |
| 14 | 14 | $this->groupBy->addGroupBy($column); |
| 15 | 15 | |
@@ -27,7 +27,7 @@ discard block |
||
| 27 | 27 | */ |
| 28 | 28 | public function offset($offset): self |
| 29 | 29 | { |
| 30 | - if(!$this->limit instanceof Snippets\Limit) |
|
| 30 | + if (!$this->limit instanceof Snippets\Limit) |
|
| 31 | 31 | { |
| 32 | 32 | throw new \LogicException('LIMIT is required to define OFFSET.'); |
| 33 | 33 | } |
@@ -42,7 +42,7 @@ discard block |
||
| 42 | 42 | $limit = $this->buildLimitClause(); |
| 43 | 43 | |
| 44 | 44 | $offset = ''; |
| 45 | - if(! empty($limit)) |
|
| 45 | + if (!empty($limit)) |
|
| 46 | 46 | { |
| 47 | 47 | $offset = $this->buildOffsetClause(); |
| 48 | 48 | } |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | |
| 55 | 55 | private function buildLimitClause(): string |
| 56 | 56 | { |
| 57 | - if($this->limit instanceof Snippets\Limit) |
|
| 57 | + if ($this->limit instanceof Snippets\Limit) |
|
| 58 | 58 | { |
| 59 | 59 | return $this->limit->toString(); |
| 60 | 60 | } |
@@ -64,7 +64,7 @@ discard block |
||
| 64 | 64 | |
| 65 | 65 | private function buildOffsetClause(): string |
| 66 | 66 | { |
| 67 | - if($this->offset instanceof Snippets\Offset) |
|
| 67 | + if ($this->offset instanceof Snippets\Offset) |
|
| 68 | 68 | { |
| 69 | 69 | return $this->offset->toString(); |
| 70 | 70 | } |
@@ -11,21 +11,21 @@ discard block |
||
| 11 | 11 | protected |
| 12 | 12 | $joins = array(); |
| 13 | 13 | |
| 14 | - public function innerJoin(string $table, ?string $alias = null): self |
|
| 14 | + public function innerJoin(string $table, ? string $alias = null) : self |
|
| 15 | 15 | { |
| 16 | 16 | $this->joins[] = new Snippets\Joins\InnerJoin($table, $alias); |
| 17 | 17 | |
| 18 | 18 | return $this; |
| 19 | 19 | } |
| 20 | 20 | |
| 21 | - public function leftJoin(string $table, ?string $alias = null): self |
|
| 21 | + public function leftJoin(string $table, ? string $alias = null) : self |
|
| 22 | 22 | { |
| 23 | 23 | $this->joins[] = new Snippets\Joins\LeftJoin($table, $alias); |
| 24 | 24 | |
| 25 | 25 | return $this; |
| 26 | 26 | } |
| 27 | 27 | |
| 28 | - public function rightJoin(string $table, ?string $alias = null): self |
|
| 28 | + public function rightJoin(string $table, ? string $alias = null) : self |
|
| 29 | 29 | { |
| 30 | 30 | $this->joins[] = new Snippets\Joins\RightJoin($table, $alias); |
| 31 | 31 | |
@@ -55,7 +55,7 @@ discard block |
||
| 55 | 55 | { |
| 56 | 56 | $joins = []; |
| 57 | 57 | |
| 58 | - foreach($this->joins as $innerJoin) |
|
| 58 | + foreach ($this->joins as $innerJoin) |
|
| 59 | 59 | { |
| 60 | 60 | $joins[] = $innerJoin->toString(); |
| 61 | 61 | } |
@@ -67,7 +67,7 @@ discard block |
||
| 67 | 67 | { |
| 68 | 68 | $lastJoins = end($this->joins); |
| 69 | 69 | |
| 70 | - if(! $lastJoins instanceof Snippets\Join) |
|
| 70 | + if (!$lastJoins instanceof Snippets\Join) |
|
| 71 | 71 | { |
| 72 | 72 | throw new \LogicException('Erreur dans la récupération de la dernière jointure'); |
| 73 | 73 | } |
@@ -15,7 +15,7 @@ discard block |
||
| 15 | 15 | $using, |
| 16 | 16 | $on; |
| 17 | 17 | |
| 18 | - public function __construct(string $table, ?string $alias = null) |
|
| 18 | + public function __construct(string $table, ? string $alias = null) |
|
| 19 | 19 | { |
| 20 | 20 | $this->table = new Snippets\TableName($table, $alias); |
| 21 | 21 | $this->on = []; |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | return $this; |
| 34 | 34 | } |
| 35 | 35 | |
| 36 | - public function on(?string $leftColumn, ?string $rightColumn): self |
|
| 36 | + public function on(? string $leftColumn, ? string $rightColumn) : self |
|
| 37 | 37 | { |
| 38 | 38 | $this->using = null; |
| 39 | 39 | $this->on[] = new Snippets\On($leftColumn, $rightColumn); |
@@ -59,26 +59,26 @@ discard block |
||
| 59 | 59 | |
| 60 | 60 | private function buildUsingConditionClause(): string |
| 61 | 61 | { |
| 62 | - if(!$this->using instanceof Snippet) |
|
| 62 | + if (!$this->using instanceof Snippet) |
|
| 63 | 63 | { |
| 64 | 64 | return ''; |
| 65 | 65 | } |
| 66 | 66 | |
| 67 | - return ' ' . $this->using->toString(); |
|
| 67 | + return ' '.$this->using->toString(); |
|
| 68 | 68 | } |
| 69 | 69 | |
| 70 | 70 | private function buildOnConditionClause(): string |
| 71 | 71 | { |
| 72 | 72 | $conditionClause = array(); |
| 73 | 73 | |
| 74 | - foreach($this->on as $on) |
|
| 74 | + foreach ($this->on as $on) |
|
| 75 | 75 | { |
| 76 | - if($on instanceof Snippet) |
|
| 76 | + if ($on instanceof Snippet) |
|
| 77 | 77 | { |
| 78 | 78 | $conditionClause[] = $on->toString(); |
| 79 | 79 | } |
| 80 | 80 | } |
| 81 | 81 | |
| 82 | - return empty($conditionClause) ? '' : ' ' . implode('', $conditionClause); |
|
| 82 | + return empty($conditionClause) ? '' : ' '.implode('', $conditionClause); |
|
| 83 | 83 | } |
| 84 | 84 | } |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | |
| 25 | 25 | public function toString(): string |
| 26 | 26 | { |
| 27 | - if(is_null($this->offset)) |
|
| 27 | + if (is_null($this->offset)) |
|
| 28 | 28 | { |
| 29 | 29 | return ''; |
| 30 | 30 | } |
@@ -35,14 +35,14 @@ discard block |
||
| 35 | 35 | ); |
| 36 | 36 | } |
| 37 | 37 | |
| 38 | - private function convertToInteger($value): ?int |
|
| 38 | + private function convertToInteger($value): ? int |
|
| 39 | 39 | { |
| 40 | - if($this->isConvertibleToString($value) === false) |
|
| 40 | + if ($this->isConvertibleToString($value) === false) |
|
| 41 | 41 | { |
| 42 | 42 | throw new \InvalidArgumentException("Offset argument must be an integer or an integer wrapped into a string"); |
| 43 | 43 | } |
| 44 | 44 | |
| 45 | - if(preg_match('~^[\d]+$~', (string) $value)) |
|
| 45 | + if (preg_match('~^[\d]+$~', (string) $value)) |
|
| 46 | 46 | { |
| 47 | 47 | return (int) $value; |
| 48 | 48 | } |
@@ -14,9 +14,9 @@ |
||
| 14 | 14 | /** |
| 15 | 15 | * @param TableName|string $table |
| 16 | 16 | */ |
| 17 | - public function __construct($table, ?string $alias = null) |
|
| 17 | + public function __construct($table, ? string $alias = null) |
|
| 18 | 18 | { |
| 19 | - if(! $table instanceof TableName) |
|
| 19 | + if (!$table instanceof TableName) |
|
| 20 | 20 | { |
| 21 | 21 | $table = new TableName($table, $alias); |
| 22 | 22 | } |
@@ -12,7 +12,7 @@ discard block |
||
| 12 | 12 | $leftColumn, |
| 13 | 13 | $rightColumn; |
| 14 | 14 | |
| 15 | - public function __construct(?string $leftColumn, ?string $rightColumn) |
|
| 15 | + public function __construct(? string $leftColumn, ? string $rightColumn) |
|
| 16 | 16 | { |
| 17 | 17 | $this->leftColumn = (string) $leftColumn; |
| 18 | 18 | $this->rightColumn = (string) $rightColumn; |
@@ -20,7 +20,7 @@ discard block |
||
| 20 | 20 | |
| 21 | 21 | public function toString(): string |
| 22 | 22 | { |
| 23 | - if(empty($this->leftColumn) || empty($this->rightColumn)) |
|
| 23 | + if (empty($this->leftColumn) || empty($this->rightColumn)) |
|
| 24 | 24 | { |
| 25 | 25 | return ''; |
| 26 | 26 | } |