QB\PostgreSQL\Clause\CombiningQueryTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	63
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

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

<?php

declare(strict_types=1);

namespace QB\PostgreSQL\Clause;

use PHPUnit\Framework\TestCase;
use QB\Generic\IQueryPart;
use QB\PostgreSQL\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_ALL, "UNION ALL\nSELECT 2"],
            [CombiningQuery::TYPE_EXCEPT, null, "EXCEPT\nSELECT 2"],
            [CombiningQuery::TYPE_EXCEPT, CombiningQuery::MODIFIER_ALL, "EXCEPT ALL\nSELECT 2"],
            [CombiningQuery::TYPE_INTERSECT, null, "INTERSECT\nSELECT 2"],
            [CombiningQuery::TYPE_INTERSECT, CombiningQuery::MODIFIER_ALL, "INTERSECT 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'],
            'invalid mysql modifier' => [CombiningQuery::TYPE_UNION, CombiningQuery::MODIFIER_DISTINCT],
        ];
    }

    /**
     * @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);
    }
}