QB\Generic\Clause\ColumnTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	61
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	testGetParamsReturnsEmptyArrayIfColumnNameIsProvided()	0	9	1
A	testToStringWithoutAliasAndParams()	0	9	1
A	testToStringWithoutParams()	0	11	1
A	testToStringWithoutAlias()	0	11	1
A	testGetParamsReturnsExpressionParams()	0	11	1

<?php

declare(strict_types=1);

namespace QB\Generic\Clause;

use PDO;
use PHPUnit\Framework\TestCase;
use QB\Generic\Expr\Expr;

class ColumnTest extends TestCase
{
    public function testToStringWithoutAliasAndParams()
    {
        $colName = 'col';

        $sut = new Column($colName);

        $actualSql = (string)$sut;

        $this->assertSame($colName, $actualSql);
    }

    public function testToStringWithoutParams()
    {
        $expr   = new Expr('COUNT(col)');
        $column = 'col_count';

        $sut = new Column($expr, $column);

        $expectedSql  = 'COUNT(col) AS col_count';
        $actualResult = (string)$sut;

        $this->assertSame($expectedSql, $actualResult);
    }

    public function testToStringWithoutAlias()
    {
        $expectedSql = 'COUNT(col)';

        $expr = new Expr($expectedSql);

        $sut = new Column($expr);

        $actualResult = (string)$sut;

        $this->assertSame($expectedSql, $actualResult);
    }

    public function testGetParamsReturnsEmptyArrayIfColumnNameIsProvided()
    {
        $expectedSql = 'foo';

        $sut = new Column($expectedSql);

        $actualParams = $sut->getParams();

        $this->assertSame([], $actualParams);
    }

    public function testGetParamsReturnsExpressionParams()
    {
        $expr   = new Expr('LENGTH(:word) > 5', [':word' => 'foobar']);
        $column = 'is_word_long';

        $sut = new Column($expr, $column);

        $expectedParams = [':word' => ['foobar', PDO::PARAM_STR]];
        $actualParams   = $sut->getParams();

        $this->assertSame($expectedParams, $actualParams);
    }
}