/ usr / share / php / PhpMyAdmin / SqlParser / Components / [ HOME SHELL ]

Name	Size	Permission	Action
AlterOperation.php	9.38 KB	-rw-r--r--
Array2d.php	3.56 KB	-rw-r--r--
ArrayObj.php	4.95 KB	-rw-r--r--
CaseExpression.php	9.83 KB	-rw-r--r--
Condition.php	5.91 KB	-rw-r--r--
CreateDefinition.php	10.6 KB	-rw-r--r--
DataType.php	4.56 KB	-rw-r--r--
Expression.php	15 KB	-rw-r--r--
ExpressionArray.php	4 KB	-rw-r--r--
FunctionCall.php	2.93 KB	-rw-r--r--
GroupKeyword.php	3.37 KB	-rw-r--r--
IndexHint.php	6.32 KB	-rw-r--r--
IntoKeyword.php	7.94 KB	-rw-r--r--
JoinKeyword.php	6.3 KB	-rw-r--r--
Key.php	5.42 KB	-rw-r--r--
Limit.php	3.11 KB	-rw-r--r--
LockExpression.php	5.7 KB	-rw-r--r--
OptionsArray.php	12.15 KB	-rw-r--r--
OrderKeyword.php	3.51 KB	-rw-r--r--
ParameterDefinition.php	4.6 KB	-rw-r--r--
PartitionDefinition.php	6.94 KB	-rw-r--r--
Reference.php	3.83 KB	-rw-r--r--
RenameOperation.php	4.79 KB	-rw-r--r--
SetOperation.php	4.16 KB	-rw-r--r--
UnionKeyword.php	696 B	-rw-r--r--

Code Editor : Condition.php

<?php
/**
 * `WHERE` keyword parser.
 */

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Components;

use PhpMyAdmin\SqlParser\Component;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Token;
use PhpMyAdmin\SqlParser\TokensList;
use function implode;
use function in_array;
use function is_array;
use function trim;

/**
 * `WHERE` keyword parser.
 */
class Condition extends Component
{
    /**
     * Logical operators that can be used to delimit expressions.
     *
     * @var array
     */
    public static $DELIMITERS = [
        '&&',
        '||',
        'AND',
        'OR',
        'XOR',
    ];

/**
     * List of allowed reserved keywords in conditions.
     *
     * @var array
     */
    public static $ALLOWED_KEYWORDS = [
        'ALL' => 1,
        'AND' => 1,
        'BETWEEN' => 1,
        'EXISTS' => 1,
        'IF' => 1,
        'IN' => 1,
        'INTERVAL' => 1,
        'IS' => 1,
        'LIKE' => 1,
        'MATCH' => 1,
        'NOT IN' => 1,
        'NOT NULL' => 1,
        'NOT' => 1,
        'NULL' => 1,
        'OR' => 1,
        'REGEXP' => 1,
        'RLIKE' => 1,
        'XOR' => 1,
    ];

/**
     * Identifiers recognized.
     *
     * @var array
     */
    public $identifiers = [];

/**
     * Whether this component is an operator.
     *
     * @var bool
     */
    public $isOperator = false;

/**
     * The condition.
     *
     * @var string
     */
    public $expr;

/**
     * @param string $expr the condition or the operator
     */
    public function __construct($expr = null)
    {
        $this->expr = trim((string) $expr);
    }

/**
     * @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 Condition[]
     */
    public static function parse(Parser $parser, TokensList $list, array $options = [])
    {
        $ret = [];

$expr = new static();

/**
         * Counts brackets.
         *
         * @var int
         */
        $brackets = 0;

/**
         * Whether there was a `BETWEEN` keyword before or not.
         *
         * It is required to keep track of them because their structure contains
         * the keyword `AND`, which is also an operator that delimits
         * expressions.
         *
         * @var bool
         */
        $betweenBefore = false;

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_COMMENT) {
                continue;
            }

// Replacing all whitespaces (new lines, tabs, etc.) with a single
            // space character.
            if ($token->type === Token::TYPE_WHITESPACE) {
                $expr->expr .= ' ';
                continue;
            }

// Conditions are delimited by logical operators.
            if (in_array($token->value, static::$DELIMITERS, true)) {
                if ($betweenBefore && ($token->value === 'AND')) {
                    // The syntax of keyword `BETWEEN` is hard-coded.
                    $betweenBefore = false;
                } else {
                    // The expression ended.
                    $expr->expr = trim($expr->expr);
                    if (! empty($expr->expr)) {
                        $ret[] = $expr;
                    }

// Adding the operator.
                    $expr = new static($token->value);
                    $expr->isOperator = true;
                    $ret[] = $expr;

// Preparing to parse another condition.
                    $expr = new static();
                    continue;
                }
            }

if (($token->type === Token::TYPE_KEYWORD)
                && ($token->flags & Token::FLAG_KEYWORD_RESERVED)
                && ! ($token->flags & Token::FLAG_KEYWORD_FUNCTION)
            ) {
                if ($token->value === 'BETWEEN') {
                    $betweenBefore = true;
                }

if (($brackets === 0) && empty(static::$ALLOWED_KEYWORDS[$token->value])) {
                    break;
                }
            }

if ($token->type === Token::TYPE_OPERATOR) {
                if ($token->value === '(') {
                    ++$brackets;
                } elseif ($token->value === ')') {
                    if ($brackets === 0) {
                        break;
                    }

--$brackets;
                }
            }

$expr->expr .= $token->token;
            if (($token->type === Token::TYPE_NONE)
                || (($token->type === Token::TYPE_KEYWORD)
                && (! ($token->flags & Token::FLAG_KEYWORD_RESERVED)))
                || ($token->type === Token::TYPE_STRING)
                || ($token->type === Token::TYPE_SYMBOL)
            ) {
                if (! in_array($token->value, $expr->identifiers)) {
                    $expr->identifiers[] = $token->value;
                }
            }
        }

// Last iteration was not processed.
        $expr->expr = trim($expr->expr);
        if (! empty($expr->expr)) {
            $ret[] = $expr;
        }

--$list->idx;

return $ret;
    }

/**
     * @param Condition[] $component the component to be built
     * @param array       $options   parameters for building
     *
     * @return string
     */
    public static function build($component, array $options = [])
    {
        if (is_array($component)) {
            return implode(' ', $component);
        }

return $component->expr;
    }
}

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.