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

Complexity

Total Complexity

9

Size/Duplication

Total Lines	191
Duplicated Lines	0 %

Importance

Changes

0

13 Methods

Rating	Name	Duplication	Size	Complexity
A	hp$0 ➔ testBuildSetQueryPartWhenEmpty()	0	5	1
A	hp$0 ➔ testBuildSetQueryPart()	0	7	1
A	hp$0 ➔ buildSetQueryPartPublic()	0	3	1
	testBuildSetQueryPartWhenEmpty()	0	5	?
	setData()	0	34	?
A	hp$0 ➔ setData()	0	3	1
	setUp()	0	33	?
A	hp$0 ➔ __construct()	0	4	1
	testBuildSetQueryPart()	0	7	?
A	hp$0 ➔ clearSetData()	0	3	1
	testSet()	0	70	?
A	hp$0 ➔ setUp()	0	33	1
B	hp$0 ➔ testSet()	0	70	1

<?php declare(strict_types=1);

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

use Janisbiz\LightOrm\Dms\MySQL\Enum\ConditionEnum;
use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\BindTrait;
use Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\SetTrait;

class SetTraitTest extends AbstractTraitTestCase
{
    const SET_DEFAULT = [
        'column1' => 'column1 = :Column1_Update',
    ];
    const SET_BIND_DEFAULT = [
        'Column1_Update' => 'value1',
    ];

    /**
     * @var BindTrait|SetTrait
     */
    private $setTraitClass;

    public function setUp()
    {
        $this->setTraitClass = new class (SetTraitTest::SET_BIND_DEFAULT, SetTraitTest::SET_DEFAULT)
        {
            use BindTrait;
            use SetTrait;

            /**
             * @param array $bindDataDefault
             * @param array $setDataDefault
             */
            public function __construct(array $bindDataDefault, array $setDataDefault)
            {
                $this->bind = $bindDataDefault;
                $this->set = $setDataDefault;
            }

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

            public function clearSetData()
            {
                $this->set = [];
            }

            public function buildSetQueryPartPublic(): ?string
            {
                return $this->buildSetQueryPart();
            }
        };
    }

    /**
     * @dataProvider setData
     *
     * @param string $column
     * @param string|int|double|null $value
     */
    public function testSet($column, $value)
    {
        $object = $this->setTraitClass->set($column, $value);

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

        $this->assertObjectUsesTrait(BindTrait::class, $object);
        $this->assertObjectUsesTrait(SetTrait::class, $object);
        $this->assertEquals(
            \array_merge(
                static::SET_DEFAULT,
                \array_reduce(
                    \array_map(
                        function ($column) {
                            return [
                                $column => \sprintf(
                                    '%s = :%s_Update',
                                    $column,
                                    \implode(
                                        '_',
                                        \array_map(
                                            function ($columnPart) {
                                                return \mb_convert_case($columnPart, MB_CASE_TITLE);
                                            },
                                            \explode('.', $column)
                                        )
                                    )
                                ),
                            ];
                        },
                        [
                            $column
                        ]
                    ),
                    'array_merge',
                    []
                )
            ),
            $this->setTraitClass->setData()

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

        );
        $this->assertEquals(
            \array_merge(
                static::SET_BIND_DEFAULT,
                \array_reduce(
                    \array_map(
                        function ($column, $value) {
                            return [
                                \sprintf(
                                    '%s_Update',
                                    \implode(
                                        '_',
                                        \array_map(
                                            function ($columnPart) {
                                                return \mb_convert_case($columnPart, MB_CASE_TITLE);
                                            },
                                            \explode('.', $column)
                                        )
                                    )
                                ) => $value,
                            ];
                        },
                        [
                            $column
                        ],
                        [
                            $value
                        ]
                    ),
                    'array_merge',
                    []
                )
            ),
            $this->setTraitClass->bindData()

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

        );
    }

    /**
     * @dataProvider setData
     *
     * @param string $column
     * @param string|int|double|null $value
     */
    public function testBuildSetQueryPart($column, $value)
    {
        $this->setTraitClass->set($column, $value);

        $this->assertEquals(
            \sprintf('%s %s', ConditionEnum::SET, \implode(', ', \array_unique($this->setTraitClass->setData()))),
            $this->setTraitClass->buildSetQueryPartPublic()

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

The method buildSetQueryPartPublic() does not exist on Janisbiz\LightOrm\Dms\MySQL\QueryBuilder\Traits\SetTrait. Did you maybe mean buildSetQueryPart()?

        );
    }

    public function testBuildSetQueryPartWhenEmpty()
    {
        $this->setTraitClass->clearSetData();

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

        $this->assertEquals(null, $this->setTraitClass->buildSetQueryPartPublic());
    }

    /**
     *
     * @return array
     */
    public function setData()
    {
        return [
            [
                'column2',
                'value2'
            ],
            [
                'column3',
                3
            ],
            [
                'column4',
                4.4
            ],
            [
                'column5',
                null
            ],
            [
                'table1.column2',
                'value2'
            ],
            [
                'table1.column3',
                3
            ],
            [
                'table1.column4',
                4.4
            ],
            [
                'table1.column5',
                null
            ],
        ];
    }
}