PommProject\Foundation\QueryManager\QueryParameterParserTrait

Complexity

Total Complexity

3

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
	getSession()	0	1	?
A	unorderParameters()	0	4	1
A	orderParameters()	0	12	1
A	getParametersType()	0	6	1

<?php
/*
 * This file is part of the Pomm's Foundation package.
 *
 * (c) 2014 - 2017 Grégoire HUBERT <hubert.greg@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
namespace PommProject\Foundation\QueryManager;

/**
 * QueryParameterParserTrait
 *
 * Trait that makes query managers to parse, expand anc convert query
 * parameters.
 *
 * @package     Foundation
 * @copyright   2014 - 2017 Grégoire HUBERT
 * @author      Grégoire HUBERT
 * @license     X11 {@link http://opensource.org/licenses/mit-license.php}
 */
trait QueryParameterParserTrait
{
    abstract protected function getSession();

    /**
     * unorderParameters
     *
     * Transform an ordered parameters list with $1, $2 to $* parameters.
     *
     * @param  string $string
     * @return string
     */
    public function unorderParameters($string)
    {
        return preg_replace('/\$[0-9]+/', '$*', $string);
    }

    /**
     * orderParameters
     *
     * Transform an unordered parameters list $* to ordered $1, $2 parameters.
     *
     * @param  string $string
     * @return string
     */
    public function orderParameters($string)
    {
        return preg_replace_callback(
            '/\$\*/',
            function () {
                static $nb = 0;

                return sprintf("$%d", ++$nb);
            },
            $string
        );
    }

    /**
     * getParametersType
     *
     * Return an array of the type specified with the parameters if any. It is
     * possible to give the type when passing parameters like « SELECT … WHERE
     * field = $*::timestamptz ». In this case, PostgreSQL will assume the
     * given parameter is a timestamp. Pomm uses these type hints to convert
     * PHP representation to PostgreSQL data value.
     *
     * @param   mixed $string SQL query.
     * @return  array
     */
    public function getParametersType($string)
    {
        preg_match_all('/\$\*(?:::([\w\."]+(?:\[\])?))?/', $string, $matches);

        return str_replace('"', '', $matches[1]);
    }
}