@@ -120,12 +120,12 @@ |
||
| 120 | 120 | |
| 121 | 121 | public function lastInsertId(): ?string |
| 122 | 122 | { |
| 123 | - return $this->lastStatement ? strval($this->lastStatement->insert_id) : null ; |
|
| 123 | + return $this->lastStatement ? strval($this->lastStatement->insert_id) : null; |
|
| 124 | 124 | } |
| 125 | 125 | |
| 126 | 126 | public function rowCount(): ?int |
| 127 | 127 | { |
| 128 | - return $this->lastStatement ? intval($this->lastStatement->num_rows) : null ; |
|
| 128 | + return $this->lastStatement ? intval($this->lastStatement->num_rows) : null; |
|
| 129 | 129 | } |
| 130 | 130 | |
| 131 | 131 | public function beginTransaction(): bool |
@@ -59,7 +59,7 @@ |
||
| 59 | 59 | |
| 60 | 60 | public function describe(QueryBuilder $builder) |
| 61 | 61 | { |
| 62 | - return sprintf('SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_name = \'%s\';', $builder->getBaseTable() ); |
|
| 62 | + return sprintf('SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_name = \'%s\';', $builder->getBaseTable()); |
|
| 63 | 63 | } |
| 64 | 64 | |
| 65 | 65 | protected function makeLimits(?int $limit, ?int $offset): string |
@@ -19,10 +19,10 @@ discard block |
||
| 19 | 19 | public function singleSimpleColumn(QueryBuilder\Column $column): string |
| 20 | 20 | { |
| 21 | 21 | $alias = empty($column->getColumnAlias()) ? '' : sprintf(' AS `%s`', $column->getColumnAlias()); |
| 22 | - $where = sprintf('`%s`', $column->getColumnName() ); |
|
| 22 | + $where = sprintf('`%s`', $column->getColumnName()); |
|
| 23 | 23 | return empty($column->getAggregate()) |
| 24 | - ? sprintf('%s%s', $where, $alias ) |
|
| 25 | - : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias ) |
|
| 24 | + ? sprintf('%s%s', $where, $alias) |
|
| 25 | + : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias) |
|
| 26 | 26 | ; |
| 27 | 27 | } |
| 28 | 28 | |
@@ -30,12 +30,12 @@ discard block |
||
| 30 | 30 | { |
| 31 | 31 | $alias = empty($column->getColumnAlias()) ? '' : sprintf(' AS `%s`', $column->getColumnAlias()); |
| 32 | 32 | $where = empty($column->getTableName()) |
| 33 | - ? sprintf('`%s`', $column->getColumnName() ) |
|
| 33 | + ? sprintf('`%s`', $column->getColumnName()) |
|
| 34 | 34 | : sprintf('`%s`.`%s`', $column->getTableName(), $column->getColumnName()) |
| 35 | 35 | ; |
| 36 | 36 | return empty($column->getAggregate()) |
| 37 | - ? sprintf('%s%s', $where, $alias ) |
|
| 38 | - : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias ) |
|
| 37 | + ? sprintf('%s%s', $where, $alias) |
|
| 38 | + : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias) |
|
| 39 | 39 | ; |
| 40 | 40 | } |
| 41 | 41 | |
@@ -49,14 +49,14 @@ discard block |
||
| 49 | 49 | |
| 50 | 50 | public function singleSimplePropertyListed(QueryBuilder\Property $column): string |
| 51 | 51 | { |
| 52 | - return sprintf('`%s`', $column->getColumnName() ); |
|
| 52 | + return sprintf('`%s`', $column->getColumnName()); |
|
| 53 | 53 | } |
| 54 | 54 | |
| 55 | 55 | public function singleFullPropertyListed(QueryBuilder\Property $column): string |
| 56 | 56 | { |
| 57 | 57 | return empty($column->getTableName()) |
| 58 | - ? sprintf('`%s`', $column->getColumnName() ) |
|
| 59 | - : sprintf('`%s`.`%s`', $column->getTableName(), $column->getColumnName() ) |
|
| 58 | + ? sprintf('`%s`', $column->getColumnName()) |
|
| 59 | + : sprintf('`%s`.`%s`', $column->getTableName(), $column->getColumnName()) |
|
| 60 | 60 | ; |
| 61 | 61 | } |
| 62 | 62 | |
@@ -88,14 +88,14 @@ discard block |
||
| 88 | 88 | |
| 89 | 89 | public function singleSimpleOrder(QueryBuilder\Order $order): string |
| 90 | 90 | { |
| 91 | - return sprintf('`%s` %s', $order->getColumnName(), $order->getDirection() ); |
|
| 91 | + return sprintf('`%s` %s', $order->getColumnName(), $order->getDirection()); |
|
| 92 | 92 | } |
| 93 | 93 | |
| 94 | 94 | public function singleFullOrder(QueryBuilder\Order $order): string |
| 95 | 95 | { |
| 96 | 96 | return empty($order->getTableName()) |
| 97 | - ? sprintf('`%s` %s', $order->getColumnName(), $order->getDirection() ) |
|
| 98 | - : sprintf('`%s`.`%s` %s', $order->getTableName(), $order->getColumnName(), $order->getDirection() ) |
|
| 97 | + ? sprintf('`%s` %s', $order->getColumnName(), $order->getDirection()) |
|
| 98 | + : sprintf('`%s`.`%s` %s', $order->getTableName(), $order->getColumnName(), $order->getDirection()) |
|
| 99 | 99 | ; |
| 100 | 100 | } |
| 101 | 101 | |
@@ -61,7 +61,7 @@ |
||
| 61 | 61 | |
| 62 | 62 | public function describe(QueryBuilder $builder) |
| 63 | 63 | { |
| 64 | - return sprintf('DESCRIBE `%s`;', $builder->getBaseTable() ); |
|
| 64 | + return sprintf('DESCRIBE `%s`;', $builder->getBaseTable()); |
|
| 65 | 65 | } |
| 66 | 66 | |
| 67 | 67 | protected function makeLimits(?int $limit, ?int $offset): string |
@@ -83,7 +83,7 @@ |
||
| 83 | 83 | |
| 84 | 84 | public function describe(QueryBuilder $builder) |
| 85 | 85 | { |
| 86 | - return sprintf('SELECT "sql" FROM "sqlite_master" WHERE "name" = \'%s\';', $builder->getBaseTable() ); |
|
| 86 | + return sprintf('SELECT "sql" FROM "sqlite_master" WHERE "name" = \'%s\';', $builder->getBaseTable()); |
|
| 87 | 87 | } |
| 88 | 88 | |
| 89 | 89 | protected function makeLimits(?int $limit, ?int $offset): string |
@@ -98,7 +98,7 @@ |
||
| 98 | 98 | { |
| 99 | 99 | $columns = []; |
| 100 | 100 | foreach ($ordering as $column) { |
| 101 | - $columns[$column->getColumnName()] = (IQueryBuilder::ORDER_ASC == $column->getDirection() ? 1 : -1 ); |
|
| 101 | + $columns[$column->getColumnName()] = (IQueryBuilder::ORDER_ASC == $column->getDirection() ? 1 : -1); |
|
| 102 | 102 | } |
| 103 | 103 | return $columns; |
| 104 | 104 | } |
@@ -84,7 +84,7 @@ |
||
| 84 | 84 | |
| 85 | 85 | public function describe(QueryBuilder $builder) |
| 86 | 86 | { |
| 87 | - return sprintf('SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'%s\';', $builder->getBaseTable() ); |
|
| 87 | + return sprintf('SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = \'%s\';', $builder->getBaseTable()); |
|
| 88 | 88 | } |
| 89 | 89 | |
| 90 | 90 | protected function makeLimit(?int $limit): string |
@@ -60,7 +60,7 @@ |
||
| 60 | 60 | |
| 61 | 61 | public function describe(QueryBuilder $builder) |
| 62 | 62 | { |
| 63 | - return sprintf('DESCRIBE `%s`;', $builder->getBaseTable() ); |
|
| 63 | + return sprintf('DESCRIBE `%s`;', $builder->getBaseTable()); |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | /** |
@@ -19,10 +19,10 @@ discard block |
||
| 19 | 19 | public function singleSimpleColumn(QueryBuilder\Column $column): string |
| 20 | 20 | { |
| 21 | 21 | $alias = empty($column->getColumnAlias()) ? '' : sprintf(' AS %s', $column->getColumnAlias()); |
| 22 | - $where = sprintf('%s', $column->getColumnName() ); |
|
| 22 | + $where = sprintf('%s', $column->getColumnName()); |
|
| 23 | 23 | return empty($column->getAggregate()) |
| 24 | - ? sprintf('%s%s', $where, $alias ) |
|
| 25 | - : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias ) |
|
| 24 | + ? sprintf('%s%s', $where, $alias) |
|
| 25 | + : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias) |
|
| 26 | 26 | ; |
| 27 | 27 | } |
| 28 | 28 | |
@@ -30,12 +30,12 @@ discard block |
||
| 30 | 30 | { |
| 31 | 31 | $alias = empty($column->getColumnAlias()) ? '' : sprintf(' AS %s', $column->getColumnAlias()); |
| 32 | 32 | $where = empty($column->getTableName()) |
| 33 | - ? sprintf('%s', $column->getColumnName() ) |
|
| 33 | + ? sprintf('%s', $column->getColumnName()) |
|
| 34 | 34 | : sprintf('%s.%s', $column->getTableName(), $column->getColumnName()) |
| 35 | 35 | ; |
| 36 | 36 | return empty($column->getAggregate()) |
| 37 | - ? sprintf('%s%s', $where, $alias ) |
|
| 38 | - : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias ) |
|
| 37 | + ? sprintf('%s%s', $where, $alias) |
|
| 38 | + : sprintf('%s(%s)%s', $column->getAggregate(), $where, $alias) |
|
| 39 | 39 | ; |
| 40 | 40 | } |
| 41 | 41 | |
@@ -49,14 +49,14 @@ discard block |
||
| 49 | 49 | |
| 50 | 50 | public function singleSimplePropertyListed(QueryBuilder\Property $column): string |
| 51 | 51 | { |
| 52 | - return sprintf('%s', $column->getColumnName() ); |
|
| 52 | + return sprintf('%s', $column->getColumnName()); |
|
| 53 | 53 | } |
| 54 | 54 | |
| 55 | 55 | public function singleFullPropertyListed(QueryBuilder\Property $column): string |
| 56 | 56 | { |
| 57 | 57 | return empty($column->getTableName()) |
| 58 | - ? sprintf('%s', $column->getColumnName() ) |
|
| 59 | - : sprintf('%s.%s', $column->getTableName(), $column->getColumnName() ) |
|
| 58 | + ? sprintf('%s', $column->getColumnName()) |
|
| 59 | + : sprintf('%s.%s', $column->getTableName(), $column->getColumnName()) |
|
| 60 | 60 | ; |
| 61 | 61 | } |
| 62 | 62 | |
@@ -93,14 +93,14 @@ discard block |
||
| 93 | 93 | |
| 94 | 94 | public function singleSimpleOrder(QueryBuilder\Order $order): string |
| 95 | 95 | { |
| 96 | - return sprintf('%s %s', $order->getColumnName(), $order->getDirection() ); |
|
| 96 | + return sprintf('%s %s', $order->getColumnName(), $order->getDirection()); |
|
| 97 | 97 | } |
| 98 | 98 | |
| 99 | 99 | public function singleFullOrder(QueryBuilder\Order $order): string |
| 100 | 100 | { |
| 101 | 101 | return empty($order->getTableName()) |
| 102 | - ? sprintf('%s %s', $order->getColumnName(), $order->getDirection() ) |
|
| 103 | - : sprintf('%s.%s %s', $order->getTableName(), $order->getColumnName(), $order->getDirection() ) |
|
| 102 | + ? sprintf('%s %s', $order->getColumnName(), $order->getDirection()) |
|
| 103 | + : sprintf('%s.%s %s', $order->getTableName(), $order->getColumnName(), $order->getDirection()) |
|
| 104 | 104 | ; |
| 105 | 105 | } |
| 106 | 106 | |