StrictQuoteLine::encodeString() - Code Metrics - Inspection of "Merge pull request #106 from dorantor/master" - smi2/phpClickHouse - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 090261...a58ab5 )

by Igor

created 2019-03-13 07:00 UTC

StrictQuoteLine::encodeString() A

↳ Parent: StrictQuoteLine

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes

Metric	Value
eloc	1
dl	0
loc	3
ccs	2
cts	2
cp	1
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	3
crap	1

<?php

namespace ClickHouseDB\Quote;


use ClickHouseDB\Exception\QueryException;
use ClickHouseDB\Query\Expression\Expression;
use ClickHouseDB\Type\NumericType;
use function array_map;
use function is_array;
use function is_float;
use function is_int;
use function is_string;
use function preg_replace;
use function str_replace;

class StrictQuoteLine
{
    private $preset = [
$a = "a";
$ab = "ab";
$abc = "abc";
        'CSV'=>[
            'EnclosureArray'=>'"',
            'EncodeEnclosure'=>'"',
            'Enclosure'=>'"',
            'Null'=>"\\N",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            'Delimiter'=>",",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            'TabEncode'=>false,
        ],
        'Insert'=>[
            'EnclosureArray'=>'',
            'EncodeEnclosure'=>'\\',
            'Enclosure'=>'\'',
            'Null'=>"NULL",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            'Delimiter'=>",",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            'TabEncode'=>false,
        ],
        'TSV'=>[
            'EnclosureArray'=>'',
            'EncodeEnclosure'=>'',
            'Enclosure'=>'\\',
            'Null'=>" ",
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
            'Delimiter'=>"\t",
            'TabEncode'=>true,
        ],
    ];
    private $settings = [];


    public function __construct($format)

    {
        if (empty($this->preset[$format]))
        {
            throw new QueryException("Unsupport format encode line:" . $format);
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
        }

        $this->settings = $this->preset[$format];
    }
    public function quoteRow($row)

    {
        return implode($this->settings['Delimiter'], $this->quoteValue($row));

    }
    public function quoteValue($row)

    {
        $enclosure = $this->settings['Enclosure'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $delimiter = $this->settings['Delimiter'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $encode = $this->settings['EncodeEnclosure'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $encodeArray = $this->settings['EnclosureArray'];
        $null = $this->settings['Null'];
$a = "a";
$ab = "ab";
$abc = "abc";
        $tabEncode = $this->settings['TabEncode'];
$a = "a";
$ab = "ab";
$abc = "abc";

        $quote = function($value) use ($enclosure, $delimiter, $encode, $encodeArray, $null, $tabEncode) {

            $delimiter_esc = preg_quote($delimiter, '/');


            $enclosure_esc = preg_quote($enclosure, '/');


            $encode_esc = preg_quote($encode, '/');


            $encode = true;
            if ($value instanceof NumericType) {
                $encode = false;
            }
            if ($value instanceof Expression) {
                $encode = $value->needsEncoding();
            }

            if (is_array($value)) {
                // Arrays are formatted as a list of values separated by commas in square brackets.
                // Elements of the array - the numbers are formatted as usual, and the dates, dates-with-time, and lines are in
                // single quotation marks with the same screening rules as above.
                // as in the TabSeparated format, and then the resulting string is output in InsertRow in double quotes.
                $value       = array_map(
                    function ($v) use ($enclosure_esc, $encode_esc) {
                        return is_string($v) ? $this->encodeString($v, $enclosure_esc, $encode_esc) : $v;
                    },
                    $value
                );
                $resultArray = FormatLine::Insert($value);

                return $encodeArray . '[' . $resultArray . ']' . $encodeArray;
            }

            $value = ValueFormatter::formatValue($value, false);

            if (is_float($value) || is_int($value)) {
                return (string) $value;
            }

            if (is_string($value) && $encode) {
                if ($tabEncode) {
                    return str_replace(["\t", "\n"], ['\\t', '\\n'], $value);
                }

                $value = $this->encodeString($value, $enclosure_esc, $encode_esc);

                return $enclosure . $value . $enclosure;
            }

            if ($value === null) {
                return $null;
            }

            return $value;
        };

        return array_map($quote, $row);
    }

    /**
     * @return string
     */
    public function encodeString(string $value, string $enclosureEsc, string $encodeEsc)

    {
        return preg_replace('/(' . $enclosureEsc . '|' . $encodeEsc . ')/', $encodeEsc . '\1', $value);
    }
}


1		<?php
		0 ignored issues – show introduced 2019-03-13 07:05 UTC by Report Bug Copy Issue Report Missing declare(strict_types=1). Loading history...
2		namespace ClickHouseDB\Quote;
		0 ignored issues – show introduced 2018-09-26 10:27 UTC by Report Bug Copy Issue Report Expected 1 lines before namespace statement, found 0. Loading history...
3
4		use ClickHouseDB\Exception\QueryException;
5		use ClickHouseDB\Query\Expression\Expression;
6		use ClickHouseDB\Type\NumericType;
7		use function array_map;
8		use function is_array;
9		use function is_float;
10		use function is_int;
11		use function is_string;
12		use function preg_replace;
13		use function str_replace;
14
15		class StrictQuoteLine
16		{
17		private $preset = [
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Property \ClickHouseDB\Quote\StrictQuoteLine::$preset does not have @var annotation. Loading history... Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
18		'CSV'=>[
19		'EnclosureArray'=>'"',
20		'EncodeEnclosure'=>'"',
21		'Enclosure'=>'"',
22		'Null'=>"\\N",
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report The string literal `\\N` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
23		'Delimiter'=>",",
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report The string literal `,` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
24		'TabEncode'=>false,
25		],
26		'Insert'=>[
27		'EnclosureArray'=>'',
28		'EncodeEnclosure'=>'\\',
29		'Enclosure'=>'\'',
30		'Null'=>"NULL",
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report The string literal `NULL` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
31		'Delimiter'=>",",
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report The string literal `,` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
32		'TabEncode'=>false,
33		],
34		'TSV'=>[
35		'EnclosureArray'=>'',
36		'EncodeEnclosure'=>'',
37		'Enclosure'=>'\\',
38		'Null'=>" ",
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report The string literal does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
39		'Delimiter'=>"\t",
40		'TabEncode'=>true,
41		],
42		];
43		private $settings = [];
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Property \ClickHouseDB\Quote\StrictQuoteLine::$settings does not have @var annotation. Loading history...
44
45	3	public function __construct($format)
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Method \ClickHouseDB\Quote\StrictQuoteLine::__construct() does not have parameter type hint nor @param annotation for its parameter $format. Loading history...
46		{
47	3	if (empty($this->preset[$format]))
48		{
49		throw new QueryException("Unsupport format encode line:" . $format);
		0 ignored issues – show Coding Style Comprehensibility introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report The string literal `Unsupport format encode line:` does not require double quotes, as per coding-style, please use single quotes. PHP provides two ways to mark string literals. Either with single quotes `'literal'` or with double quotes `"literal"`. The difference between these is that string literals in double quotes may contain variables with are evaluated at run-time as well as escape sequences. String literals in single quotes on the other hand are evaluated very literally and the only two characters that needs escaping in the literal are the single quote itself (`\'`) and the backslash (`\\`). Every other character is displayed as is. Double quoted string literals may contain other variables or more complex escape sequences. <?php $singleQuoted = 'Value'; $doubleQuoted = "\tSingle is $singleQuoted"; print $doubleQuoted; will print an indented: `Single is Value` If your string literal does not contain variables or escape sequences, it should be defined using single quotes to make that fact clear. For more information on PHP string literals and available escape sequences see the PHP core documentation. Loading history...
50		}
51
52	3	$this->settings = $this->preset[$format];
53	3	}
54	11	public function quoteRow($row)
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Method \ClickHouseDB\Quote\StrictQuoteLine::quoteRow() does not have parameter type hint nor @param annotation for its parameter $row. Loading history... introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Method \ClickHouseDB\Quote\StrictQuoteLine::quoteRow() does not have return type hint nor @return annotation for its return value. Loading history...
55		{
56	11	return implode($this->settings['Delimiter'], $this->quoteValue($row));
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Function implode() should not be referenced via a fallback global name, but via a use statement. Loading history...
57		}
58	11	public function quoteValue($row)
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Method \ClickHouseDB\Quote\StrictQuoteLine::quoteValue() does not have parameter type hint nor @param annotation for its parameter $row. Loading history... introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Method \ClickHouseDB\Quote\StrictQuoteLine::quoteValue() does not have return type hint nor @return annotation for its return value. Loading history...
59		{
60	11	$enclosure = $this->settings['Enclosure'];
		0 ignored issues – show Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
61	11	$delimiter = $this->settings['Delimiter'];
		0 ignored issues – show Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
62	11	$encode = $this->settings['EncodeEnclosure'];
		0 ignored issues – show Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 6 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
63	11	$encodeArray = $this->settings['EnclosureArray'];
64	11	$null = $this->settings['Null'];
		0 ignored issues – show Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 8 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
65	11	$tabEncode = $this->settings['TabEncode'];
		0 ignored issues – show Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Equals sign not aligned with surrounding assignments; expected 3 spaces but found 1 space This check looks for multiple assignments in successive lines of code. It will report an issue if the operators are not in a straight line. To visualize $a = "a"; $ab = "ab"; $abc = "abc"; will produce issues in the first and second line, while this second example $a = "a"; $ab = "ab"; $abc = "abc"; will produce no issues. Loading history...
66
67		$quote = function($value) use ($enclosure, $delimiter, $encode, $encodeArray, $null, $tabEncode) {
		0 ignored issues – show Coding Style introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Expected 1 space after FUNCTION keyword; 0 found Loading history...
68	11	$delimiter_esc = preg_quote($delimiter, '/');
		0 ignored issues – show Unused Code introduced 2018-05-14 13:41 UTC by Report Bug Copy Issue Report The assignment to `$delimiter_esc` is dead and can be removed. Loading history... introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Function preg_quote() should not be referenced via a fallback global name, but via a use statement. Loading history...
69
70	11	$enclosure_esc = preg_quote($enclosure, '/');
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Function preg_quote() should not be referenced via a fallback global name, but via a use statement. Loading history...
71
72	11	$encode_esc = preg_quote($encode, '/');
		0 ignored issues – show introduced 2018-07-08 20:56 UTC by Report Bug Copy Issue Report Function preg_quote() should not be referenced via a fallback global name, but via a use statement. Loading history...
73
74	11	$encode = true;
75	11	if ($value instanceof NumericType) {
76	1	$encode = false;
77		}
78	11	if ($value instanceof Expression) {
79	1	$encode = $value->needsEncoding();
80		}
81
82	11	if (is_array($value)) {
83		// Arrays are formatted as a list of values separated by commas in square brackets.
84		// Elements of the array - the numbers are formatted as usual, and the dates, dates-with-time, and lines are in
85		// single quotation marks with the same screening rules as above.
86		// as in the TabSeparated format, and then the resulting string is output in InsertRow in double quotes.
87	4	$value = array_map(
88		function ($v) use ($enclosure_esc, $encode_esc) {
89	4	return is_string($v) ? $this->encodeString($v, $enclosure_esc, $encode_esc) : $v;
90	4	},
91	4	$value
92		);
93	4	$resultArray = FormatLine::Insert($value);
94
95	4	return $encodeArray . '[' . $resultArray . ']' . $encodeArray;
96		}
97
98	11	$value = ValueFormatter::formatValue($value, false);
99
100	11	if (is_float($value) \|\| is_int($value)) {
101	9	return (string) $value;
102		}
103
104	11	if (is_string($value) && $encode) {
105	9	if ($tabEncode) {
106	1	return str_replace(["\t", "\n"], ['\\t', '\\n'], $value);
107		}
108
109	9	$value = $this->encodeString($value, $enclosure_esc, $encode_esc);
110
111	9	return $enclosure . $value . $enclosure;
112		}
113
114	3	if ($value === null) {
115	1	return $null;
116		}
117
118	2	return $value;
119	11	};
120
121	11	return array_map($quote, $row);
122		}
123
124		/**
125		* @return string
126		*/
127	9	public function encodeString(string $value, string $enclosureEsc, string $encodeEsc)
		0 ignored issues – show introduced 2018-08-22 14:46 UTC by Report Bug Copy Issue Report Method \ClickHouseDB\Quote\StrictQuoteLine::encodeString() does not have return type hint for its return value but it should be possible to add it based on @return annotation "string". Loading history...
128		{
129	9	return preg_replace('/(' . $enclosureEsc . '\|' . $encodeEsc . ')/', $encodeEsc . '\1', $value);
130		}
131		}
132

smi2 / phpClickHouse

Push — master ( 090261...a58ab5 )

StrictQuoteLine::encodeString() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like