ByJG\AnyDataset\Store\Helpers\SqlBind

Complexity

Total Complexity

8

Size/Duplication

Total Lines	89
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Test Coverage

Coverage

97.62%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getParamModel()	0	8	2
B	parseSQL()	0	55	5
A	keyAdj()	0	4	1

<?php

namespace ByJG\AnyDataset\Store\Helpers;

use ByJG\Util\Uri;

/**
 * Class to create and manipulate Several Data Types
 *
 */
class SqlBind
{

    /**
     * Each provider have your own model for pass parameter.
     * This method define how each provider name define the parameters
     *
     * @param Uri $connData
     * @return string
     */
    public static function getParamModel(Uri $connData)
    {
        if ($connData->getQueryPart("parammodel") != "") {
            return $connData->getQueryPart("parammodel");
        }

        return ":_";
    }

    /**
     * Transform generic parameters [[PARAM]] in a parameter recognized by the provider
     * name based on current DbParameter array.
     *
     * @param Uri $connData
     * @param string $sql
     * @param array $params
     * @return array An array with the adjusted SQL and PARAMs
     */
    public static function parseSQL(Uri $connData, $sql, $params = null)
    {
        $paramSubstName = SqlBind::getParamModel($connData);

        $sqlAlter = preg_replace("~'.*?'~", "", $sql);
        preg_match_all(
            "/(?<deliStart>\\[\\[|:)(?<param>[\\w\\d]+)(?<deliEnd>\\]\\]|[^\\d\\w]|$)/",
            $sqlAlter,
            $matches
        );

        $usedParams = [];

        if (is_null($params)) {
            $params = [];
        }

        foreach ($matches['param'] as $paramName) {
            if (!array_key_exists($paramName, $params)) {
                // Remove NON DEFINED parameters
                $sql = preg_replace(
                    [
                        "/\\[\\[$paramName\\]\\]/",
                        "/:$paramName([^\\d\\w]|$)/"
                    ],
                    [
                        "null",
                        "null$2"
                    ],
                    $sql
                );
                continue;
            }

            $usedParams[$paramName] = isset($params[$paramName]) ? $params[$paramName] : null;
            $dbArg = str_replace("_", SqlBind::keyAdj($paramName), $paramSubstName);

            $count = 0;
            $sql = preg_replace(
                [
                    "/\\[\\[$paramName\\]\\]/",
                    "/:$paramName([^\\w\\d]|$)/",
                ],
                [
                    $dbArg . '',
                    $dbArg . '$1',
                ],
                $sql,
                -1,
                $count
            );
        }

        return [$sql, $usedParams];
    }

    public static function keyAdj($key)
    {
        return str_replace(".", "_", $key);
    }
}