ByJG\AnyDataset\Database\SqlBind

Complexity

Total Complexity

8

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getParamModel()	0	10	3
A	parseSQL()	0	21	4
A	keyAdj()	0	4	1

<?php

namespace ByJG\AnyDataset\Database;

use ByJG\AnyDataset\ConnectionManagement;

/**
 * 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 ConnectionManagement $connData
     * @return string
     */
    public static function getParamModel(ConnectionManagement $connData)
    {
        if ($connData->getExtraParam("parammodel") != "") {
            return $connData->getExtraParam("parammodel");
        } elseif ($connData->getDriver() == "sqlrelay") {
            return "?";
        } else {
            return ":_";
        }
    }

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

        $paramSubstName = SqlBind::getParamModel($connData);
        foreach ($params as $key => $value) {
            $arg = str_replace("_", SqlBind::keyAdj($key), $paramSubstName);

            $count = 0;
            $sql = preg_replace("/(\[\[$key\]\]|:" . $key . "[\s\W]|:$key\$)/", $arg . ' ', $sql, -1, $count);
            if ($count === 0) {
                unset($params[$key]);
            }
        }

        $sql = preg_replace("/\[\[(.*?)\]\]/", "null", $sql);

        return [$sql, $params];
    }

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