Hgraca\MicroDbal\Test\Crud\QueryBuilder\Sql\WhereTokenUnitTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	97
Duplicated Lines	26.8 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	toString_GeneratesCorrectSqlWithAnd()	0	13	1
A	toString_GeneratesCorrectSqlWithOr()	0	13	1
A	toString_GeneratesCorrectSqlWithIs()	13	13	1
A	toString_GeneratesCorrectSqlWithOtherComparison()	13	13	1
A	geBinding_WithOneDimensionFilter()	0	13	1

<?php

namespace Hgraca\MicroDbal\Test\Crud\QueryBuilder\Sql;

use Hgraca\MicroDbal\Crud\QueryBuilder\Sql\WhereToken;
use PHPUnit_Framework_TestCase;

final class WhereTokenUnitTest extends PHPUnit_Framework_TestCase
{
    /**
     * @test
     *
     * @small
     */
    public function toString_GeneratesCorrectSqlWithAnd()
    {
        $column = 'dummy_column';
        $value = 'something';
        $bindingCounter = 5;

        $whereToken = new WhereToken($column, $value, $bindingCounter);

        self::assertEquals(
            "`$column`" . WhereToken::COMPARISON_EQUAL . WhereToken::BINDING_PREFIX . $bindingCounter,
            $whereToken->toString()
        );
    }

    /**
     * @test
     *
     * @small
     */
    public function toString_GeneratesCorrectSqlWithOr()
    {
        $column = 'dummy_column';
        $value = 'something';
        $bindingCounter = 5;

        $whereToken = new WhereToken($column, $value, $bindingCounter);

        self::assertEquals(
            "`$column`" . WhereToken::COMPARISON_EQUAL . WhereToken::BINDING_PREFIX . $bindingCounter,
            $whereToken->toString()
        );
    }

    /**
     * @test
     *
     * @small
     */
    public function toString_GeneratesCorrectSqlWithIs()

This method seems to be duplicated in your project.

    {
        $column = 'dummy_column';
        $value = null;
        $bindingCounter = 5;

        $whereToken = new WhereToken($column, $value, $bindingCounter);

        self::assertEquals(
            "`$column`" . WhereToken::COMPARISON_IS . WhereToken::BINDING_PREFIX . $bindingCounter,
            $whereToken->toString()
        );
    }

    /**
     * @test
     *
     * @small
     */
    public function toString_GeneratesCorrectSqlWithOtherComparison()

This method seems to be duplicated in your project.

    {
        $column = 'dummy_column';
        $value = 4;
        $bindingCounter = 5;

        $whereToken = new WhereToken($column, $value, $bindingCounter, WhereToken::COMPARISON_HIGHER_OR_EQUAL);

        self::assertEquals(
            "`$column`" . WhereToken::COMPARISON_HIGHER_OR_EQUAL . WhereToken::BINDING_PREFIX . $bindingCounter,
            $whereToken->toString()
        );
    }

    /**
     * @test
     *
     * @small
     */
    public function geBinding_WithOneDimensionFilter()
    {
        $column = 'dummy_column';
        $value = 4;
        $bindingCounter = 5;

        $whereToken = new WhereToken($column, $value, $bindingCounter, WhereToken::COMPARISON_HIGHER_OR_EQUAL);

        self::assertEquals(
            [':w5' => 4],
            $whereToken->getBinding()
        );
    }
}