Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
AlterOperation.php	15.26 KB	-rw-r--r--	2023-01-25 10:43
Array2d.php	3.39 KB	-rw-r--r--	2023-01-25 10:43
ArrayObj.php	4.85 KB	-rw-r--r--	2023-01-25 10:43
CaseExpression.php	9.7 KB	-rw-r--r--	2023-01-25 10:43
Condition.php	6.01 KB	-rw-r--r--	2023-01-25 10:43
CreateDefinition.php	10.57 KB	-rw-r--r--	2023-01-25 10:43
DataType.php	4.71 KB	-rw-r--r--	2023-01-25 10:43
Expression.php	15.6 KB	-rw-r--r--	2023-01-25 10:43
ExpressionArray.php	3.91 KB	-rw-r--r--	2023-01-25 10:43
FunctionCall.php	2.94 KB	-rw-r--r--	2023-01-25 10:43
GroupKeyword.php	3.34 KB	-rw-r--r--	2023-01-25 10:43
IndexHint.php	6.31 KB	-rw-r--r--	2023-01-25 10:43
IntoKeyword.php	8.34 KB	-rw-r--r--	2023-01-25 10:43
JoinKeyword.php	6.15 KB	-rw-r--r--	2023-01-25 10:43
Key.php	9.16 KB	-rw-r--r--	2023-01-25 10:43
Limit.php	3.06 KB	-rw-r--r--	2023-01-25 10:43
LockExpression.php	5.62 KB	-rw-r--r--	2023-01-25 10:43
OptionsArray.php	12.07 KB	-rw-r--r--	2023-01-25 10:43
OrderKeyword.php	3.46 KB	-rw-r--r--	2023-01-25 10:43
ParameterDefinition.php	4.54 KB	-rw-r--r--	2023-01-25 10:43
PartitionDefinition.php	6.97 KB	-rw-r--r--	2023-01-25 10:43
Reference.php	3.95 KB	-rw-r--r--	2023-01-25 10:43
RenameOperation.php	4.45 KB	-rw-r--r--	2023-01-25 10:43
SetOperation.php	4.15 KB	-rw-r--r--	2023-01-25 10:43
UnionKeyword.php	674 B	-rw-r--r--	2023-01-25 10:43
WithKeyword.php	1.29 KB	-rw-r--r--	2023-01-25 10:43

Rename

<?php

declare(strict_types=1);

namespace PhpMyAdmin\SqlParser\Components;

use PhpMyAdmin\SqlParser\Component;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Token;
use PhpMyAdmin\SqlParser\TokensList;

/**
 * `LIMIT` keyword parser.
 *
 * @final
 */
class Limit extends Component
{
    /**
     * The number of rows skipped.
     *
     * @var int
     */
    public $offset;

/**
     * The number of rows to be returned.
     *
     * @var int
     */
    public $rowCount;

/**
     * @param int $rowCount the row count
     * @param int $offset   the offset
     */
    public function __construct($rowCount = 0, $offset = 0)
    {
        $this->rowCount = $rowCount;
        $this->offset = $offset;
    }

/**
     * @param Parser               $parser  the parser that serves as context
     * @param TokensList           $list    the list of tokens that are being parsed
     * @param array<string, mixed> $options parameters for parsing
     *
     * @return Limit
     */
    public static function parse(Parser $parser, TokensList $list, array $options = [])
    {
        $ret = new static();

$offset = false;

for (; $list->idx < $list->count; ++$list->idx) {
            /**
             * Token parsed at this moment.
             */
            $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)) {
                break;
            }

if ($token->type === Token::TYPE_KEYWORD && $token->keyword === 'OFFSET') {
                if ($offset) {
                    $parser->error('An offset was expected.', $token);
                }

$offset = true;
                continue;
            }

if (($token->type === Token::TYPE_OPERATOR) && ($token->value === ',')) {
                $ret->offset = $ret->rowCount;
                $ret->rowCount = 0;
                continue;
            }

// Skip if not a number
            if (($token->type !== Token::TYPE_NUMBER)) {
                break;
            }

if ($offset) {
                $ret->offset = $token->value;
                $offset = false;
            } else {
                $ret->rowCount = $token->value;
            }
        }

if ($offset) {
            $parser->error('An offset was expected.', $list->tokens[$list->idx - 1]);
        }

--$list->idx;

return $ret;
    }

/**
     * @param Limit                $component the component to be built
     * @param array<string, mixed> $options   parameters for building
     *
     * @return string
     */
    public static function build($component, array $options = [])
    {
        return $component->offset . ', ' . $component->rowCount;
    }
}