Brouzie\Sphinxy\Util::prepareQuery()

Complexity

Conditions	5
Paths	7

Size

Total Lines	47
Code Lines	27

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	32
CRAP Score	5

Importance

Changes

0

<?php
    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);
    }
}