@@ -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 |