@@ -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 |
@@ -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 |
@@ -66,10 +66,10 @@ discard block |
||
66 | 66 | $workArray[] = $value; |
67 | 67 | } |
68 | 68 | |
69 | - $returnString = ''; # Initialize return string |
|
70 | - $arraySize = count($workArray); # Get size of array |
|
69 | + $returnString = ''; # Initialize return string |
|
70 | + $arraySize = count($workArray); # Get size of array |
|
71 | 71 | |
72 | - for ($i=0; $i<$arraySize; $i++) { |
|
72 | + for ($i = 0; $i < $arraySize; $i++) { |
|
73 | 73 | # Nested array, process nest item |
74 | 74 | if (is_array($workArray[$i])) { |
75 | 75 | $returnString .= $this->str_putcsv($workArray[$i], $delimiter, $enclosure, $terminator); |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | switch (gettype($workArray[$i])) { |
78 | 78 | # Manually set some strings |
79 | 79 | case "NULL": $_spFormat = ''; break; |
80 | - case "boolean": $_spFormat = (true == $workArray[$i]) ? 'true': 'false'; break; |
|
80 | + case "boolean": $_spFormat = (true == $workArray[$i]) ? 'true' : 'false'; break; |
|
81 | 81 | # Make sure sprintf has a good datatype to work with |
82 | 82 | case "integer": $_spFormat = '%i'; break; |
83 | 83 | case "double": $_spFormat = '%0.2f'; break; |
@@ -87,8 +87,8 @@ discard block |
||
87 | 87 | case "resource": |
88 | 88 | default: $_spFormat = ''; break; |
89 | 89 | } |
90 | - $returnString .= sprintf('%2$s'.$_spFormat.'%2$s', $workArray[$i], $enclosure); |
|
91 | - $returnString .= ($i < ($arraySize-1)) ? $delimiter : $terminator; |
|
90 | + $returnString .= sprintf('%2$s' . $_spFormat . '%2$s', $workArray[$i], $enclosure); |
|
91 | + $returnString .= ($i < ($arraySize - 1)) ? $delimiter : $terminator; |
|
92 | 92 | } |
93 | 93 | } |
94 | 94 | # Done the workload, return the output information |
@@ -56,17 +56,17 @@ |
||
56 | 56 | if (is_array($sval)) { |
57 | 57 | foreach ($sval as $_skey => $_sval) { |
58 | 58 | if (is_numeric($_skey)) { |
59 | - $data[] = $skey.'[] = '.(is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"'.$_sval.'"')); |
|
59 | + $data[] = $skey . '[] = ' . (is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"' . $_sval . '"')); |
|
60 | 60 | } else { |
61 | - $data[] = $skey.'['.$_skey.'] = '.(is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"'.$_sval.'"')); |
|
61 | + $data[] = $skey . '[' . $_skey . '] = ' . (is_numeric($_sval) ? $_sval : (ctype_upper($_sval) ? $_sval : '"' . $_sval . '"')); |
|
62 | 62 | } |
63 | 63 | } |
64 | 64 | } else { |
65 | - $data[] = $skey.' = '.(is_numeric($sval) ? $sval : (ctype_upper($sval) ? $sval : '"'.$sval.'"')); |
|
65 | + $data[] = $skey . ' = ' . (is_numeric($sval) ? $sval : (ctype_upper($sval) ? $sval : '"' . $sval . '"')); |
|
66 | 66 | } |
67 | 67 | } |
68 | 68 | } else { |
69 | - $data[] = $key.' = '.(is_numeric($val) ? $val : (ctype_upper($val) ? $val : '"'.$val.'"')); |
|
69 | + $data[] = $key . ' = ' . (is_numeric($val) ? $val : (ctype_upper($val) ? $val : '"' . $val . '"')); |
|
70 | 70 | } |
71 | 71 | // empty line |
72 | 72 | $data[] = null; |
@@ -17,19 +17,19 @@ |
||
17 | 17 | const ORDER_ASC = 'ASC'; |
18 | 18 | const ORDER_DESC = 'DESC'; |
19 | 19 | |
20 | - const OPERATION_NULL = 'nul'; // is null |
|
21 | - const OPERATION_NNULL = 'nnul'; // is not null |
|
22 | - const OPERATION_EQ = 'eq'; // = |
|
23 | - const OPERATION_NEQ = 'neq'; // != |
|
24 | - const OPERATION_GT = 'gt'; // > |
|
25 | - const OPERATION_GTE = 'gte'; // >= |
|
26 | - const OPERATION_LT = 'lt'; // < |
|
27 | - const OPERATION_LTE = 'lte'; // <= |
|
28 | - const OPERATION_LIKE = 'like'; // like... |
|
20 | + const OPERATION_NULL = 'nul'; // is null |
|
21 | + const OPERATION_NNULL = 'nnul'; // is not null |
|
22 | + const OPERATION_EQ = 'eq'; // = |
|
23 | + const OPERATION_NEQ = 'neq'; // != |
|
24 | + const OPERATION_GT = 'gt'; // > |
|
25 | + const OPERATION_GTE = 'gte'; // >= |
|
26 | + const OPERATION_LT = 'lt'; // < |
|
27 | + const OPERATION_LTE = 'lte'; // <= |
|
28 | + const OPERATION_LIKE = 'like'; // like... |
|
29 | 29 | const OPERATION_NLIKE = 'nlike'; // not like |
30 | - const OPERATION_REXP = 'rexp'; // regex |
|
31 | - const OPERATION_IN = 'in'; // in () |
|
32 | - const OPERATION_NIN = 'nin'; // not in () |
|
30 | + const OPERATION_REXP = 'rexp'; // regex |
|
31 | + const OPERATION_IN = 'in'; // in () |
|
32 | + const OPERATION_NIN = 'nin'; // not in () |
|
33 | 33 | |
34 | 34 | const AGGREGATE_AVG = 'AVG'; |
35 | 35 | const AGGREGATE_COUNT = 'COUNT'; |
@@ -37,7 +37,7 @@ |
||
37 | 37 | $connection->setAttribute(PDO::ATTR_PERSISTENT, true); |
38 | 38 | } |
39 | 39 | |
40 | - foreach ($this->attributes as $key => $value){ |
|
40 | + foreach ($this->attributes as $key => $value) { |
|
41 | 41 | $connection->setAttribute($key, $value); |
42 | 42 | } |
43 | 43 |
@@ -37,7 +37,7 @@ |
||
37 | 37 | $connection->setAttribute(PDO::ATTR_PERSISTENT, true); |
38 | 38 | } |
39 | 39 | |
40 | - foreach ($this->attributes as $key => $value){ |
|
40 | + foreach ($this->attributes as $key => $value) { |
|
41 | 41 | $connection->setAttribute($key, $value); |
42 | 42 | } |
43 | 43 |