Tsukasa\QueryBuilder\Expression\Expression::generateSql()

Complexity

Conditions	6
Paths	6

Size

Total Lines	38
Code Lines	19

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function generateSql()
    {
        $sql = $this->expression;

        if (strpos($sql, '{') !== false)
        {
            $tableAlias = $this->qb->getAlias();

            $sql = preg_replace_callback('~\{([^\}]+)\}~', function($matches) use ($tableAlias) {
                $rawColumn = $matches[1];

                list(, $column) = $this->qb->getLookupBuilder()->parseLookup($this->qb, $rawColumn, null);
                $column = $this->qb->getLookupBuilder()->fetchColumnName($column);

The method fetchColumnName() does not exist on Tsukasa\QueryBuilder\Interfaces\ILookupBuilder. Since it exists in all sub-types, consider adding an abstract or default implementation to Tsukasa\QueryBuilder\Interfaces\ILookupBuilder.

                if ($tableAlias !== null && strpos($column, '.') === false) {
                    $column = $tableAlias . '.' . $column;
                }

                return $this->qb->getAdapter()->buildColumns($column);

            }, $sql);
        }

        if (strpos($sql, '?'))
        {
            if (mb_substr_count($sql, '?') !== count($this->params)) {
                throw new QBException('Incorrect parameters count in Expression: "' . addslashes($this->expression) . '"');
            }

            $sql = preg_replace_callback('~\?~', function($matches) {

The parameter $matches is not used and could be removed.

                return $this->qb->getAdapter()->quoteValue(
                    $this->getNextParam()
                );
            }, $sql);

        }

        return $sql;
    }
}