FM / Components

/usr/share/php/PhpMyAdmin/SqlParser/Components/

/usr/share/php/PhpMyAdmin/SqlParser/Components

Name	Size	Mode	Actions
AlterOperation.php	9606	0644	edit dl rm
Array2d.php	3645	0644	edit dl rm
ArrayObj.php	5065	0644	edit dl rm
CaseExpression.php	10070	0644	edit dl rm
Condition.php	6053	0644	edit dl rm
CreateDefinition.php	10853	0644	edit dl rm
DataType.php	4674	0644	edit dl rm
Expression.php	15359	0644	edit dl rm
ExpressionArray.php	4094	0644	edit dl rm
FunctionCall.php	2999	0644	edit dl rm
GroupKeyword.php	3447	0644	edit dl rm
IndexHint.php	6475	0644	edit dl rm
IntoKeyword.php	8131	0644	edit dl rm
JoinKeyword.php	6449	0644	edit dl rm
Key.php	5555	0644	edit dl rm
Limit.php	3186	0644	edit dl rm
LockExpression.php	5836	0644	edit dl rm
OptionsArray.php	12439	0644	edit dl rm
OrderKeyword.php	3595	0644	edit dl rm
ParameterDefinition.php	4712	0644	edit dl rm
PartitionDefinition.php	7102	0644	edit dl rm
Reference.php	3922	0644	edit dl rm
RenameOperation.php	4909	0644	edit dl rm
SetOperation.php	4260	0644	edit dl rm
UnionKeyword.php	696	0644	edit dl rm

Edit: /usr/share/php/PhpMyAdmin/SqlParser/Components/ExpressionArray.php (4094B)

<?php
/**
 * Parses a list of expressions delimited by a comma.
 */

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Components;

use PhpMyAdmin\SqlParser\Component;
use PhpMyAdmin\SqlParser\Exceptions\ParserException;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Token;
use PhpMyAdmin\SqlParser\TokensList;
use function count;
use function implode;
use function is_array;
use function preg_match;
use function strlen;
use function substr;

/**
 * Parses a list of expressions delimited by a comma.
 */
class ExpressionArray extends Component
{
    /**
     * @param Parser     $parser  the parser that serves as context
     * @param TokensList $list    the list of tokens that are being parsed
     * @param array      $options parameters for parsing
     *
     * @return Expression[]
     *
     * @throws ParserException
     */
    public static function parse(Parser $parser, TokensList $list, array $options = [])
    {
        $ret = [];

/**
         * The state of the parser.
         *
         * Below are the states of the parser.
         *
         *      0 ----------------------[ array ]---------------------> 1
         *
         *      1 ------------------------[ , ]------------------------> 0
         *      1 -----------------------[ else ]----------------------> (END)
         *
         * @var int
         */
        $state = 0;

for (; $list->idx < $list->count; ++$list->idx) {
            /**
             * Token parsed at this moment.
             *
             * @var Token
             */
            $token = $list->tokens[$list->idx];

// End of statement.
            if ($token->type === Token::TYPE_DELIMITER) {
                break;
            }

// Skipping whitespaces and comments.
            if (($token->type === Token::TYPE_WHITESPACE) || ($token->type === Token::TYPE_COMMENT)) {
                continue;
            }

if (($token->type === Token::TYPE_KEYWORD)
                && ($token->flags & Token::FLAG_KEYWORD_RESERVED)
                && ((~$token->flags & Token::FLAG_KEYWORD_FUNCTION))
                && ($token->value !== 'DUAL')
                && ($token->value !== 'NULL')
                && ($token->value !== 'CASE')
            ) {
                // No keyword is expected.
                break;
            }

if ($state === 0) {
                if ($token->type === Token::TYPE_KEYWORD
                    && $token->value === 'CASE'
                ) {
                    $expr = CaseExpression::parse($parser, $list, $options);
                } else {
                    $expr = Expression::parse($parser, $list, $options);
                }

if ($expr === null) {
                    break;
                }

$ret[] = $expr;
                $state = 1;
            } elseif ($state === 1) {
                if ($token->value === ',') {
                    $state = 0;
                } else {
                    break;
                }
            }
        }

if ($state === 0) {
            $parser->error(
                'An expression was expected.',
                $list->tokens[$list->idx]
            );
        }

--$list->idx;

if (is_array($ret)) {
            $retIndex = count($ret) - 1;
            if (isset($ret[$retIndex])) {
                $expr = $ret[$retIndex]->expr;
                if (preg_match('/\s*--\s.*$/', $expr, $matches)) {
                    $found = $matches[0];
                    $ret[$retIndex]->expr = substr($expr, 0, strlen($expr) - strlen($found));
                }
            }
        }

return $ret;
    }

/**
     * @param Expression[] $component the component to be built
     * @param array        $options   parameters for building
     *
     * @return string
     */
    public static function build($component, array $options = [])
    {
        $ret = [];
        foreach ($component as $frag) {
            $ret[] = $frag::build($frag);
        }

return implode(', ', $ret);
    }
}

1 * * 1 ------------------------[ , ]------------------------> 0 * 1 -----------------------[ else ]----------------------> (END) * * @var int */ $state = 0; for (; $list->idx < $list->count; ++$list->idx) { /** * Token parsed at this moment. * * @var Token */ $token = $list->tokens[$list->idx]; // End of statement. if ($token->type === Token::TYPE_DELIMITER) { break; } // Skipping whitespaces and comments. if (($token->type === Token::TYPE_WHITESPACE) || ($token->type === Token::TYPE_COMMENT)) { continue; } if (($token->type === Token::TYPE_KEYWORD) && ($token->flags & Token::FLAG_KEYWORD_RESERVED) && ((~$token->flags & Token::FLAG_KEYWORD_FUNCTION)) && ($token->value !== 'DUAL') && ($token->value !== 'NULL') && ($token->value !== 'CASE') ) { // No keyword is expected. break; } if ($state === 0) { if ($token->type === Token::TYPE_KEYWORD && $token->value === 'CASE' ) { $expr = CaseExpression::parse($parser, $list, $options); } else { $expr = Expression::parse($parser, $list, $options); } if ($expr === null) { break; } $ret[] = $expr; $state = 1; } elseif ($state === 1) { if ($token->value === ',') { $state = 0; } else { break; } } } if ($state === 0) { $parser->error( 'An expression was expected.', $list->tokens[$list->idx] ); } --$list->idx; if (is_array($ret)) { $retIndex = count($ret) - 1; if (isset($ret[$retIndex])) { $expr = $ret[$retIndex]->expr; if (preg_match('/\s*--\s.*$/', $expr, $matches)) { $found = $matches[0]; $ret[$retIndex]->expr = substr($expr, 0, strlen($expr) - strlen($found)); } } } return $ret; } /** * @param Expression[] $component the component to be built * @param array $options parameters for building * * @return string */ public static function build($component, array $options = []) { $ret = []; foreach ($component as $frag) { $ret[] = $frag::build($frag); } return implode(', ', $ret); } }