cakephp/tests/TestCase/ORM/ColumnSchemaAwareTypeIntegrationTest.php

<?php
declare(strict_types=1);

namespace Cake\Test\TestCase\ORM;

use Cake\Database\DriverInterface;
use Cake\Database\TypeFactory;
use Cake\TestSuite\TestCase;
use TestApp\Database\Type\ColumnSchemaAwareType;

class ColumnSchemaAwareTypeIntegrationTest extends TestCase
{
    protected array $fixtures = [
        //'core.ColumnSchemaAwareTypeValues',
    ];

    /**
     * @var \Cake\Database\TypeInterface|null
     */
    public $textType;

    public function setUp(): void
    {
        parent::setUp();

        $this->textType = TypeFactory::build('text');
        TypeFactory::map('text', ColumnSchemaAwareType::class);
        // For SQLServer.
        TypeFactory::map('nvarchar', ColumnSchemaAwareType::class);

        $this->markTestSkipped('This test requires non-auto-fixtures');
    }

    public function tearDown(): void
    {
        parent::tearDown();
        TypeFactory::set('text', $this->textType);

        $map = TypeFactory::getMap();
        unset($map['nvarchar']);
        TypeFactory::setMap($map);
    }

    public function testCustomTypesCanBeUsedInFixtures(): void
    {
        $table = $this->getTableLocator()->get('ColumnSchemaAwareTypeValues');

        $expected = [
            'this text has been processed via a custom type',
            'this text also has been processed via a custom type',
        ];
        $result = $table->find()->orderAsc('id')->all()->extract('val')->toArray();
        $this->assertSame($expected, $result);
    }

    public function testCustomTypeCanProcessColumnInfo(): void
    {
        $column = $this->getTableLocator()->get('ColumnSchemaAwareTypeValues')->getSchema()->getColumn('val');

        $this->assertSame('text', $column['type']);
        $this->assertSame(255, $column['length']);
        $this->assertSame('Custom schema aware type comment', $column['comment']);
    }

    public function testCustomTypeReceivesAllColumnDefinitionKeys(): void
    {
        $table = $this->getTableLocator()->get('ColumnSchemaAwareTypeValues');

        $type = $this
            ->getMockBuilder(ColumnSchemaAwareType::class)
            ->setConstructorArgs(['char'])
            ->onlyMethods(['convertColumnDefinition'])
            ->getMock();

        $type
            ->expects($this->once())
            ->method('convertColumnDefinition')
            ->willReturnCallback(function (array $definition, DriverInterface $driver) {
                $this->assertEquals(
                    [
                        'length',
                        'precision',
                        'scale',
                    ],
                    array_keys($definition)
                );

                return null;
            });

        TypeFactory::set('text', $type);
        TypeFactory::set('nvarchar', $type);

        $table->getSchema()->getColumn('val');
    }
}