JoinAssemblerTest.php

Go to the documentation of this file.

<?php
namespace Magento\Analytics\Test\Unit\ReportXml\DB\Assembler;

use Magento\Framework\App\ResourceConnection;

class JoinAssemblerTest extends \PHPUnit\Framework\TestCase
{
    private $subject;

    private $nameResolverMock;

    private $selectBuilderMock;

    private $objectManagerHelper;

    private $columnsResolverMock;

    private $conditionResolverMock;

    private $resourceConnection;

    protected function setUp()
    {
        $this->nameResolverMock = $this->getMockBuilder(
            \Magento\Analytics\ReportXml\DB\NameResolver::class
        )
        ->disableOriginalConstructor()
        ->getMock();

        $this->selectBuilderMock = $this->getMockBuilder(
            \Magento\Analytics\ReportXml\DB\SelectBuilder::class
        )
        ->disableOriginalConstructor()
        ->getMock();
        $this->selectBuilderMock->expects($this->any())
            ->method('getFilters')
            ->willReturn([]);
        $this->selectBuilderMock->expects($this->any())
            ->method('getColumns')
            ->willReturn([]);
        $this->selectBuilderMock->expects($this->any())
            ->method('getJoins')
            ->willReturn([]);

        $this->columnsResolverMock = $this->getMockBuilder(
            \Magento\Analytics\ReportXml\DB\ColumnsResolver::class
        )
        ->disableOriginalConstructor()
        ->getMock();

        $this->conditionResolverMock = $this->getMockBuilder(
            \Magento\Analytics\ReportXml\DB\ConditionResolver::class
        )
        ->disableOriginalConstructor()
        ->getMock();

        $this->resourceConnection = $this->getMockBuilder(ResourceConnection::class)
            ->disableOriginalConstructor()
            ->getMock();

        $this->objectManagerHelper =
            new \Magento\Framework\TestFramework\Unit\Helper\ObjectManager($this);

        $this->subject = $this->objectManagerHelper->getObject(
            \Magento\Analytics\ReportXml\DB\Assembler\JoinAssembler::class,
            [
                'conditionResolver' => $this->conditionResolverMock,
                'nameResolver' => $this->nameResolverMock,
                'columnsResolver' => $this->columnsResolverMock,
                'resourceConnection' => $this->resourceConnection,
            ]
        );
    }

    public function testAssembleEmpty()
    {
        $queryConfigMock = [
            'source' => [
                'name' => 'sales_order',
                'alias' => 'sales'
            ]
        ];

        $this->selectBuilderMock->expects($this->never())
            ->method('setColumns');
        $this->selectBuilderMock->expects($this->never())
            ->method('setFilters');
        $this->selectBuilderMock->expects($this->never())
            ->method('setJoins');

        $this->assertEquals(
            $this->selectBuilderMock,
            $this->subject->assemble($this->selectBuilderMock, $queryConfigMock)
        );
    }

    public function testAssembleNotEmpty(array $queryConfigMock, array $joinsMock, array $tablesMapping)
    {
        $filtersMock = [];

        $this->nameResolverMock->expects($this->at(0))
            ->method('getAlias')
            ->with($queryConfigMock['source'])
            ->willReturn($queryConfigMock['source']['alias']);
        $this->nameResolverMock->expects($this->at(1))
            ->method('getAlias')
            ->with($queryConfigMock['source']['link-source'][0])
            ->willReturn($queryConfigMock['source']['link-source'][0]['alias']);
        $this->nameResolverMock->expects($this->once())
            ->method('getName')
            ->with($queryConfigMock['source']['link-source'][0])
            ->willReturn($queryConfigMock['source']['link-source'][0]['name']);

        $this->resourceConnection
            ->expects($this->any())
            ->method('getTableName')
            ->willReturnOnConsecutiveCalls(...array_values($tablesMapping));

        $this->conditionResolverMock->expects($this->at(0))
            ->method('getFilter')
            ->with(
                $this->selectBuilderMock,
                $queryConfigMock['source']['link-source'][0]['using'],
                $queryConfigMock['source']['link-source'][0]['alias'],
                $queryConfigMock['source']['alias']
            )
            ->willReturn('(billing.parent_id = `sales`.`entity_id`)');

        if (isset($queryConfigMock['source']['link-source'][0]['filter'])) {
            $filtersMock = ['(sales.entity_id IS NULL)'];

            $this->conditionResolverMock->expects($this->at(1))
                ->method('getFilter')
                ->with(
                    $this->selectBuilderMock,
                    $queryConfigMock['source']['link-source'][0]['filter'],
                    $queryConfigMock['source']['link-source'][0]['alias'],
                    $queryConfigMock['source']['alias']
                )
                ->willReturn($filtersMock[0]);

            $this->columnsResolverMock->expects($this->once())
                ->method('getColumns')
                ->with($this->selectBuilderMock, $queryConfigMock['source']['link-source'][0])
                ->willReturn(
                    [
                        'entity_id' => 'sales.entity_id',
                        'billing_address_id' => 'billing.entity_id'
                    ]
                );

            $this->selectBuilderMock->expects($this->once())
                ->method('setColumns')
                ->with(
                    [
                        'entity_id' => 'sales.entity_id',
                        'billing_address_id' => 'billing.entity_id'
                    ]
                );
        }

        $this->selectBuilderMock->expects($this->once())
            ->method('setFilters')
            ->with($filtersMock);
        $this->selectBuilderMock->expects($this->once())
            ->method('setJoins')
            ->with($joinsMock);

        $this->assertEquals(
            $this->selectBuilderMock,
            $this->subject->assemble($this->selectBuilderMock, $queryConfigMock)
        );
    }

    public function assembleNotEmptyDataProvider()
    {
        return [
            [
                [
                    'source' => [
                        'name' => 'sales_order',
                        'alias' => 'sales',
                        'link-source' => [
                            [
                                'name' => 'sales_order_address',
                                'alias' => 'billing',
                                'link-type' => 'left',
                                'attribute' => [
                                    [
                                        'alias' => 'billing_address_id',
                                        'name' => 'entity_id'
                                    ]
                                ],
                                'using' => [
                                    [
                                        'glue' => 'and',
                                        'condition' => [
                                            [
                                                'attribute' => 'parent_id',
                                                'operator' => 'eq',
                                                'type' => 'identifier',
                                                '_value' => 'entity_id'
                                            ]
                                        ]
                                    ]
                                ],
                                'filter' => [
                                    [
                                        'glue' => 'and',
                                        'condition' => [
                                            [
                                                'attribute' => 'entity_id',
                                                'operator' => 'null'
                                            ]
                                        ]
                                    ]
                                ]
                            ]
                        ]
                    ]
                ],
                [
                    'billing' => [
                        'link-type' => 'left',
                        'table' => [
                            'billing' => 'pref_sales_order_address'
                        ],
                        'condition' => '(billing.parent_id = `sales`.`entity_id`)'
                    ]
                ],
                ['sales_order_address' => 'pref_sales_order_address']
            ]
        ];
    }
}