QB\MySQL\Clause\CombiningQueryTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	59
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	testConstructValidation()	0	5	1
A	testToString()	0	6	1
A	constructValidationProvider()	0	5	1
A	toStringProvider()	0	6	1
A	setUp()	0	3	1

<?php

declare(strict_types=1);

namespace QB\MySQL\Clause;

use InvalidArgumentException;
use PHPUnit\Framework\TestCase;
use QB\Generic\IQueryPart;
use QB\MySQL\Statement\Select;

class CombiningQueryTest extends TestCase
{
    protected IQueryPart $queryPart;

    public function setUp(): void
    {
        $this->queryPart = (new Select())->columns('2');
    }

    /**
     * @return array[]
     */
    public function toStringProvider(): array
    {
        return [
            [CombiningQuery::TYPE_UNION, null, "UNION\nSELECT 2"],
            [CombiningQuery::TYPE_UNION, CombiningQuery::MODIFIER_DISTINCT, "UNION DISTINCT\nSELECT 2"],
            [CombiningQuery::TYPE_UNION, CombiningQuery::MODIFIER_ALL, "UNION ALL\nSELECT 2"],
        ];
    }

    /**
     * @dataProvider toStringProvider
     *
     * @param string      $type
     * @param string|null $modifier
     * @param string      $expectedSql
     */
    public function testToString(string $type, ?string $modifier, string $expectedSql)
    {
        $lock = new CombiningQuery($type, $this->queryPart, $modifier);
        $sql  = (string)$lock;

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

    /**
     * @return array[]
     */
    public function constructValidationProvider(): array
    {
        return [
            'invalid type'     => ['foo', null],
            'invalid modifier' => [CombiningQuery::TYPE_UNION, 'foo'],
        ];
    }

    /**
     * @dataProvider constructValidationProvider
     * @suppress     PhanNoopNew
     *
     * @param string      $type
     * @param string|null $modifier
     */
    public function testConstructValidation(string $type, ?string $modifier)
    {
        $this->expectException(InvalidArgumentException::class);

        new CombiningQuery($type, $this->queryPart, $modifier);
    }
}