RealTest.php

Go to the documentation of this file.

<?php
namespace Magento\Framework\Setup\Test\Unit\Declaration\Schema\Db\MySQL\Definition\Columns;

use Magento\Framework\App\ResourceConnection;
use Magento\Framework\TestFramework\Unit\Helper\ObjectManager;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Boolean;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Comment;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Identity;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Integer;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Nullable;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Real;
use Magento\Framework\Setup\Declaration\Schema\Db\MySQL\Definition\Columns\Unsigned;
use Magento\Framework\Setup\Declaration\Schema\Dto\Columns\Real as RealColumnDto;

class RealTest extends \PHPUnit\Framework\TestCase
{
    private $objectManager;

    private $real;

    private $nullableMock;

    private $commentMock;

    private $resourceConnectionMock;

    private $unsignedMock;

    protected function setUp()
    {
        $this->objectManager = new ObjectManager($this);
        $this->nullableMock = $this->getMockBuilder(Nullable::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->commentMock = $this->getMockBuilder(Comment::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->resourceConnectionMock = $this->getMockBuilder(ResourceConnection::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->unsignedMock = $this->getMockBuilder(Unsigned::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->real = $this->objectManager->getObject(
            Real::class,
            [
                'nullable' => $this->nullableMock,
                'unsigned' => $this->unsignedMock,
                'resourceConnection' => $this->resourceConnectionMock,
                'comment' => $this->commentMock,
            ]
        );
    }

    public function testToDefinitionNoScale()
    {
        $column = $this->getMockBuilder(RealColumnDto::class)
            ->disableOriginalConstructor()
            ->getMock();
        $column->expects($this->any())
            ->method('getName')
            ->willReturn('col');
        $column->expects($this->any())
            ->method('getType')
            ->willReturn('float');
        $column->expects($this->any())
            ->method('getPrecision')
            ->willReturn(0);
        $column->expects($this->any())
            ->method('getScale')
            ->willReturn(0);
        $column->expects($this->any())
            ->method('getDefault')
            ->willReturn(0);
        $this->unsignedMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('UNSIGNED');
        $this->nullableMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('NOT NULL');
        $adapterMock = $this->getMockBuilder(\Magento\Framework\DB\Adapter\AdapterInterface::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->resourceConnectionMock->expects($this->once())->method('getConnection')->willReturn($adapterMock);
        $adapterMock->expects($this->once())
            ->method('quoteIdentifier')
            ->with('col')
            ->willReturn('`col`');
        $this->commentMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('COMMENT "Comment"');
        $this->assertEquals(
            '`col` float UNSIGNED NOT NULL DEFAULT 0 COMMENT "Comment"',
            $this->real->toDefinition($column)
        );
    }

    public function testToDefinition()
    {
        $column = $this->getMockBuilder(RealColumnDto::class)
            ->disableOriginalConstructor()
            ->getMock();
        $column->expects($this->any())
            ->method('getName')
            ->willReturn('col');
        $column->expects($this->any())
            ->method('getType')
            ->willReturn('float');
        $column->expects($this->any())
            ->method('getPrecision')
            ->willReturn(10);
        $column->expects($this->any())
            ->method('getScale')
            ->willReturn(4);
        $column->expects($this->any())
            ->method('getDefault')
            ->willReturn(0);
        $this->unsignedMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('UNSIGNED');
        $this->nullableMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('NOT NULL');
        $adapterMock = $this->getMockBuilder(\Magento\Framework\DB\Adapter\AdapterInterface::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->resourceConnectionMock->expects($this->once())->method('getConnection')->willReturn($adapterMock);
        $adapterMock->expects($this->once())
            ->method('quoteIdentifier')
            ->with('col')
            ->willReturn('`col`');
        $this->commentMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('COMMENT "Comment"');
        $this->assertEquals(
            '`col` float(10, 4) UNSIGNED NOT NULL DEFAULT 0 COMMENT "Comment"',
            $this->real->toDefinition($column)
        );
    }

    public function testToDefinitionNoDefault()
    {
        $column = $this->getMockBuilder(RealColumnDto::class)
            ->disableOriginalConstructor()
            ->getMock();
        $column->expects($this->any())
            ->method('getName')
            ->willReturn('col');
        $column->expects($this->any())
            ->method('getType')
            ->willReturn('float');
        $column->expects($this->any())
            ->method('getPrecision')
            ->willReturn(10);
        $column->expects($this->any())
            ->method('getScale')
            ->willReturn(4);
        $column->expects($this->any())
            ->method('getDefault')
            ->willReturn(null);
        $this->unsignedMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('UNSIGNED');
        $this->nullableMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('NOT NULL');
        $adapterMock = $this->getMockBuilder(\Magento\Framework\DB\Adapter\AdapterInterface::class)
            ->disableOriginalConstructor()
            ->getMock();
        $this->resourceConnectionMock->expects($this->once())->method('getConnection')->willReturn($adapterMock);
        $adapterMock->expects($this->once())
            ->method('quoteIdentifier')
            ->with('col')
            ->willReturn('`col`');
        $this->commentMock->expects($this->any())
            ->method('toDefinition')
            ->with($column)
            ->willReturn('COMMENT "Comment"');
        $this->assertEquals(
            '`col` float(10, 4) UNSIGNED NOT NULL  COMMENT "Comment"',
            $this->real->toDefinition($column)
        );
    }

    public function testFromDefinition($definition, $expectedPrecision = false, $expectedScale = false)
    {
        $expectedData = [
            'definition' => $definition,
        ];
        if ($expectedPrecision) {
            $expectedData['precision'] = $expectedPrecision;
            $expectedData['scale'] = $expectedScale;
        }
        $this->unsignedMock->expects($this->any())->method('fromDefinition')->willReturnArgument(0);
        $this->nullableMock->expects($this->any())->method('fromDefinition')->willReturnArgument(0);
        $result = $this->real->fromDefinition(['definition' => $definition]);
        $this->assertEquals($expectedData, $result);
    }

    public function definitionDataProvider()
    {
        return [
            ['float'],
            ['float(10,4)', 10, 4],
            ['float(10)', false, false],
            ['decimal(10)', 10, 0],
            ['decimal(10, 6)', 10, 6],
            ['double(10, 6)', 10, 6],
            ['double', false, false],
            ['double(10)', false, false],
        ];
    }
}