@@ -148,7 +148,7 @@ discard block |
||
148 | 148 | |
149 | 149 | $body = $this->response()->body(); |
150 | 150 | $error_no = $this->response()->error_no(); |
151 | - $error=$this->response()->error(); |
|
151 | + $error = $this->response()->error(); |
|
152 | 152 | |
153 | 153 | if (!$error_no && !$error) { |
154 | 154 | $parse = $this->parseErrorClickHouse($body); |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | } |
159 | 159 | else { |
160 | 160 | $code = $this->response()->http_code(); |
161 | - $message = "HttpCode:" . $this->response()->http_code() . " ; ".$this->response()->error()." ;" . $body; |
|
161 | + $message = "HttpCode:" . $this->response()->http_code() . " ; " . $this->response()->error() . " ;" . $body; |
|
162 | 162 | } |
163 | 163 | } |
164 | 164 | else { |
@@ -212,7 +212,7 @@ discard block |
||
212 | 212 | return false; |
213 | 213 | } |
214 | 214 | |
215 | - foreach (['meta', 'data', 'totals', 'extremes', 'rows', 'rows_before_limit_at_least','statistics'] as $key) { |
|
215 | + foreach (['meta', 'data', 'totals', 'extremes', 'rows', 'rows_before_limit_at_least', 'statistics'] as $key) { |
|
216 | 216 | if (isset($this->_rawData[$key])) { |
217 | 217 | $this->{$key} = $this->_rawData[$key]; |
218 | 218 | } |
@@ -325,7 +325,7 @@ discard block |
||
325 | 325 | * @param bool $key |
326 | 326 | * @return array|mixed|null |
327 | 327 | */ |
328 | - public function statistics($key=false) |
|
328 | + public function statistics($key = false) |
|
329 | 329 | { |
330 | 330 | $this->init(); |
331 | 331 | if ($key) |
@@ -155,13 +155,11 @@ discard block |
||
155 | 155 | |
156 | 156 | if ($parse) { |
157 | 157 | throw new DatabaseException($parse['message'] . "\nIN:" . $this->sql(), $parse['code']); |
158 | - } |
|
159 | - else { |
|
158 | + } else { |
|
160 | 159 | $code = $this->response()->http_code(); |
161 | 160 | $message = "HttpCode:" . $this->response()->http_code() . " ; ".$this->response()->error()." ;" . $body; |
162 | 161 | } |
163 | - } |
|
164 | - else { |
|
162 | + } else { |
|
165 | 163 | $code = $error_no; |
166 | 164 | $message = $this->response()->error(); |
167 | 165 | } |
@@ -330,8 +328,12 @@ discard block |
||
330 | 328 | $this->init(); |
331 | 329 | if ($key) |
332 | 330 | { |
333 | - if (!is_array($this->statistics)) return null; |
|
334 | - if (!isset($this->statistics[$key])) return null; |
|
331 | + if (!is_array($this->statistics)) { |
|
332 | + return null; |
|
333 | + } |
|
334 | + if (!isset($this->statistics[$key])) { |
|
335 | + return null; |
|
336 | + } |
|
335 | 337 | return $this->statistics[$key]; |
336 | 338 | } |
337 | 339 | return $this->statistics; |
@@ -373,8 +375,7 @@ discard block |
||
373 | 375 | if ($key) { |
374 | 376 | if (isset($this->array_data[0][$key])) { |
375 | 377 | return $this->array_data[0][$key]; |
376 | - } |
|
377 | - else { |
|
378 | + } else { |
|
378 | 379 | return null; |
379 | 380 | } |
380 | 381 | } |
@@ -464,16 +465,14 @@ discard block |
||
464 | 465 | { |
465 | 466 | if (is_array($path)) { |
466 | 467 | $keys = $path; |
467 | - } |
|
468 | - else { |
|
468 | + } else { |
|
469 | 469 | $args = func_get_args(); |
470 | 470 | array_shift($args); |
471 | 471 | |
472 | 472 | if (sizeof($args) < 2) { |
473 | 473 | $separator = '.'; |
474 | 474 | $keys = explode($separator, $path); |
475 | - } |
|
476 | - else { |
|
475 | + } else { |
|
477 | 476 | $keys = $args; |
478 | 477 | } |
479 | 478 | } |
@@ -485,8 +484,7 @@ discard block |
||
485 | 484 | |
486 | 485 | if (isset($arr[$key])) { |
487 | 486 | $val = $arr[$key]; |
488 | - } |
|
489 | - else { |
|
487 | + } else { |
|
490 | 488 | $val = $key; |
491 | 489 | } |
492 | 490 |
@@ -6,7 +6,7 @@ discard block |
||
6 | 6 | class StrictQuoteLine |
7 | 7 | { |
8 | 8 | |
9 | - private $preset=[ |
|
9 | + private $preset = [ |
|
10 | 10 | 'CSV'=>[ |
11 | 11 | 'EnclosureArray'=>'"', |
12 | 12 | 'EncodeEnclosure'=>'"', |
@@ -32,19 +32,19 @@ discard block |
||
32 | 32 | 'TabEncode'=>true, |
33 | 33 | ], |
34 | 34 | ]; |
35 | - private $settings=[]; |
|
35 | + private $settings = []; |
|
36 | 36 | |
37 | 37 | public function __construct($format) |
38 | 38 | { |
39 | 39 | if (empty($this->preset[$format])) |
40 | 40 | { |
41 | - throw new QueryException("Unsupport format encode line:".$format); |
|
41 | + throw new QueryException("Unsupport format encode line:" . $format); |
|
42 | 42 | } |
43 | - $this->settings=$this->preset[$format]; |
|
43 | + $this->settings = $this->preset[$format]; |
|
44 | 44 | } |
45 | 45 | public function quoteRow($row) |
46 | 46 | { |
47 | - return implode($this->settings['Delimiter'],$this->quoteValue($row)); |
|
47 | + return implode($this->settings['Delimiter'], $this->quoteValue($row)); |
|
48 | 48 | } |
49 | 49 | public function quoteValue($row) |
50 | 50 | { |
@@ -53,10 +53,10 @@ discard block |
||
53 | 53 | $encode = $this->settings['EncodeEnclosure']; |
54 | 54 | $encodeArray = $this->settings['EnclosureArray']; |
55 | 55 | $null = $this->settings['Null']; |
56 | - $tabEncode=$this->settings['TabEncode']; |
|
56 | + $tabEncode = $this->settings['TabEncode']; |
|
57 | 57 | |
58 | 58 | |
59 | - $quote = function ($value) use ($enclosure,$delimiter,$encode,$encodeArray,$null,$tabEncode) { |
|
59 | + $quote = function($value) use ($enclosure, $delimiter, $encode, $encodeArray, $null, $tabEncode) { |
|
60 | 60 | |
61 | 61 | |
62 | 62 | |
@@ -75,11 +75,11 @@ discard block |
||
75 | 75 | if (is_string($value)) { |
76 | 76 | if ($tabEncode) |
77 | 77 | { |
78 | - return str_replace(["\t","\n"],['\\t','\\n'],$value); |
|
78 | + return str_replace(["\t", "\n"], ['\\t', '\\n'], $value); |
|
79 | 79 | } |
80 | 80 | |
81 | 81 | $value = strval($value); |
82 | - $value = preg_replace('/('.$enclosure_esc.'|'.$encode_esc.')/',$encode_esc.'\1', $value); |
|
82 | + $value = preg_replace('/(' . $enclosure_esc . '|' . $encode_esc . ')/', $encode_esc . '\1', $value); |
|
83 | 83 | return $enclosure . $value . $enclosure; |
84 | 84 | } |
85 | 85 | |
@@ -90,7 +90,7 @@ discard block |
||
90 | 90 | // as in the TabSeparated format, and then the resulting string is output in InsertRow in double quotes. |
91 | 91 | $result_array = FormatLine::Insert($value); |
92 | 92 | |
93 | - return $encodeArray . '[' . $result_array . ']' .$encodeArray; |
|
93 | + return $encodeArray . '[' . $result_array . ']' . $encodeArray; |
|
94 | 94 | } |
95 | 95 | |
96 | 96 | if (null === $value) { |
@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | * |
9 | 9 | * @var array |
10 | 10 | */ |
11 | - private static $strict=[]; |
|
11 | + private static $strict = []; |
|
12 | 12 | |
13 | 13 | /** |
14 | 14 | * Format |
@@ -20,7 +20,7 @@ discard block |
||
20 | 20 | { |
21 | 21 | if (empty(self::$strict[$format])) |
22 | 22 | { |
23 | - self::$strict[$format]=new StrictQuoteLine($format); |
|
23 | + self::$strict[$format] = new StrictQuoteLine($format); |
|
24 | 24 | } |
25 | 25 | return self::$strict[$format]; |
26 | 26 | } |
@@ -60,7 +60,7 @@ |
||
60 | 60 | } |
61 | 61 | if ($format) |
62 | 62 | { |
63 | - $this->setFormat($format); |
|
63 | + $this->setFormat($format); |
|
64 | 64 | } |
65 | 65 | $this->file_name=$file_name; |
66 | 66 | } |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | const FORMAT_TabSeparatedWithNames = 'TabSeparatedWithNames'; |
14 | 14 | const FORMAT_CSV = 'CSV'; |
15 | 15 | |
16 | - private $support_format=['TabSeparated','TabSeparatedWithNames','CSV']; |
|
16 | + private $support_format = ['TabSeparated', 'TabSeparatedWithNames', 'CSV']; |
|
17 | 17 | /** |
18 | 18 | * @var string |
19 | 19 | */ |
@@ -22,19 +22,19 @@ discard block |
||
22 | 22 | /** |
23 | 23 | * @var string |
24 | 24 | */ |
25 | - private $format='CSV'; |
|
25 | + private $format = 'CSV'; |
|
26 | 26 | |
27 | 27 | /** |
28 | 28 | * @var bool |
29 | 29 | */ |
30 | - private $gzip=false; |
|
30 | + private $gzip = false; |
|
31 | 31 | /** |
32 | 32 | * WriteToFile constructor. |
33 | 33 | * @param $file_name |
34 | 34 | * @param bool $overwrite |
35 | 35 | * @param null $format |
36 | 36 | */ |
37 | - public function __construct($file_name,$overwrite=true,$format=null) { |
|
37 | + public function __construct($file_name, $overwrite = true, $format = null) { |
|
38 | 38 | |
39 | 39 | |
40 | 40 | if (!$file_name) |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | throw new QueryException('Can`t delete: ' . $file_name); |
54 | 54 | } |
55 | 55 | } |
56 | - $dir=dirname($file_name); |
|
56 | + $dir = dirname($file_name); |
|
57 | 57 | if (!is_writable($dir)) |
58 | 58 | { |
59 | 59 | throw new QueryException('Can`t writable dir: ' . $dir); |
@@ -62,7 +62,7 @@ discard block |
||
62 | 62 | { |
63 | 63 | $this->setFormat($format); |
64 | 64 | } |
65 | - $this->file_name=$file_name; |
|
65 | + $this->file_name = $file_name; |
|
66 | 66 | } |
67 | 67 | |
68 | 68 | /** |
@@ -78,7 +78,7 @@ discard block |
||
78 | 78 | */ |
79 | 79 | public function setGzip($flag) |
80 | 80 | { |
81 | - $this->gzip=$flag; |
|
81 | + $this->gzip = $flag; |
|
82 | 82 | } |
83 | 83 | |
84 | 84 | /** |
@@ -86,11 +86,11 @@ discard block |
||
86 | 86 | */ |
87 | 87 | public function setFormat($format) |
88 | 88 | { |
89 | - if (!in_array($format,$this->support_format)) |
|
89 | + if (!in_array($format, $this->support_format)) |
|
90 | 90 | { |
91 | 91 | throw new QueryException('Unsupport format: ' . $format); |
92 | 92 | } |
93 | - $this->format=$format; |
|
93 | + $this->format = $format; |
|
94 | 94 | } |
95 | 95 | /** |
96 | 96 | * @return int |
@@ -19,21 +19,21 @@ discard block |
||
19 | 19 | /** |
20 | 20 | * @var array |
21 | 21 | */ |
22 | - private $degenerations=[]; |
|
22 | + private $degenerations = []; |
|
23 | 23 | |
24 | 24 | /** |
25 | 25 | * Query constructor. |
26 | 26 | * @param $sql |
27 | 27 | * @param array $degenerations |
28 | 28 | */ |
29 | - public function __construct($sql,$degenerations=[]) |
|
29 | + public function __construct($sql, $degenerations = []) |
|
30 | 30 | { |
31 | 31 | if (!trim($sql)) |
32 | 32 | { |
33 | 33 | throw new QueryException('Empty Query'); |
34 | 34 | } |
35 | 35 | $this->sql = $sql; |
36 | - $this->degenerations=$degenerations; |
|
36 | + $this->degenerations = $degenerations; |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | /** |
@@ -49,17 +49,17 @@ discard block |
||
49 | 49 | { |
50 | 50 | // FORMAT\s(\w)*$ |
51 | 51 | if (null === $this->format) return false; |
52 | - $supportFormats= |
|
52 | + $supportFormats = |
|
53 | 53 | "FORMAT\\s+TSV|FORMAT\\s+TSVRaw|FORMAT\\s+TSVWithNames|FORMAT\\s+TSVWithNamesAndTypes|FORMAT\\s+Vertical|FORMAT\\s+JSONCompact|FORMAT\\s+JSONEachRow|FORMAT\\s+TSKV|FORMAT\\s+TabSeparatedWithNames|FORMAT\\s+TabSeparatedWithNamesAndTypes|FORMAT\\s+TabSeparatedRaw|FORMAT\\s+BlockTabSeparated|FORMAT\\s+CSVWithNames|FORMAT\\s+CSV|FORMAT\\s+JSON|FORMAT\\s+TabSeparated"; |
54 | 54 | |
55 | - $matches=[]; |
|
56 | - if (preg_match_all('%('.$supportFormats.')%ius',$this->sql,$matches)){ |
|
55 | + $matches = []; |
|
56 | + if (preg_match_all('%(' . $supportFormats . ')%ius', $this->sql, $matches)) { |
|
57 | 57 | |
58 | 58 | // skip add "format json" |
59 | 59 | if (isset($matches[0])) |
60 | 60 | { |
61 | - $format=trim(str_ireplace('format','',$matches[0][0])); |
|
62 | - $this->format=$format; |
|
61 | + $format = trim(str_ireplace('format', '', $matches[0][0])); |
|
62 | + $this->format = $format; |
|
63 | 63 | |
64 | 64 | } |
65 | 65 | } |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | foreach ($this->degenerations as $degeneration) |
94 | 94 | { |
95 | 95 | if ($degeneration instanceof \ClickHouseDB\Query\Degeneration) |
96 | - $this->sql=$degeneration->process($this->sql); |
|
96 | + $this->sql = $degeneration->process($this->sql); |
|
97 | 97 | } |
98 | 98 | } |
99 | 99 |
@@ -48,7 +48,9 @@ discard block |
||
48 | 48 | private function applyFormatQuery() |
49 | 49 | { |
50 | 50 | // FORMAT\s(\w)*$ |
51 | - if (null === $this->format) return false; |
|
51 | + if (null === $this->format) { |
|
52 | + return false; |
|
53 | + } |
|
52 | 54 | $supportFormats= |
53 | 55 | "FORMAT\\s+TSV|FORMAT\\s+TSVRaw|FORMAT\\s+TSVWithNames|FORMAT\\s+TSVWithNamesAndTypes|FORMAT\\s+Vertical|FORMAT\\s+JSONCompact|FORMAT\\s+JSONEachRow|FORMAT\\s+TSKV|FORMAT\\s+TabSeparatedWithNames|FORMAT\\s+TabSeparatedWithNamesAndTypes|FORMAT\\s+TabSeparatedRaw|FORMAT\\s+BlockTabSeparated|FORMAT\\s+CSVWithNames|FORMAT\\s+CSV|FORMAT\\s+JSON|FORMAT\\s+TabSeparated"; |
54 | 56 | |
@@ -62,8 +64,7 @@ discard block |
||
62 | 64 | $this->format=$format; |
63 | 65 | |
64 | 66 | } |
65 | - } |
|
66 | - else { |
|
67 | + } else { |
|
67 | 68 | $this->sql = $this->sql . ' FORMAT ' . $this->format; |
68 | 69 | } |
69 | 70 | |
@@ -92,8 +93,9 @@ discard block |
||
92 | 93 | { |
93 | 94 | foreach ($this->degenerations as $degeneration) |
94 | 95 | { |
95 | - if ($degeneration instanceof \ClickHouseDB\Query\Degeneration) |
|
96 | - $this->sql=$degeneration->process($this->sql); |
|
96 | + if ($degeneration instanceof \ClickHouseDB\Query\Degeneration) { |
|
97 | + $this->sql=$degeneration->process($this->sql); |
|
98 | + } |
|
97 | 99 | } |
98 | 100 | } |
99 | 101 |
@@ -13,7 +13,7 @@ |
||
13 | 13 | */ |
14 | 14 | public function bindParams(array $bindings) |
15 | 15 | { |
16 | - $this->bindings=[]; |
|
16 | + $this->bindings = []; |
|
17 | 17 | foreach ($bindings as $column => $value) { |
18 | 18 | $this->bindParam($column, $value); |
19 | 19 | } |
@@ -17,44 +17,44 @@ discard block |
||
17 | 17 | public function bindParams(array $bindings) |
18 | 18 | { |
19 | 19 | foreach ($bindings as $column => $value) { |
20 | - $this->bindings[$column]=$value; |
|
20 | + $this->bindings[$column] = $value; |
|
21 | 21 | } |
22 | 22 | } |
23 | 23 | |
24 | 24 | |
25 | - static function __ifsets($matches,$markers,$else=false) |
|
25 | + static function __ifsets($matches, $markers, $else = false) |
|
26 | 26 | { |
27 | - $content_false=''; |
|
27 | + $content_false = ''; |
|
28 | 28 | |
29 | 29 | if ($else) |
30 | 30 | { |
31 | - list($condition, $preset ,$variable, $content_true, $content_false) = $matches; |
|
31 | + list($condition, $preset, $variable, $content_true, $content_false) = $matches; |
|
32 | 32 | } |
33 | 33 | else |
34 | 34 | { |
35 | - list($condition, $preset ,$variable, $content_true) = $matches; |
|
35 | + list($condition, $preset, $variable, $content_true) = $matches; |
|
36 | 36 | } |
37 | - $preset=strtolower($preset); |
|
37 | + $preset = strtolower($preset); |
|
38 | 38 | |
39 | - if ($preset=='set') |
|
39 | + if ($preset == 'set') |
|
40 | 40 | { |
41 | - return (isset($markers[$variable]) && !empty($markers[$variable])) ? $content_true: $content_false; |
|
41 | + return (isset($markers[$variable]) && !empty($markers[$variable])) ? $content_true : $content_false; |
|
42 | 42 | } |
43 | - if ($preset=='bool') |
|
43 | + if ($preset == 'bool') |
|
44 | 44 | { |
45 | - return (isset($markers[$variable]) && is_bool($markers[$variable]) && $markers[$variable]==true) |
|
45 | + return (isset($markers[$variable]) && is_bool($markers[$variable]) && $markers[$variable] == true) |
|
46 | 46 | ? $content_true |
47 | 47 | : $content_false; |
48 | 48 | } |
49 | - if ($preset=='string') |
|
49 | + if ($preset == 'string') |
|
50 | 50 | { |
51 | 51 | return (isset($markers[$variable]) && is_string($markers[$variable]) && strlen($markers[$variable])) |
52 | 52 | ? $content_true |
53 | 53 | : $content_false; |
54 | 54 | } |
55 | - if ($preset=='int') |
|
55 | + if ($preset == 'int') |
|
56 | 56 | { |
57 | - return (isset($markers[$variable]) && intval($markers[$variable])<>0 ) |
|
57 | + return (isset($markers[$variable]) && intval($markers[$variable]) <> 0) |
|
58 | 58 | ? $content_true |
59 | 59 | : $content_false; |
60 | 60 | } |
@@ -68,29 +68,29 @@ discard block |
||
68 | 68 | */ |
69 | 69 | public function process($sql) |
70 | 70 | { |
71 | - $markers=$this->bindings; |
|
71 | + $markers = $this->bindings; |
|
72 | 72 | |
73 | 73 | // 2. process if/else conditions |
74 | - $sql = preg_replace_callback('#\{if\s(.+?)}(.+?)\{else}(.+?)\{/if}#sui', function ($matches) use ($markers) { |
|
74 | + $sql = preg_replace_callback('#\{if\s(.+?)}(.+?)\{else}(.+?)\{/if}#sui', function($matches) use ($markers) { |
|
75 | 75 | list($condition, $variable, $content_true, $content_false) = $matches; |
76 | 76 | |
77 | - return (isset($markers[$variable]) && ( $markers[$variable] || is_numeric($markers[$variable]) ) ) |
|
77 | + return (isset($markers[$variable]) && ($markers[$variable] || is_numeric($markers[$variable]))) |
|
78 | 78 | ? $content_true |
79 | 79 | : $content_false; |
80 | 80 | }, $sql); |
81 | 81 | |
82 | 82 | // 3. process if conditions |
83 | - $sql = preg_replace_callback('#\{if\s(.+?)}(.+?)\{/if}#sui', function ($matches) use ($markers) { |
|
83 | + $sql = preg_replace_callback('#\{if\s(.+?)}(.+?)\{/if}#sui', function($matches) use ($markers) { |
|
84 | 84 | list($condition, $variable, $content) = $matches; |
85 | 85 | |
86 | - if (isset($markers[$variable]) && ( $markers[$variable] || is_numeric($markers[$variable]) )) { |
|
86 | + if (isset($markers[$variable]) && ($markers[$variable] || is_numeric($markers[$variable]))) { |
|
87 | 87 | return $content; |
88 | 88 | } |
89 | 89 | }, $sql); |
90 | 90 | |
91 | 91 | // 1. process if[set|int]/else conditions |
92 | - $sql = preg_replace_callback('#\{if(.{1,}?)\s(.+?)}(.+?)\{else}(.+?)\{/if}#sui', function ($matches) use ($markers) {return self::__ifsets($matches,$markers,true); }, $sql); |
|
93 | - $sql = preg_replace_callback('#\{if(.{1,}?)\s(.+?)}(.+?)\{/if}#sui', function ($matches) use ($markers) { return self::__ifsets($matches,$markers,false); }, $sql); |
|
92 | + $sql = preg_replace_callback('#\{if(.{1,}?)\s(.+?)}(.+?)\{else}(.+?)\{/if}#sui', function($matches) use ($markers) {return self::__ifsets($matches, $markers, true); }, $sql); |
|
93 | + $sql = preg_replace_callback('#\{if(.{1,}?)\s(.+?)}(.+?)\{/if}#sui', function($matches) use ($markers) { return self::__ifsets($matches, $markers, false); }, $sql); |
|
94 | 94 | |
95 | 95 | return $sql; |
96 | 96 | } |
@@ -29,8 +29,7 @@ |
||
29 | 29 | if ($else) |
30 | 30 | { |
31 | 31 | list($condition, $preset ,$variable, $content_true, $content_false) = $matches; |
32 | - } |
|
33 | - else |
|
32 | + } else |
|
34 | 33 | { |
35 | 34 | list($condition, $preset ,$variable, $content_true) = $matches; |
36 | 35 | } |
@@ -177,7 +177,7 @@ |
||
177 | 177 | */ |
178 | 178 | public function setTimeout($timeout) |
179 | 179 | { |
180 | - return $this->settings()->max_execution_time($timeout); |
|
180 | + return $this->settings()->max_execution_time($timeout); |
|
181 | 181 | } |
182 | 182 | |
183 | 183 | /** |
@@ -38,11 +38,11 @@ discard block |
||
38 | 38 | /** |
39 | 39 | * @var bool |
40 | 40 | */ |
41 | - private $_connect_user_readonly=false; |
|
41 | + private $_connect_user_readonly = false; |
|
42 | 42 | /** |
43 | 43 | * @var array |
44 | 44 | */ |
45 | - private $_support_format=['TabSeparated','TabSeparatedWithNames','CSV','CSVWithNames','JSONEachRow']; |
|
45 | + private $_support_format = ['TabSeparated', 'TabSeparatedWithNames', 'CSV', 'CSVWithNames', 'JSONEachRow']; |
|
46 | 46 | |
47 | 47 | /** |
48 | 48 | * Client constructor. |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | */ |
120 | 120 | public function setReadOnlyUser($flag) |
121 | 121 | { |
122 | - $this->_connect_user_readonly=$flag; |
|
122 | + $this->_connect_user_readonly = $flag; |
|
123 | 123 | $this->settings()->setReadOnlyUser($this->_connect_user_readonly); |
124 | 124 | } |
125 | 125 | /** |
@@ -162,10 +162,10 @@ discard block |
||
162 | 162 | |
163 | 163 | if (is_array($host)) |
164 | 164 | { |
165 | - $host=array_rand(array_flip($host)); |
|
165 | + $host = array_rand(array_flip($host)); |
|
166 | 166 | } |
167 | 167 | |
168 | - $this->_connect_host=$host; |
|
168 | + $this->_connect_host = $host; |
|
169 | 169 | $this->transport()->setHost($host); |
170 | 170 | } |
171 | 171 | |
@@ -288,7 +288,7 @@ discard block |
||
288 | 288 | /** |
289 | 289 | * @return $this |
290 | 290 | */ |
291 | - public function useSession($useSessionId=false) |
|
291 | + public function useSession($useSessionId = false) |
|
292 | 292 | { |
293 | 293 | if (!$this->settings()->getSessionId()) |
294 | 294 | { |
@@ -344,7 +344,7 @@ discard block |
||
344 | 344 | */ |
345 | 345 | public function enableLogQueries($flag = true) |
346 | 346 | { |
347 | - $this->settings()->set('log_queries',intval($flag)); |
|
347 | + $this->settings()->set('log_queries', intval($flag)); |
|
348 | 348 | return $this; |
349 | 349 | } |
350 | 350 | |
@@ -366,7 +366,7 @@ discard block |
||
366 | 366 | * @param bool $flag |
367 | 367 | * @return $this |
368 | 368 | */ |
369 | - public function https($flag=true) |
|
369 | + public function https($flag = true) |
|
370 | 370 | { |
371 | 371 | $this->settings()->https($flag); |
372 | 372 | return $this; |
@@ -380,7 +380,7 @@ discard block |
||
380 | 380 | */ |
381 | 381 | public function enableExtremes($flag = true) |
382 | 382 | { |
383 | - $this->settings()->set('extremes',intval($flag)); |
|
383 | + $this->settings()->set('extremes', intval($flag)); |
|
384 | 384 | return $this; |
385 | 385 | } |
386 | 386 | |
@@ -393,9 +393,9 @@ discard block |
||
393 | 393 | * @param null $writeToFile |
394 | 394 | * @return Statement |
395 | 395 | */ |
396 | - public function select($sql, $bindings = [], $whereInFile = null, $writeToFile=null) |
|
396 | + public function select($sql, $bindings = [], $whereInFile = null, $writeToFile = null) |
|
397 | 397 | { |
398 | - return $this->transport()->select($sql, $bindings, $whereInFile,$writeToFile); |
|
398 | + return $this->transport()->select($sql, $bindings, $whereInFile, $writeToFile); |
|
399 | 399 | } |
400 | 400 | |
401 | 401 | /** |
@@ -440,9 +440,9 @@ discard block |
||
440 | 440 | * @param null $writeToFile |
441 | 441 | * @return Statement |
442 | 442 | */ |
443 | - public function selectAsync($sql, $bindings = [], $whereInFile = null,$writeToFile=null) |
|
443 | + public function selectAsync($sql, $bindings = [], $whereInFile = null, $writeToFile = null) |
|
444 | 444 | { |
445 | - return $this->transport()->selectAsync($sql, $bindings, $whereInFile,$writeToFile); |
|
445 | + return $this->transport()->selectAsync($sql, $bindings, $whereInFile, $writeToFile); |
|
446 | 446 | } |
447 | 447 | |
448 | 448 | /** |
@@ -473,7 +473,7 @@ discard block |
||
473 | 473 | */ |
474 | 474 | public function showCreateTable($table) |
475 | 475 | { |
476 | - return ($this->select('SHOW CREATE TABLE '.$table)->fetchOne('statement')); |
|
476 | + return ($this->select('SHOW CREATE TABLE ' . $table)->fetchOne('statement')); |
|
477 | 477 | } |
478 | 478 | |
479 | 479 | /** |
@@ -530,17 +530,17 @@ discard block |
||
530 | 530 | */ |
531 | 531 | public function prepareInsertAssocBulk(array $values) |
532 | 532 | { |
533 | - if (isset($values[0]) && is_array($values[0])){ //случай, когда много строк вставляется |
|
533 | + if (isset($values[0]) && is_array($values[0])) { //случай, когда много строк вставляется |
|
534 | 534 | $preparedFields = array_keys($values[0]); |
535 | 535 | $preparedValues = []; |
536 | - foreach ($values as $idx => $row){ |
|
536 | + foreach ($values as $idx => $row) { |
|
537 | 537 | $_fields = array_keys($row); |
538 | - if ($_fields !== $preparedFields){ |
|
539 | - throw new QueryException("Fields not match: ".implode(',',$_fields)." and ".implode(',', $preparedFields)." on element $idx"); |
|
538 | + if ($_fields !== $preparedFields) { |
|
539 | + throw new QueryException("Fields not match: " . implode(',', $_fields) . " and " . implode(',', $preparedFields) . " on element $idx"); |
|
540 | 540 | } |
541 | 541 | $preparedValues[] = array_values($row); |
542 | 542 | } |
543 | - }else{ //одна строка |
|
543 | + } else { //одна строка |
|
544 | 544 | $preparedFields = array_keys($values); |
545 | 545 | $preparedValues = [array_values($values)]; |
546 | 546 | } |
@@ -572,7 +572,7 @@ discard block |
||
572 | 572 | */ |
573 | 573 | public function insertBatchTSVFiles($table_name, $file_names, $columns_array) |
574 | 574 | { |
575 | - return $this->insertBatchFiles($table_name,$file_names,$columns_array,'TabSeparated'); |
|
575 | + return $this->insertBatchFiles($table_name, $file_names, $columns_array, 'TabSeparated'); |
|
576 | 576 | } |
577 | 577 | /** |
578 | 578 | * insert Batch Files |
@@ -583,17 +583,17 @@ discard block |
||
583 | 583 | * @param $format string ['TabSeparated','TabSeparatedWithNames','CSV','CSVWithNames'] |
584 | 584 | * @return array |
585 | 585 | */ |
586 | - public function insertBatchFiles($table_name, $file_names, $columns_array,$format="CSV") |
|
586 | + public function insertBatchFiles($table_name, $file_names, $columns_array, $format = "CSV") |
|
587 | 587 | { |
588 | 588 | if (is_string($file_names)) |
589 | 589 | { |
590 | - $file_names=[$file_names]; |
|
590 | + $file_names = [$file_names]; |
|
591 | 591 | } |
592 | 592 | if ($this->getCountPendingQueue() > 0) { |
593 | 593 | throw new QueryException('Queue must be empty, before insertBatch, need executeAsync'); |
594 | 594 | } |
595 | 595 | |
596 | - if (!in_array($format,$this->_support_format)) |
|
596 | + if (!in_array($format, $this->_support_format)) |
|
597 | 597 | { |
598 | 598 | throw new QueryException('Format not support in insertBatchFiles'); |
599 | 599 | } |
@@ -602,17 +602,17 @@ discard block |
||
602 | 602 | |
603 | 603 | foreach ($file_names as $fileName) { |
604 | 604 | if (!is_file($fileName) || !is_readable($fileName)) { |
605 | - throw new QueryException('Cant read file: ' . $fileName.' '.(is_file($fileName)?'':' is not file')); |
|
605 | + throw new QueryException('Cant read file: ' . $fileName . ' ' . (is_file($fileName) ? '' : ' is not file')); |
|
606 | 606 | } |
607 | 607 | |
608 | 608 | if (!$columns_array) |
609 | 609 | { |
610 | - $sql = 'INSERT INTO ' . $table_name . ' FORMAT '.$format; |
|
610 | + $sql = 'INSERT INTO ' . $table_name . ' FORMAT ' . $format; |
|
611 | 611 | |
612 | 612 | } |
613 | 613 | else |
614 | 614 | { |
615 | - $sql = 'INSERT INTO ' . $table_name . ' ( ' . implode(',', $columns_array) . ' ) FORMAT '.$format; |
|
615 | + $sql = 'INSERT INTO ' . $table_name . ' ( ' . implode(',', $columns_array) . ' ) FORMAT ' . $format; |
|
616 | 616 | |
617 | 617 | } |
618 | 618 | $result[$fileName] = $this->transport()->writeAsyncCSV($sql, $fileName); |
@@ -639,25 +639,25 @@ discard block |
||
639 | 639 | * @param string $format |
640 | 640 | * @return Transport\CurlerRequest |
641 | 641 | */ |
642 | - public function insertBatchStream($table_name, $columns_array,$format="CSV") |
|
642 | + public function insertBatchStream($table_name, $columns_array, $format = "CSV") |
|
643 | 643 | { |
644 | 644 | if ($this->getCountPendingQueue() > 0) { |
645 | 645 | throw new QueryException('Queue must be empty, before insertBatch, need executeAsync'); |
646 | 646 | } |
647 | 647 | |
648 | - if (!in_array($format,$this->_support_format)) |
|
648 | + if (!in_array($format, $this->_support_format)) |
|
649 | 649 | { |
650 | 650 | throw new QueryException('Format not support in insertBatchFiles'); |
651 | 651 | } |
652 | 652 | |
653 | 653 | if (!$columns_array) |
654 | 654 | { |
655 | - $sql = 'INSERT INTO ' . $table_name . ' FORMAT '.$format; |
|
655 | + $sql = 'INSERT INTO ' . $table_name . ' FORMAT ' . $format; |
|
656 | 656 | |
657 | 657 | } |
658 | 658 | else |
659 | 659 | { |
660 | - $sql = 'INSERT INTO ' . $table_name . ' ( ' . implode(',', $columns_array) . ' ) FORMAT '.$format; |
|
660 | + $sql = 'INSERT INTO ' . $table_name . ' ( ' . implode(',', $columns_array) . ' ) FORMAT ' . $format; |
|
661 | 661 | |
662 | 662 | } |
663 | 663 | |
@@ -715,16 +715,16 @@ discard block |
||
715 | 715 | * |
716 | 716 | * @return array |
717 | 717 | */ |
718 | - public function tablesSize($flatList=false) |
|
718 | + public function tablesSize($flatList = false) |
|
719 | 719 | { |
720 | - $z=$this->select(' |
|
720 | + $z = $this->select(' |
|
721 | 721 | SELECT table,database, |
722 | 722 | formatReadableSize(sum(bytes)) as size, |
723 | 723 | sum(bytes) as sizebytes, |
724 | 724 | min(min_date) as min_date, |
725 | 725 | max(max_date) as max_date |
726 | 726 | FROM system.parts |
727 | - WHERE active AND database=\''.$this->settings()->getDatabase().'\' |
|
727 | + WHERE active AND database=\''.$this->settings()->getDatabase() . '\' |
|
728 | 728 | GROUP BY table,database |
729 | 729 | '); |
730 | 730 | |
@@ -745,12 +745,12 @@ discard block |
||
745 | 745 | * @param $table |
746 | 746 | * @return array |
747 | 747 | */ |
748 | - public function isExists($database,$table) |
|
748 | + public function isExists($database, $table) |
|
749 | 749 | { |
750 | 750 | return $this->select(' |
751 | 751 | SELECT * |
752 | 752 | FROM system.tables |
753 | - WHERE name=\''.$table.'\' AND database=\''.$database.'\'' |
|
753 | + WHERE name=\''.$table . '\' AND database=\'' . $database . '\'' |
|
754 | 754 | )->rowsAsTree('name'); |
755 | 755 | } |
756 | 756 | |
@@ -767,7 +767,7 @@ discard block |
||
767 | 767 | return $this->select(' |
768 | 768 | SELECT * |
769 | 769 | FROM system.parts |
770 | - WHERE like(table,\'%' . $table . '%\') AND database=\''.$this->settings()->getDatabase().'\' |
|
770 | + WHERE like(table,\'%' . $table . '%\') AND database=\'' . $this->settings()->getDatabase() . '\' |
|
771 | 771 | ORDER BY max_date ' . ($limit > 0 ? ' LIMIT ' . intval($limit) : '') |
772 | 772 | )->rowsAsTree('name'); |
773 | 773 | } |
@@ -782,8 +782,8 @@ discard block |
||
782 | 782 | public function dropPartition($dataBaseTableName, $partition_id) |
783 | 783 | { |
784 | 784 | |
785 | - $partition_id=trim($partition_id,'\''); |
|
786 | - $this->settings()->set('replication_alter_partitions_sync',2); |
|
785 | + $partition_id = trim($partition_id, '\''); |
|
786 | + $this->settings()->set('replication_alter_partitions_sync', 2); |
|
787 | 787 | $state = $this->write('ALTER TABLE {dataBaseTableName} DROP PARTITION :partion_id', [ |
788 | 788 | 'dataBaseTableName' => $dataBaseTableName, |
789 | 789 | 'partion_id' => $partition_id |
@@ -799,12 +799,12 @@ discard block |
||
799 | 799 | */ |
800 | 800 | public function truncateTable($tableName) |
801 | 801 | { |
802 | - $partions=$this->partitions($tableName); |
|
803 | - $out=[]; |
|
802 | + $partions = $this->partitions($tableName); |
|
803 | + $out = []; |
|
804 | 804 | foreach ($partions as $part_key=>$part) |
805 | 805 | { |
806 | - $part_id=$part['partition']; |
|
807 | - $out[$part_id]=$this->dropPartition($tableName,$part_id); |
|
806 | + $part_id = $part['partition']; |
|
807 | + $out[$part_id] = $this->dropPartition($tableName, $part_id); |
|
808 | 808 | } |
809 | 809 | return $out; |
810 | 810 | } |
@@ -837,9 +837,9 @@ discard block |
||
837 | 837 | } |
838 | 838 | } |
839 | 839 | |
840 | - $result=[]; |
|
840 | + $result = []; |
|
841 | 841 | foreach ($drop as $partition_id) { |
842 | - $result[$partition_id]=$this->dropPartition($table_name, $partition_id); |
|
842 | + $result[$partition_id] = $this->dropPartition($table_name, $partition_id); |
|
843 | 843 | } |
844 | 844 | |
845 | 845 | return $result; |
@@ -295,8 +295,7 @@ discard block |
||
295 | 295 | if (!$useSessionId) |
296 | 296 | { |
297 | 297 | $this->settings()->makeSessionId(); |
298 | - } |
|
299 | - else |
|
298 | + } else |
|
300 | 299 | { |
301 | 300 | $this->settings()->session_id($useSessionId); |
302 | 301 | } |
@@ -415,7 +414,9 @@ discard block |
||
415 | 414 | */ |
416 | 415 | public function progressFunction($callback) |
417 | 416 | { |
418 | - if (!is_callable($callback)) throw new \InvalidArgumentException('Not is_callable progressFunction'); |
|
417 | + if (!is_callable($callback)) { |
|
418 | + throw new \InvalidArgumentException('Not is_callable progressFunction'); |
|
419 | + } |
|
419 | 420 | |
420 | 421 | if (!$this->settings()->is('send_progress_in_http_headers')) |
421 | 422 | { |
@@ -540,7 +541,7 @@ discard block |
||
540 | 541 | } |
541 | 542 | $preparedValues[] = array_values($row); |
542 | 543 | } |
543 | - }else{ //одна строка |
|
544 | + } else{ //одна строка |
|
544 | 545 | $preparedFields = array_keys($values); |
545 | 546 | $preparedValues = [array_values($values)]; |
546 | 547 | } |
@@ -609,8 +610,7 @@ discard block |
||
609 | 610 | { |
610 | 611 | $sql = 'INSERT INTO ' . $table_name . ' FORMAT '.$format; |
611 | 612 | |
612 | - } |
|
613 | - else |
|
613 | + } else |
|
614 | 614 | { |
615 | 615 | $sql = 'INSERT INTO ' . $table_name . ' ( ' . implode(',', $columns_array) . ' ) FORMAT '.$format; |
616 | 616 | |
@@ -654,8 +654,7 @@ discard block |
||
654 | 654 | { |
655 | 655 | $sql = 'INSERT INTO ' . $table_name . ' FORMAT '.$format; |
656 | 656 | |
657 | - } |
|
658 | - else |
|
657 | + } else |
|
659 | 658 | { |
660 | 659 | $sql = 'INSERT INTO ' . $table_name . ' ( ' . implode(',', $columns_array) . ' ) FORMAT '.$format; |
661 | 660 |
@@ -109,13 +109,13 @@ discard block |
||
109 | 109 | CURLOPT_SSL_VERIFYHOST => 0, |
110 | 110 | CURLOPT_SSL_VERIFYPEER => false, |
111 | 111 | CURLOPT_TIMEOUT => 10, |
112 | - CURLOPT_CONNECTTIMEOUT => 5, // Количество секунд ожидания при попытке соединения |
|
112 | + CURLOPT_CONNECTTIMEOUT => 5, // Количество секунд ожидания при попытке соединения |
|
113 | 113 | CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, |
114 | 114 | CURLOPT_MAXREDIRS => 10, |
115 | 115 | CURLOPT_HEADER => TRUE, |
116 | 116 | CURLOPT_FOLLOWLOCATION => TRUE, |
117 | - CURLOPT_AUTOREFERER => 1, // при редиректе подставлять в «Referer:» значение из «Location:» |
|
118 | - CURLOPT_BINARYTRANSFER => 1, // передавать в binary-safe |
|
117 | + CURLOPT_AUTOREFERER => 1, // при редиректе подставлять в «Referer:» значение из «Location:» |
|
118 | + CURLOPT_BINARYTRANSFER => 1, // передавать в binary-safe |
|
119 | 119 | CURLOPT_RETURNTRANSFER => TRUE, |
120 | 120 | CURLOPT_USERAGENT => 'smi2/PHPClickHouse/client', |
121 | 121 | ); |
@@ -234,7 +234,7 @@ discard block |
||
234 | 234 | } |
235 | 235 | public function setReadFunction($callback) |
236 | 236 | { |
237 | - $this->options[CURLOPT_READFUNCTION]=$callback; |
|
237 | + $this->options[CURLOPT_READFUNCTION] = $callback; |
|
238 | 238 | } |
239 | 239 | |
240 | 240 | /** |
@@ -352,9 +352,9 @@ discard block |
||
352 | 352 | |
353 | 353 | public function getHeaders() |
354 | 354 | { |
355 | - $head=[]; |
|
355 | + $head = []; |
|
356 | 356 | foreach ($this->headers as $key=>$value) |
357 | - $head[]= sprintf("%s: %s", $key, $value); |
|
357 | + $head[] = sprintf("%s: %s", $key, $value); |
|
358 | 358 | return $head; |
359 | 359 | } |
360 | 360 | |
@@ -628,8 +628,8 @@ discard block |
||
628 | 628 | throw new \Exception('setFunctionProgress not is_callable'); |
629 | 629 | } |
630 | 630 | |
631 | - $this->option(CURLOPT_NOPROGRESS,false); |
|
632 | - $this->option(CURLOPT_PROGRESSFUNCTION,$callback); // version 5.5.0 |
|
631 | + $this->option(CURLOPT_NOPROGRESS, false); |
|
632 | + $this->option(CURLOPT_PROGRESSFUNCTION, $callback); // version 5.5.0 |
|
633 | 633 | } |
634 | 634 | |
635 | 635 | |
@@ -692,7 +692,7 @@ discard block |
||
692 | 692 | } |
693 | 693 | |
694 | 694 | if ($this->options[CURLOPT_VERBOSE]) { |
695 | - echo "\n-----------BODY REQUEST----------\n".$curl_opt[CURLOPT_POSTFIELDS]."\n------END--------\n"; |
|
695 | + echo "\n-----------BODY REQUEST----------\n" . $curl_opt[CURLOPT_POSTFIELDS] . "\n------END--------\n"; |
|
696 | 696 | } |
697 | 697 | curl_setopt_array($this->handle, $curl_opt); |
698 | 698 | return true; |
@@ -353,8 +353,9 @@ discard block |
||
353 | 353 | public function getHeaders() |
354 | 354 | { |
355 | 355 | $head=[]; |
356 | - foreach ($this->headers as $key=>$value) |
|
357 | - $head[]= sprintf("%s: %s", $key, $value); |
|
356 | + foreach ($this->headers as $key=>$value) { |
|
357 | + $head[]= sprintf("%s: %s", $key, $value); |
|
358 | + } |
|
358 | 359 | return $head; |
359 | 360 | } |
360 | 361 | |
@@ -394,8 +395,7 @@ discard block |
||
394 | 395 | if ($flag) { |
395 | 396 | $this->_httpCompression = $flag; |
396 | 397 | $this->options[CURLOPT_ENCODING] = 'gzip'; |
397 | - } |
|
398 | - else |
|
398 | + } else |
|
399 | 399 | { |
400 | 400 | $this->_httpCompression = false; |
401 | 401 | unset($this->options[CURLOPT_ENCODING]); |