File "SQLParserUtils.php"

Full Path: /home/warrior1/public_html/wp-content/plugins/mailpoet/vendor-prefixed/doctrine/dbal/lib/Doctrine/DBAL/SQLParserUtils.php
File size: 6.08 KB
MIME-type: text/x-php
Charset: utf-8

<?php
namespace MailPoetVendor\Doctrine\DBAL;
if (!defined('ABSPATH')) exit;
use MailPoetVendor\Doctrine\DBAL\Types\Type;
use function array_fill;
use function array_fill_keys;
use function array_key_exists;
use function array_keys;
use function array_merge;
use function array_slice;
use function array_values;
use function count;
use function implode;
use function is_int;
use function key;
use function ksort;
use function preg_match_all;
use function sprintf;
use function strlen;
use function strpos;
use function substr;
use const PREG_OFFSET_CAPTURE;
class SQLParserUtils
{
 public const POSITIONAL_TOKEN = '\\?';
 public const NAMED_TOKEN = '(?<!:):[a-zA-Z_][a-zA-Z0-9_]*';
 // Quote characters within string literals can be preceded by a backslash.
 public const ESCAPED_SINGLE_QUOTED_TEXT = "(?:'(?:\\\\)+'|'(?:[^'\\\\]|\\\\'?|'')*')";
 public const ESCAPED_DOUBLE_QUOTED_TEXT = '(?:"(?:\\\\)+"|"(?:[^"\\\\]|\\\\"?)*")';
 public const ESCAPED_BACKTICK_QUOTED_TEXT = '(?:`(?:\\\\)+`|`(?:[^`\\\\]|\\\\`?)*`)';
 private const ESCAPED_BRACKET_QUOTED_TEXT = '(?<!\\b(?i:ARRAY))\\[(?:[^\\]])*\\]';
 public static function getPlaceholderPositions($statement, $isPositional = \true)
 {
 return $isPositional ? self::getPositionalPlaceholderPositions($statement) : self::getNamedPlaceholderPositions($statement);
 }
 private static function getPositionalPlaceholderPositions(string $statement) : array
 {
 return self::collectPlaceholders($statement, '?', self::POSITIONAL_TOKEN, static function (string $_, int $placeholderPosition, int $fragmentPosition, array &$carry) : void {
 $carry[] = $placeholderPosition + $fragmentPosition;
 });
 }
 private static function getNamedPlaceholderPositions(string $statement) : array
 {
 return self::collectPlaceholders($statement, ':', self::NAMED_TOKEN, static function (string $placeholder, int $placeholderPosition, int $fragmentPosition, array &$carry) : void {
 $carry[$placeholderPosition + $fragmentPosition] = substr($placeholder, 1);
 });
 }
 private static function collectPlaceholders(string $statement, string $match, string $token, callable $collector) : array
 {
 if (strpos($statement, $match) === \false) {
 return [];
 }
 $carry = [];
 foreach (self::getUnquotedStatementFragments($statement) as $fragment) {
 preg_match_all('/' . $token . '/', $fragment[0], $matches, PREG_OFFSET_CAPTURE);
 foreach ($matches[0] as $placeholder) {
 $collector($placeholder[0], $placeholder[1], $fragment[1], $carry);
 }
 }
 return $carry;
 }
 public static function expandListParameters($query, $params, $types)
 {
 $isPositional = is_int(key($params));
 $arrayPositions = [];
 $bindIndex = -1;
 if ($isPositional) {
 // make sure that $types has the same keys as $params
 // to allow omitting parameters with unspecified types
 $types += array_fill_keys(array_keys($params), null);
 ksort($params);
 ksort($types);
 }
 foreach ($types as $name => $type) {
 ++$bindIndex;
 if ($type !== Connection::PARAM_INT_ARRAY && $type !== Connection::PARAM_STR_ARRAY) {
 continue;
 }
 if ($isPositional) {
 $name = $bindIndex;
 }
 $arrayPositions[$name] = \false;
 }
 if (!$arrayPositions && $isPositional) {
 return [$query, $params, $types];
 }
 if ($isPositional) {
 $paramOffset = 0;
 $queryOffset = 0;
 $params = array_values($params);
 $types = array_values($types);
 $paramPos = self::getPositionalPlaceholderPositions($query);
 foreach ($paramPos as $needle => $needlePos) {
 if (!isset($arrayPositions[$needle])) {
 continue;
 }
 $needle += $paramOffset;
 $needlePos += $queryOffset;
 $count = count($params[$needle]);
 $params = array_merge(array_slice($params, 0, $needle), $params[$needle], array_slice($params, $needle + 1));
 $types = array_merge(array_slice($types, 0, $needle), $count ? array_fill(0, $count, $types[$needle] - Connection::ARRAY_PARAM_OFFSET) : [], array_slice($types, $needle + 1));
 $expandStr = $count ? implode(', ', array_fill(0, $count, '?')) : 'NULL';
 $query = substr($query, 0, $needlePos) . $expandStr . substr($query, $needlePos + 1);
 $paramOffset += $count - 1;
 // Grows larger by number of parameters minus the replaced needle.
 $queryOffset += strlen($expandStr) - 1;
 }
 return [$query, $params, $types];
 }
 $queryOffset = 0;
 $typesOrd = [];
 $paramsOrd = [];
 $paramPos = self::getNamedPlaceholderPositions($query);
 foreach ($paramPos as $pos => $paramName) {
 $paramLen = strlen($paramName) + 1;
 $value = self::extractParam($paramName, $params, \true);
 if (!isset($arrayPositions[$paramName]) && !isset($arrayPositions[':' . $paramName])) {
 $pos += $queryOffset;
 $queryOffset -= $paramLen - 1;
 $paramsOrd[] = $value;
 $typesOrd[] = self::extractParam($paramName, $types, \false, ParameterType::STRING);
 $query = substr($query, 0, $pos) . '?' . substr($query, $pos + $paramLen);
 continue;
 }
 $count = count($value);
 $expandStr = $count > 0 ? implode(', ', array_fill(0, $count, '?')) : 'NULL';
 foreach ($value as $val) {
 $paramsOrd[] = $val;
 $typesOrd[] = self::extractParam($paramName, $types, \false) - Connection::ARRAY_PARAM_OFFSET;
 }
 $pos += $queryOffset;
 $queryOffset += strlen($expandStr) - $paramLen;
 $query = substr($query, 0, $pos) . $expandStr . substr($query, $pos + $paramLen);
 }
 return [$query, $paramsOrd, $typesOrd];
 }
 private static function getUnquotedStatementFragments($statement)
 {
 $literal = self::ESCAPED_SINGLE_QUOTED_TEXT . '|' . self::ESCAPED_DOUBLE_QUOTED_TEXT . '|' . self::ESCAPED_BACKTICK_QUOTED_TEXT . '|' . self::ESCAPED_BRACKET_QUOTED_TEXT;
 $expression = sprintf('/((.+(?i:ARRAY)\\[.+\\])|([^\'"`\\[]+))(?:%s)?/s', $literal);
 preg_match_all($expression, $statement, $fragments, PREG_OFFSET_CAPTURE);
 return $fragments[1];
 }
 private static function extractParam($paramName, $paramsOrTypes, $isParam, $defaultValue = null)
 {
 if (array_key_exists($paramName, $paramsOrTypes)) {
 return $paramsOrTypes[$paramName];
 }
 // Hash keys can be prefixed with a colon for compatibility
 if (array_key_exists(':' . $paramName, $paramsOrTypes)) {
 return $paramsOrTypes[':' . $paramName];
 }
 if ($defaultValue !== null) {
 return $defaultValue;
 }
 if ($isParam) {
 throw SQLParserUtilsException::missingParam($paramName);
 }
 throw SQLParserUtilsException::missingType($paramName);
 }
}