Brouzie\Sphinxy\Util

Complexity

Total Complexity

5

Size/Duplication

Total Lines	60
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	prepareQuery()	0	47	5

<?php

namespace Brouzie\Sphinxy;

use Brouzie\Sphinxy\Exception\ExtraParametersException;
use Brouzie\Sphinxy\Exception\ParameterNotFoundException;

class Util
{
    /**
     * This code ported from https://github.com/auraphp/Aura.Sql/blob/master/src/Aura/Sql/Connection/AbstractConnection.php.
     *
     * @param $query
     * @param $params
     *
     * @license http://opensource.org/licenses/bsd-license.php BSD
     *
     * @return string
     */
    public static function prepareQuery($query, $params, Escaper $escaper)
    {
        // find all text parts not inside quotes or backslashed-quotes
        $apos = "'";
        $quot = '"';
        $parts = preg_split(
            "/(($apos+|$quot+|\\$apos+|\\$quot+).*?)\\2/m",
            $query,
            -1,
            PREG_SPLIT_DELIM_CAPTURE
        );

        $usedParams = array();
        // loop through the non-quoted parts (0, 3, 6, 9, etc.)
        for ($i = 0, $k = count($parts); $i <= $k; $i += 3) {
            // get the part as a reference so it can be modified in place
            $part = &$parts[$i];

            // find all :placeholder matches in the part
            preg_match_all(
                "/\W:([a-zA-Z_][a-zA-Z0-9_]*)/m",
                $part.PHP_EOL,
                $matches
            );

            // for each of the :placeholder matches ...
            foreach ($matches[1] as $key) {
                if (!array_key_exists($key, $params)) {
                    throw new ParameterNotFoundException(sprintf('The parameter "%s" not found.', $key));
                }

                $find = "/(^|\W)(:$key)(\W|$)/m";
                $repl = '${1}'.addcslashes($escaper->quote($params[$key]), '\\').'${3}';
                $part = preg_replace($find, $repl, $part);
                $usedParams[$key] = true;
            }
        }

        if (count($params) > count($usedParams)) {
            throw new ExtraParametersException(sprintf(
                'Extra parameters found: %s.',
                implode(', ', array_keys(array_diff_key($params, $usedParams)))
            ));
        }

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