Yiisoft\Db\Tests\QueryBuilder\Conditions\SimpleConditionTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	51
Duplicated Lines	0 %

Importance

Changes	2
Bugs	1	Features	1

6 Methods

Rating	Name	Duplication	Size	Complexity
A	testFromArrayDefinitionColumnException()	0	5	1
A	testFromArrayDefinition()	0	7	1
A	testFromArrayDefinitionValueException()	0	5	1
A	testFromArrayDefinitionExceptionColumn()	0	7	1
A	testConstructor()	0	7	1
A	testNullSecondOperand()	0	8	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\SimpleCondition;

/**
 * @group db
 */
final class SimpleConditionTest extends TestCase
{
    public function testConstructor(): void
    {
        $simpleCondition = new SimpleCondition('id', '=', 1);

        $this->assertSame('id', $simpleCondition->getColumn());
        $this->assertSame('=', $simpleCondition->getOperator());
        $this->assertSame(1, $simpleCondition->getValue());
    }

    public function testFromArrayDefinition(): void
    {
        $simpleCondition = SimpleCondition::fromArrayDefinition('=', ['id', 1]);

        $this->assertSame('id', $simpleCondition->getColumn());
        $this->assertSame('=', $simpleCondition->getOperator());
        $this->assertSame(1, $simpleCondition->getValue());
    }

    public function testFromArrayDefinitionColumnException(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage("Operator '=' requires two operands.");
        SimpleCondition::fromArrayDefinition('=', []);
    }

    public function testFromArrayDefinitionValueException(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage("Operator 'IN' requires two operands.");
        SimpleCondition::fromArrayDefinition('IN', ['column']);
    }

    public function testFromArrayDefinitionExceptionColumn(): void
    {
        $this->expectException(InvalidArgumentException::class);
        $this->expectExceptionMessage(
            "Operator '=' requires column to be string, ExpressionInterface or QueryInterface."
        );
        SimpleCondition::fromArrayDefinition('=', [1, 1]);
    }

    public function testNullSecondOperand(): void
    {
        $condition = SimpleCondition::fromArrayDefinition('=', ['id', null]);
        $this->assertNull($condition->getValue());

        $condition2 = new SimpleCondition('name', 'IS NOT', null);
        $this->assertSame('IS NOT', $condition2->getOperator());
        $this->assertNull($condition2->getValue());
    }
}