Janisbiz\LightOrm\Tests\Unit\Dms\MySQL\QueryBuilder\Traits\UnionTraitTest

Complexity

Total Complexity

10

Size/Duplication

Total Lines	125
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

13 Methods

Rating	Name	Duplication	Size	Complexity
A	hp$0 ➔ unionAllData()	0	3	1
A	hp$0 ➔ testUnionAll()	0	26	2
A	hp$0 ➔ buildUnionAllQueryPartPublic()	0	3	1
	setUp()	0	30	?
	testUnionAllWhenInvalidQueryBuilderPassed()	0	6	?
	testBuildUnionAllQueryPart()	0	25	?
A	hp$0 ➔ testBuildUnionAllQueryPart()	0	25	2
A	hp$0 ➔ testBuildUnionAllQueryPartWhenEmpty()	0	5	1
A	hp$0 ➔ testUnionAllWhenInvalidQueryBuilderPassed()	0	6	1
A	hp$0 ➔ clearUnionAllData()	0	3	1
	testBuildUnionAllQueryPartWhenEmpty()	0	5	?
A	hp$0 ➔ setUp()	0	30	1
	testUnionAll()	0	26	?

<?php declare(strict_types=1);

namespace Janisbiz\LightOrm\Tests\Unit\Dms\MySQL\QueryBuilder\Traits;

use Janisbiz\LightOrm\Dms\MySQL\Enum\CommandEnum;
use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\QueryBuilderException;
use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\QueryBuilderInterface;
use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\BindTrait;
use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\UnionTrait;

class UnionTraitTest extends AbstractTraitTestCase
{
    const COMMAND_INVALID = 'INVALID';

    const QUERY_BUILDER_COMMAND = CommandEnum::SELECT;
    const QUERY_BUILDER_QUERY = <<<MySQL
SELECT col1, col2, col3 FROM table1 WHERE table1.col1 = :col1 AND table1.col2 IS NOT NULL
MySQL;
    const QUERY_BUILDER_BIND_DATA = [
        'col1' => 'val1',
    ];

    /**
     * @var QueryBuilderInterface|\PHPUnit_Framework_MockObject_MockObject
     */
    private $queryBuilder;

    /**
     * @var BindTrait|UnionTrait
     */
    private $unionTraitClass;

    public function setUp()
    {
        $this->queryBuilder = $this->createMock(QueryBuilderInterface::class);
        $this->queryBuilder->method('bindData')->willReturn(static::QUERY_BUILDER_BIND_DATA);

The method method() does not exist on PHPUnit\Framework\MockObject\MockObject.

        $this->queryBuilder->method('buildQuery')->willReturn(static::QUERY_BUILDER_QUERY);

        $this->unionTraitClass = new class ()
        {
            use BindTrait;
            use UnionTrait;

            /**
             * @return array
             */
            public function unionAllData(): array
            {
                return $this->unionAll;
            }

            public function clearUnionAllData()
            {
                $this->unionAll = [];
            }

            /**
             * @return null|string
             */
            public function buildUnionAllQueryPartPublic(): ?string
            {
                return $this->buildUnionAllQueryPart();
            }
        };
    }

    public function testUnionAll()
    {
        $this->queryBuilder->method('commandData')->willReturn(static::QUERY_BUILDER_COMMAND);

The method method() does not exist on Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\QueryBuilderInterface.

        $unionAllQueries = [
            $this->queryBuilder,
            $this->queryBuilder,
            $this->queryBuilder,
        ];

        foreach ($unionAllQueries as $unionAllQuery) {
            $this->unionTraitClass->unionAll($unionAllQuery);

It seems like unionAll() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        }

        $this->assertCount(\count($unionAllQueries), $this->unionTraitClass->unionAllData());

The method unionAllData() does not exist on Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\UnionTrait. Did you maybe mean unionAll()?

It seems like unionAllData() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $this->assertEquals(
            \array_map(
                function (QueryBuilderInterface $unionAllQuery) {
                    return \sprintf('(%s)', $unionAllQuery->buildQuery());
                },
                $unionAllQueries
            ),
            $this->unionTraitClass->unionAllData()
        );
        $this->assertCount(\count(self::QUERY_BUILDER_BIND_DATA), $this->unionTraitClass->bindData());

It seems like bindData() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $this->assertEquals(self::QUERY_BUILDER_BIND_DATA, $this->unionTraitClass->bindData());
    }

    public function testUnionAllWhenInvalidQueryBuilderPassed()
    {
        $this->expectException(QueryBuilderException::class);
        $this->expectExceptionMessage('$queryBuilder should be with valid command! Valid command: "SELECT"');

        $this->unionTraitClass->unionAll($this->queryBuilder);
    }

    public function testBuildUnionAllQueryPart()
    {
        $this->queryBuilder->method('commandData')->willReturn(static::QUERY_BUILDER_COMMAND);

        $unionAllQueries = [
            $this->queryBuilder,
            $this->queryBuilder,
            $this->queryBuilder,
        ];

        foreach ($unionAllQueries as $unionAllQuery) {
            $this->unionTraitClass->unionAll($unionAllQuery);
        }

        $this->assertEquals(
            \implode(
                ' UNION ALL ',
                \array_map(
                    function (QueryBuilderInterface $unionAllQuery) {
                        return \sprintf('(%s)', $unionAllQuery->buildQuery());
                    },
                    $unionAllQueries
                )
            ),
            $this->unionTraitClass->buildUnionAllQueryPartPublic()

It seems like buildUnionAllQueryPartPublic() must be provided by classes using this trait. How about adding it as abstract method to this trait?

The method buildUnionAllQueryPartPublic() does not exist on Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\UnionTrait. Did you maybe mean buildUnionAllQueryPart()?

        );
    }

    public function testBuildUnionAllQueryPartWhenEmpty()
    {
        $this->unionTraitClass->clearUnionAllData();

It seems like clearUnionAllData() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        $this->assertEquals(null, $this->unionTraitClass->buildUnionAllQueryPartPublic());
    }
}