FileMaster

Edit File: Parser.php

<?php
namespace MailPoetVendor\Doctrine\DBAL\SQL;
if (!defined('ABSPATH')) exit;
use MailPoetVendor\Doctrine\DBAL\SQL\Parser\Exception;
use MailPoetVendor\Doctrine\DBAL\SQL\Parser\Exception\RegularExpressionError;
use MailPoetVendor\Doctrine\DBAL\SQL\Parser\Visitor;
use function array_merge;
use function implode;
use function preg_last_error;
use function preg_match;
use function sprintf;
use function strlen;
use const PREG_NO_ERROR;
final class Parser
{
 private const SPECIAL_CHARS = ':\\?\'"`\\[\\-\\/';
 private const BACKTICK_IDENTIFIER = '`[^`]*`';
 private const BRACKET_IDENTIFIER = '(?<!\\b(?i:ARRAY))\\[(?:[^\\]])*\\]';
 private const MULTICHAR = ':{2,}';
 private const NAMED_PARAMETER = ':[a-zA-Z0-9_]+';
 private const POSITIONAL_PARAMETER = '(?<!\\?)\\?(?!\\?)';
 private const ONE_LINE_COMMENT = '--[^\\r\\n]*';
 private const MULTI_LINE_COMMENT = '/\\*([^*]+|\\*+[^/*])*\\**\\*/';
 private const SPECIAL = '[' . self::SPECIAL_CHARS . ']';
 private const OTHER = '[^' . self::SPECIAL_CHARS . ']+';
 private string $sqlPattern;
 private string $tokenPattern;
 public function __construct(bool $mySQLStringEscaping)
 {
 if ($mySQLStringEscaping) {
 $patterns = [$this->getMySQLStringLiteralPattern("'"), $this->getMySQLStringLiteralPattern('"')];
 } else {
 $patterns = [$this->getAnsiSQLStringLiteralPattern("'"), $this->getAnsiSQLStringLiteralPattern('"')];
 }
 $patterns = array_merge($patterns, [self::BACKTICK_IDENTIFIER, self::BRACKET_IDENTIFIER, self::MULTICHAR, self::ONE_LINE_COMMENT, self::MULTI_LINE_COMMENT, self::OTHER]);
 $this->sqlPattern = sprintf('(%s)', implode('|', $patterns));
 $this->tokenPattern = '~\\G' . '(?P<named>' . self::NAMED_PARAMETER . ')' . '|(?P<positional>' . self::POSITIONAL_PARAMETER . ')' . '|(?P<other>' . $this->sqlPattern . '|' . self::SPECIAL . ')' . '~s';
 }
 public function parse(string $sql, Visitor $visitor) : void
 {
 $offset = 0;
 $length = strlen($sql);
 while ($offset < $length) {
 if (preg_match($this->tokenPattern, $sql, $matches, 0, $offset) === 1) {
 $match = $matches[0];
 if ($matches['named'] !== '') {
 $visitor->acceptNamedParameter($match);
 } elseif ($matches['positional'] !== '') {
 $visitor->acceptPositionalParameter($match);
 } else {
 $visitor->acceptOther($match);
 }
 $offset += strlen($match);
 } elseif (preg_last_error() !== PREG_NO_ERROR) {
 // @codeCoverageIgnoreStart
 throw RegularExpressionError::new();
 // @codeCoverageIgnoreEnd
 }
 }
 }
 private function getMySQLStringLiteralPattern(string $delimiter) : string
 {
 return $delimiter . '((\\\\.)|(?![' . $delimiter . '\\\\]).)*' . $delimiter;
 }
 private function getAnsiSQLStringLiteralPattern(string $delimiter) : string
 {
 return $delimiter . '[^' . $delimiter . ']*' . $delimiter;
 }
}

Back