Muffin\Queries\Snippets\Values

Complexity

Total Complexity

15

Size/Duplication

Total Lines	96
Duplicated Lines	11.46 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

100%

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	9	2
A	values()	0	6	1
B	toString()	0	26	4
A	buildValuesSetString()	0	15	3
A	formatValue()	0	9	2
A	escapeValue()	11	11	2
A	wrapWithParentheses()	0	4	1

<?php

namespace Muffin\Queries\Snippets;

use Muffin\Snippet;
use Muffin\Type;
use Muffin\Types;
use Muffin\Traits\EscaperAware;
use Muffin\Types\String;
use Muffin\Traits\TypeGuesser;

class Values implements Snippet
{
    use
        EscaperAware,
        TypeGuesser;

    private
        $values;

    public function __construct($values = null)
    {
        $this->values = array();

        if(! empty($values))
        {
            $this->values($values);
        }
    }

    public function values(array $values)

Using PHP4-style constructors that are named like the class is not recommend; better use the more explicit __construct method.

    {
        $this->values[] = $values;

        return $this;
    }

    public function toString()
    {
        if(empty($this->values))
        {
            throw new \RuntimeException('No values to insert');
        }

        $columnsNameList = array_filter(array_keys(reset($this->values)));

        $values = array();
        foreach($this->values as $valuesSet)
        {
            if($columnsNameList !== array_keys($valuesSet))
            {
                throw new \RuntimeException('Cannot insert different schema on the same table.');
            }

            $values[] = $this->buildValuesSetString($valuesSet);
        }

        return sprintf(
            '%s VALUES %s',
            $this->wrapWithParentheses(implode(', ', $columnsNameList)),
            implode(', ', $values)
        );
    }

    private function buildValuesSetString(array $values)
    {
        $valuesSet = array();
        foreach($values as $columnName => $value)
        {
            if(! empty($columnName))
            {
                $type = $this->guessType($columnName, $value);

                $valuesSet[] = $this->formatValue($type, $value);
            }
        }

        return $this->wrapWithParentheses(implode(', ', $valuesSet));
    }

    private function formatValue(Type $type, $value)
    {
        if(is_null($value))
        {
            return 'NULL';
        }

        return $this->escapeValue($type, $value);
    }

    private function escapeValue(Type $type, $value)

This method seems to be duplicated in your project.

    {
        $value = $type->format($value);

        if($type->isEscapeRequired())
        {
            $value = $this->escaper->escape($value);
        }

        return $value;
    }

    private function wrapWithParentheses($value)
    {
        return sprintf('(%s)', $value);
    }
}