Yiisoft\Db\Tests\QueryBuilder\Conditions\BetweenColumnsConditionTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	1

6 Methods

Rating	Name	Duplication	Size	Complexity
A	testFromArrayDefinitionExceptionWithoutOperands()	0	5	1
A	testFromArrayDefinition()	0	11	1
A	testFromArrayDefinitionExceptionOperandsIntervalStartColumn()	0	7	1
A	testFromArrayDefinitionExceptionOperandsValue()	0	7	1
A	testConstructor()	0	8	1
A	testFromArrayDefinitionExceptionOperandsIntervalEndColumn()	0	7	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Tests\QueryBuilder\Condition;

use PHPUnit\Framework\TestCase;
use Yiisoft\Db\Exception\InvalidArgumentException;
use Yiisoft\Db\QueryBuilder\Conditions\BetweenColumnsCondition;

/**
 * @group db
 */
final class BetweenColumnsConditionTest extends TestCase
{
    public function testConstructor(): void
    {
        $betweenColumnsCondition = new BetweenColumnsCondition(42, 'BETWEEN', 'min_value', 'max_value');

        $this->assertSame(42, $betweenColumnsCondition->getValue());
        $this->assertSame('BETWEEN', $betweenColumnsCondition->getOperator());
        $this->assertSame('min_value', $betweenColumnsCondition->getIntervalStartColumn());
        $this->assertSame('max_value', $betweenColumnsCondition->getIntervalEndColumn());
    }

    public function testFromArrayDefinition(): void
    {
        $betweenColumnsCondition = BetweenColumnsCondition::fromArrayDefinition(
            'BETWEEN',
            [42, 'min_value', 'max_value']
        );

        $this->assertSame(42, $betweenColumnsCondition->getValue());
        $this->assertSame('BETWEEN', $betweenColumnsCondition->getOperator());
        $this->assertSame('min_value', $betweenColumnsCondition->getIntervalStartColumn());
        $this->assertSame('max_value', $betweenColumnsCondition->getIntervalEndColumn());
    }

    public function testFromArrayDefinitionExceptionWithoutOperands(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage("Operator 'between' requires three operands.");
        BetweenColumnsCondition::fromArrayDefinition('between', []);
    }

    public function testFromArrayDefinitionExceptionOperandsValue(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage(
            "Operator 'between' requires value to be array, int, string, Iterator or ExpressionInterface."
        );
        BetweenColumnsCondition::fromArrayDefinition('between', [false, 'min_value', 'max_value']);
    }

    public function testFromArrayDefinitionExceptionOperandsIntervalStartColumn(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage(
            "Operator 'between' requires interval start column to be string or ExpressionInterface."
        );
        BetweenColumnsCondition::fromArrayDefinition('between', [42, false, 'max_value']);
    }

    public function testFromArrayDefinitionExceptionOperandsIntervalEndColumn(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage(
            "Operator 'between' requires interval end column to be string or ExpressionInterface."
        );
        BetweenColumnsCondition::fromArrayDefinition('between', [42, 'min_value', false]);
    }
}