Horat1us\Yii\Tests\Helpers\QueryHelperTest

Complexity

Total Complexity

3

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	testCoalesce()	0	6	1
A	testCustomSqlFunction()	0	6	1
A	testSingleParam()	0	8	1

<?php

namespace Horat1us\Yii\Tests\Helpers;

use Horat1us\Yii\Helpers\QueryHelper;
use PHPUnit\Framework\TestCase;
use yii\db\Expression;

class QueryHelperTest extends TestCase
{
    public function testCoalesce()
    {
        $expression = QueryHelper::coalesce('a', 'b');

        $this->assertEquals('COALESCE((a), (b))', $expression);
    }

    public function testCustomSqlFunction()
    {
        $expression = QueryHelper::sqlCall('MIN', 1, 2, new Expression('3'));

        $this->assertEquals('MIN((1), (2), (3))', $expression);
    }

    public function testSingleParam()
    {
        $command = 'SELECT CURRENT_DATE';
        $function = 'EXISTS';
        $expression = QueryHelper::sqlCall($function, $command);

        $this->assertEquals("{$function}(({$command}))", $expression);
    }
}