phpmyadmin / sql-parser

src/Statements/DeleteStatement.php

Spacing +8 added lines, -8 removed lines

@@ -106,52 +106,52 @@
      *
      * @var Expression[]|null
      */
-    public array|null $from = null;
+    public array | null $from = null;
 
     /**
      * Joins.
      *
      * @var JoinKeyword[]|null
      */
-    public array|null $join = null;
+    public array | null $join = null;
 
     /**
      * Tables used as sources for this statement.
      *
      * @var Expression[]|null
      */
-    public array|null $using = null;
+    public array | null $using = null;
 
     /**
      * Columns used in this statement.
      *
      * @var Expression[]|null
      */
-    public array|null $columns = null;
+    public array | null $columns = null;
 
     /**
      * Partitions used as source for this statement.
      */
-    public ArrayObj|null $partition = null;
+    public ArrayObj | null $partition = null;
 
     /**
      * Conditions used for filtering each row of the result set.
      *
      * @var Condition[]|null
      */
-    public array|null $where = null;
+    public array | null $where = null;
 
     /**
      * Specifies the order of the rows in the result set.
      *
      * @var OrderKeyword[]|null
      */
-    public array|null $order = null;
+    public array | null $order = null;
 
     /**
      * Conditions used for limiting the size of the result set.
      */
-    public Limit|null $limit = null;
+    public Limit | null $limit = null;
 
     public function build(): string
     {

src/Statements/CreateStatement.php

Spacing +21 added lines, -21 removed lines

@@ -269,7 +269,7 @@ 
      *
      * Used by all `CREATE` statements.
      */
-    public Expression|null $name = null;
+    public Expression | null $name = null;
 
     /**
      * The options of the entity (table, procedure, function, etc.).
@@ -280,7 +280,7 @@ 
      * @see CreateStatement::FUNCTION_OPTIONS
      * @see CreateStatement::TRIGGER_OPTIONS
      */
-    public OptionsArray|null $entityOptions = null;
+    public OptionsArray | null $entityOptions = null;
 
     /**
      * If `CREATE TABLE`, a list of columns and keys.
@@ -290,7 +290,7 @@ 
      *
      * @var CreateDefinition[]|ArrayObj|null
      */
-    public array|ArrayObj|null $fields = null;
+    public array | ArrayObj | null $fields = null;
 
     /**
      * If `CREATE TABLE WITH`.
@@ -299,7 +299,7 @@ 
      *
      * Used by `CREATE TABLE`, `CREATE VIEW`
      */
-    public WithStatement|null $with = null;
+    public WithStatement | null $with = null;
 
     /**
      * If `CREATE TABLE ... SELECT`.
@@ -307,55 +307,55 @@ 
      *
      * Used by `CREATE TABLE`, `CREATE VIEW`
      */
-    public SelectStatement|null $select = null;
+    public SelectStatement | null $select = null;
 
     /**
      * If `CREATE TABLE ... LIKE`.
      *
      * Used by `CREATE TABLE`
      */
-    public Expression|null $like = null;
+    public Expression | null $like = null;
 
     /**
      * Expression used for partitioning.
      */
-    public string|null $partitionBy = null;
+    public string | null $partitionBy = null;
 
     /**
      * The number of partitions.
      */
-    public int|null $partitionsNum = null;
+    public int | null $partitionsNum = null;
 
     /**
      * Expression used for subpartitioning.
      */
-    public string|null $subpartitionBy = null;
+    public string | null $subpartitionBy = null;
 
     /**
      * The number of subpartitions.
      */
-    public int|null $subpartitionsNum = null;
+    public int | null $subpartitionsNum = null;
 
     /**
      * The partition of the new table.
      *
      * @var PartitionDefinition[]|null
      */
-    public array|null $partitions = null;
+    public array | null $partitions = null;
 
     /**
      * If `CREATE TRIGGER` the name of the table.
      *
      * Used by `CREATE TRIGGER`.
      */
-    public Expression|null $table = null;
+    public Expression | null $table = null;
 
     /**
      * The return data type of this routine.
      *
      * Used by `CREATE FUNCTION`.
      */
-    public DataType|null $return = null;
+    public DataType | null $return = null;
 
     /**
      * The parameters of this routine.
@@ -364,7 +364,7 @@ 
      *
      * @var ParameterDefinition[]|null
      */
-    public array|null $parameters = null;
+    public array | null $parameters = null;
 
     /**
      * The body of this function or procedure.
@@ -417,23 +417,23 @@ 
 
             $partition = '';
 
-            if (! empty($this->partitionBy)) {
+            if (!empty($this->partitionBy)) {
                 $partition .= "\nPARTITION BY " . $this->partitionBy;
             }
 
-            if (! empty($this->partitionsNum)) {
+            if (!empty($this->partitionsNum)) {
                 $partition .= "\nPARTITIONS " . $this->partitionsNum;
             }
 
-            if (! empty($this->subpartitionBy)) {
+            if (!empty($this->subpartitionBy)) {
                 $partition .= "\nSUBPARTITION BY " . $this->subpartitionBy;
             }
 
-            if (! empty($this->subpartitionsNum)) {
+            if (!empty($this->subpartitionsNum)) {
                 $partition .= "\nSUBPARTITIONS " . $this->subpartitionsNum;
             }
 
-            if (! empty($this->partitions)) {
+            if (!empty($this->partitions)) {
                 $partition .= "\n" . PartitionDefinition::buildAll($this->partitions);
             }
 
@@ -627,7 +627,7 @@ 
                         $token = $list->getNextOfType(TokenType::Number);
                         --$list->idx; // `getNextOfType` also advances one position.
                         $this->subpartitionsNum = $token->value;
-                    } elseif (! empty($field)) {
+                    } elseif (!empty($field)) {
                         /*
                          * Handling the content of `PARTITION BY` and `SUBPARTITION BY`.
                          */
@@ -656,7 +656,7 @@ 
                             $field = null;
                         }
                     } elseif (($token->type === TokenType::Operator) && ($token->value === '(')) {
-                        if (! empty($this->partitionBy)) {
+                        if (!empty($this->partitionBy)) {
                             $this->partitions = ArrayObj::parse(
                                 $parser,
                                 $list,

src/Statements/LoadStatement.php

Spacing +12 added lines, -12 removed lines

@@ -88,70 +88,70 @@
     /**
      * File name being used to load data.
      */
-    public Expression|null $fileName = null;
+    public Expression | null $fileName = null;
 
     /**
      * Table used as destination for this statement.
      */
-    public Expression|null $table = null;
+    public Expression | null $table = null;
 
     /**
      * Partitions used as source for this statement.
      */
-    public ArrayObj|null $partition = null;
+    public ArrayObj | null $partition = null;
 
     /**
      * Character set used in this statement.
      */
-    public Expression|null $charsetName = null;
+    public Expression | null $charsetName = null;
 
     /**
      * Options for FIELDS/COLUMNS keyword.
      *
      * @see LoadStatement::STATEMENT_FIELDS_OPTIONS
      */
-    public OptionsArray|null $fieldsOptions = null;
+    public OptionsArray | null $fieldsOptions = null;
 
     /**
      * Whether to use `FIELDS` or `COLUMNS` while building.
      */
-    public string|null $fieldsKeyword = null;
+    public string | null $fieldsKeyword = null;
 
     /**
      * Options for OPTIONS keyword.
      *
      * @see LoadStatement::STATEMENT_LINES_OPTIONS
      */
-    public OptionsArray|null $linesOptions = null;
+    public OptionsArray | null $linesOptions = null;
 
     /**
      * Column names or user variables.
      *
      * @var Expression[]|null
      */
-    public array|null $columnNamesOrUserVariables = null;
+    public array | null $columnNamesOrUserVariables = null;
 
     /**
      * SET clause's updated values(optional).
      *
      * @var SetOperation[]|null
      */
-    public array|null $set = null;
+    public array | null $set = null;
 
     /**
      * Ignore 'number' LINES/ROWS.
      */
-    public Expression|null $ignoreNumber = null;
+    public Expression | null $ignoreNumber = null;
 
     /**
      * REPLACE/IGNORE Keyword.
      */
-    public string|null $replaceIgnore = null;
+    public string | null $replaceIgnore = null;
 
     /**
      * LINES/ROWS Keyword.
      */
-    public string|null $linesRows = null;
+    public string | null $linesRows = null;
 
     public function build(): string
     {

src/Statements/AlterStatement.php

Spacing +2 added lines, -2 removed lines

@@ -23,14 +23,14 @@
     /**
      * Table affected.
      */
-    public Expression|null $table = null;
+    public Expression | null $table = null;
 
     /**
      * Column affected by this statement.
      *
      * @var AlterOperation[]|null
      */
-    public array|null $altered = [];
+    public array | null $altered = [];
 
     /**
      * Options of this statement.

src/Statements/InsertStatement.php

Spacing +6 added lines, -6 removed lines

@@ -68,14 +68,14 @@ 
     /**
      * Tables used as target for this statement.
      */
-    public IntoKeyword|null $into = null;
+    public IntoKeyword | null $into = null;
 
     /**
      * Values to be inserted.
      *
      * @var ArrayObj[]|null
      */
-    public array|null $values = null;
+    public array | null $values = null;
 
     /**
      * If SET clause is present
@@ -83,19 +83,19 @@ 
      *
      * @var SetOperation[]|null
      */
-    public array|null $set = null;
+    public array | null $set = null;
 
     /**
      * If SELECT clause is present
      * holds the SelectStatement.
      */
-    public SelectStatement|null $select = null;
+    public SelectStatement | null $select = null;
 
     /**
      * If WITH CTE is present
      * holds the WithStatement.
      */
-    public WithStatement|null $with = null;
+    public WithStatement | null $with = null;
 
     /**
      * If ON DUPLICATE KEY UPDATE clause is present
@@ -103,7 +103,7 @@ 
      *
      * @var SetOperation[]|null
      */
-    public array|null $onDuplicateSet = null;
+    public array | null $onDuplicateSet = null;
 
     public function build(): string
     {

src/Statements/ReplaceStatement.php

Spacing +4 added lines, -4 removed lines

@@ -54,14 +54,14 @@ 
     /**
      * Tables used as target for this statement.
      */
-    public IntoKeyword|null $into = null;
+    public IntoKeyword | null $into = null;
 
     /**
      * Values to be replaced.
      *
      * @var ArrayObj[]|null
      */
-    public array|null $values = null;
+    public array | null $values = null;
 
     /**
      * If SET clause is present
@@ -69,13 +69,13 @@ 
      *
      * @var SetOperation[]|null
      */
-    public array|null $set = null;
+    public array | null $set = null;
 
     /**
      * If SELECT clause is present
      * holds the SelectStatement.
      */
-    public SelectStatement|null $select = null;
+    public SelectStatement | null $select = null;
 
     public function build(): string
     {

tests/Utils/CLITest.php

Spacing +6 added lines, -6 removed lines

@@ -50,7 +50,7 @@ 
 
     /** @param array<string, bool|string>|false $getopt */
     #[DataProvider('highlightParamsProvider')]
-    public function testRunHighlight(array|false $getopt, string $output, int $result): void
+    public function testRunHighlight(array | false $getopt, string $output, int $result): void
     {
         $cli = $this->getCLI($getopt);
         $this->expectOutputString($output);
@@ -122,7 +122,7 @@ 
 
     /** @param array<string, bool|string>|false $getopt */
     #[DataProvider('highlightParamsStdInProvider')]
-    public function testRunHighlightStdIn(string $input, array|false $getopt, string $output, int $result): void
+    public function testRunHighlightStdIn(string $input, array | false $getopt, string $output, int $result): void
     {
         $cli = $this->getCLIStdIn($input, $getopt);
         $this->expectOutputString($output);
@@ -187,7 +187,7 @@ 
 
     /** @param array<string, bool|string>|false $getopt */
     #[DataProvider('lintParamsStdInProvider')]
-    public function testRunLintFromStdIn(string $input, array|false $getopt, string $output, int $result): void
+    public function testRunLintFromStdIn(string $input, array | false $getopt, string $output, int $result): void
     {
         $cli = $this->getCLIStdIn($input, $getopt);
         $this->expectOutputString($output);
@@ -249,7 +249,7 @@ 
 
     /** @param array<string, bool|string>|false $getopt */
     #[DataProvider('lintParamsProvider')]
-    public function testRunLint(array|false $getopt, string $output, int $result): void
+    public function testRunLint(array | false $getopt, string $output, int $result): void
     {
         $cli = $this->getCLI($getopt);
         $this->expectOutputString($output);
@@ -313,7 +313,7 @@ 
 
     /** @param array<string, bool|string>|false $getopt */
     #[DataProvider('tokenizeParamsProvider')]
-    public function testRunTokenize(array|false $getopt, string $output, int $result): void
+    public function testRunTokenize(array | false $getopt, string $output, int $result): void
     {
         $cli = $this->getCLI($getopt);
         $this->expectOutputString($output);
@@ -365,7 +365,7 @@ 
 
     /** @param array<string, bool|string>|false $getopt */
     #[DataProvider('tokenizeParamsStdInProvider')]
-    public function testRunTokenizeStdIn(string $input, array|false $getopt, string $output, int $result): void
+    public function testRunTokenizeStdIn(string $input, array | false $getopt, string $output, int $result): void
     {
         $cli = $this->getCLIStdIn($input, $getopt);
         $this->expectOutputString($output);

tests/Lexer/ContextTest.php

Spacing +2 added lines, -2 removed lines

@@ -35,7 +35,7 @@ 
      * Test for loading closest SQL context
      */
     #[DataProvider('contextLoadingProvider')]
-    public function testLoadClosest(string $context, string|null $expected): void
+    public function testLoadClosest(string $context, string | null $expected): void
     {
         $this->assertEquals($expected, Context::loadClosest($context));
         if ($expected !== null) {
@@ -118,7 +118,7 @@ 
     }
 
     #[DataProvider('providerForTestMode')]
-    public function testMode(int|string $mode, int $expected): void
+    public function testMode(int | string $mode, int $expected): void
     {
         Context::setMode($mode);
         $this->assertSame($expected, Context::getMode());

src/Lexer.php

Spacing +29 added lines, -29 removed lines

@@ -67,7 +67,7 @@ 
     /**
      * The string to be parsed.
      */
-    public string|UtfString $str = '';
+    public string | UtfString $str = '';
 
     /**
      * The length of `$str`.
@@ -113,7 +113,7 @@ 
      *                                    enabled or not
      * @param string           $delimiter the delimiter to be used
      */
-    public function __construct(string|UtfString $str, bool $strict = false, string|null $delimiter = null)
+    public function __construct(string | UtfString $str, bool $strict = false, string | null $delimiter = null)
     {
         if (Context::$keywords === []) {
             Context::load();
@@ -124,7 +124,7 @@ 
         $len = $str instanceof UtfString ? $str->length() : strlen($str);
 
         // For multi-byte strings, a new instance of `UtfString` is initialized.
-        if (! $str instanceof UtfString && $len !== mb_strlen($str, 'UTF-8')) {
+        if (!$str instanceof UtfString && $len !== mb_strlen($str, 'UTF-8')) {
             $str = new UtfString($str);
         }
 
@@ -134,7 +134,7 @@ 
         $this->strict = $strict;
 
         // Setting the delimiter.
-        $this->setDelimiter(! empty($delimiter) ? $delimiter : static::$defaultDelimiter);
+        $this->setDelimiter(!empty($delimiter) ? $delimiter : static::$defaultDelimiter);
 
         $this->lex();
     }
@@ -243,7 +243,7 @@ 
                 $delimiterLen = 0;
                 while (
                     ++$this->last < $this->len
-                    && ! Context::isWhitespace($this->str[$this->last])
+                    && !Context::isWhitespace($this->str[$this->last])
                     && $delimiterLen < 15
                 ) {
                     $this->delimiter .= $this->str[$this->last];
@@ -302,8 +302,8 @@ 
             }
 
             if (
-                ($next->type !== TokenType::Keyword || ! in_array($next->value, ['FROM', 'USING'], true))
-                && ($next->type !== TokenType::Operator || ! in_array($next->value, [',', ')'], true))
+                ($next->type !== TokenType::Keyword || !in_array($next->value, ['FROM', 'USING'], true))
+                && ($next->type !== TokenType::Operator || !in_array($next->value, [',', ')'], true))
             ) {
                 continue;
             }
@@ -341,10 +341,10 @@ 
             $next = $this->list->getNext();
             if (
                 ($next->type !== TokenType::Keyword
-                    || ! in_array($next->value, self::KEYWORD_NAME_INDICATORS, true)
+                    || !in_array($next->value, self::KEYWORD_NAME_INDICATORS, true)
                 )
                 && ($next->type !== TokenType::Operator
-                    || ! in_array($next->value, self::OPERATOR_NAME_INDICATORS, true)
+                    || !in_array($next->value, self::OPERATOR_NAME_INDICATORS, true)
                 )
                 && ($next->value !== '')
             ) {
@@ -388,7 +388,7 @@ 
     /**
      * Parses a keyword.
      */
-    public function parseKeyword(): Token|null
+    public function parseKeyword(): Token | null
     {
         $token = '';
 
@@ -428,7 +428,7 @@ 
             $token .= $this->str[$this->last];
             $flags = Context::isKeyword($token);
 
-            if (($this->last + 1 !== $this->len && ! Context::isSeparator($this->str[$this->last + 1])) || ! $flags) {
+            if (($this->last + 1 !== $this->len && !Context::isSeparator($this->str[$this->last + 1])) || !$flags) {
                 continue;
             }
 
@@ -448,7 +448,7 @@ 
     /**
      * Parses a label.
      */
-    public function parseLabel(): Token|null
+    public function parseLabel(): Token | null
     {
         $token = '';
 
@@ -492,7 +492,7 @@ 
     /**
      * Parses an operator.
      */
-    public function parseOperator(): Token|null
+    public function parseOperator(): Token | null
     {
         $token = '';
 
@@ -512,7 +512,7 @@ 
             $token .= $this->str[$this->last];
             $flags = Context::isOperator($token);
 
-            if (! $flags) {
+            if (!$flags) {
                 continue;
             }
 
@@ -528,11 +528,11 @@ 
     /**
      * Parses a whitespace.
      */
-    public function parseWhitespace(): Token|null
+    public function parseWhitespace(): Token | null
     {
         $token = $this->str[$this->last];
 
-        if (! Context::isWhitespace($token)) {
+        if (!Context::isWhitespace($token)) {
             return null;
         }
 
@@ -548,7 +548,7 @@ 
     /**
      * Parses a comment.
      */
-    public function parseComment(): Token|null
+    public function parseComment(): Token | null
     {
         $iBak = $this->last;
         $token = $this->str[$this->last];
@@ -665,7 +665,7 @@ 
     /**
      * Parses a boolean.
      */
-    public function parseBool(): Token|null
+    public function parseBool(): Token | null
     {
         if ($this->last + 3 >= $this->len) {
             // At least `min(strlen('TRUE'), strlen('FALSE'))` characters are
@@ -696,7 +696,7 @@ 
     /**
      * Parses a number.
      */
-    public function parseNumber(): Token|null
+    public function parseNumber(): Token | null
     {
         // A rudimentary state machine is being used to parse numbers due to
         // the various forms of their notation.
@@ -763,7 +763,7 @@ 
             } elseif ($state === 2) {
                 $flags |= Token::FLAG_NUMBER_HEX;
                 if (
-                    ! (
+                    !(
                         ($this->str[$this->last] >= '0' && $this->str[$this->last] <= '9')
                         || ($this->str[$this->last] >= 'A' && $this->str[$this->last] <= 'F')
                         || ($this->str[$this->last] >= 'a' && $this->str[$this->last] <= 'f')
@@ -859,12 +859,12 @@ 
      *
      * @throws LexerException
      */
-    public function parseString(string $quote = ''): Token|null
+    public function parseString(string $quote = ''): Token | null
     {
         $token = $this->str[$this->last];
         $flags = Context::isString($token);
 
-        if (! $flags && $token !== $quote) {
+        if (!$flags && $token !== $quote) {
             return null;
         }
 
@@ -909,12 +909,12 @@ 
      *
      * @throws LexerException
      */
-    public function parseSymbol(): Token|null
+    public function parseSymbol(): Token | null
     {
         $token = $this->str[$this->last];
         $flags = Context::isSymbol($token);
 
-        if (! $flags) {
+        if (!$flags) {
             return null;
         }
 
@@ -940,7 +940,7 @@ 
             if ($str === null) {
                 $str = $this->parseUnknown();
 
-                if ($str === null && ! ($flags & Token::FLAG_SYMBOL_PARAMETER)) {
+                if ($str === null && !($flags & Token::FLAG_SYMBOL_PARAMETER)) {
                     $this->error('Variable name was expected.', $this->str[$this->last], $this->last);
                 }
             }
@@ -956,14 +956,14 @@ 
     /**
      * Parses unknown parts of the query.
      */
-    public function parseUnknown(): Token|null
+    public function parseUnknown(): Token | null
     {
         $token = $this->str[$this->last];
         if (Context::isSeparator($token)) {
             return null;
         }
 
-        while (++$this->last < $this->len && ! Context::isSeparator($this->str[$this->last])) {
+        while (++$this->last < $this->len && !Context::isSeparator($this->str[$this->last])) {
             $token .= $this->str[$this->last];
 
             // Test if end of token equals the current delimiter. If so, remove it from the token.
@@ -982,7 +982,7 @@ 
     /**
      * Parses the delimiter of the query.
      */
-    public function parseDelimiter(): Token|null
+    public function parseDelimiter(): Token | null
     {
         $idx = 0;
 
@@ -999,7 +999,7 @@ 
         return new Token($this->delimiter, TokenType::Delimiter);
     }
 
-    private function parse(): Token|null
+    private function parse(): Token | null
     {
         // It is best to put the parsers in order of their complexity
         // (ascending) and their occurrence rate (descending).