app/bundles/LeadBundle/Tests/Field/SchemaDefinitionTest.php

<?php

declare(strict_types=1);

namespace Mautic\LeadBundle\Tests\Field;

use Mautic\CoreBundle\Doctrine\Mapping\ClassMetadataBuilder;
use Mautic\LeadBundle\Field\SchemaDefinition;
use PHPUnit\Framework\Assert;
use PHPUnit\Framework\TestCase;

class SchemaDefinitionTest extends TestCase
{
    /**
     * @dataProvider dataGetSchemaDefinition
     *
     * @param mixed[] $expected
     */
    public function testGetSchemaDefinition(string $alias, string $type, bool $isUnique, ?int $length, array $expected): void
    {
        Assert::assertSame($expected, SchemaDefinition::getSchemaDefinition($alias, $type, $isUnique, $length));
        Assert::assertSame($expected, (new SchemaDefinition())->getSchemaDefinitionNonStatic($alias, $type, $isUnique, $length));
    }

    /**
     * @return mixed[]
     */
    public function dataGetSchemaDefinition(): iterable
    {
        foreach (['datetime', 'date', 'time', 'boolean'] as $type) {
            yield [
                'some',
                $type,
                false,
                80,
                [
                    'name'    => 'some',
                    'type'    => $type,
                    'options' => ['notnull' => false],
                ],
            ];
        }

        yield [
            'some',
            'number',
            false,
            70,
            [
                'name'    => 'some',
                'type'    => 'float',
                'options' => [
                    'notnull' => false,
                ],
            ],
        ];

        foreach (['timezone', 'locale', 'country', 'email', 'lookup', 'select', 'region', 'tel', 'text'] as $type) {
            foreach ([75, null] as $length) {
                $maxLength = ('text' == $type || !is_null($length)) ? $length : SchemaDefinition::MAX_VARCHAR_LENGTH;
                yield [
                    'some',
                    $type,
                    false,
                    $maxLength,
                    [
                        'name'    => 'some',
                        'type'    => 'string',
                        'options' => [
                            'notnull' => false,
                            'length'  => $maxLength ?? 191,
                        ],
                    ],
                ];
            }
        }

        foreach (['description' => 'text', 'descriptionOfArticle' => 'text'] as $alias => $type) {
            yield [
                $alias,
                'text',
                false,
                null,
                [
                    'name'    => $alias,
                    'type'    => $type,
                    'options' => [
                        'notnull' => false,
                        'length'  => null,
                    ],
                ],
            ];
        }

        yield [
            'articleDescription',
            'text',
            false,
            null,
            [
                'name'    => 'articleDescription',
                'type'    => 'string',
                'options' => [
                    'notnull' => false,
                    'length'  => 191,
                ],
            ],
        ];

        yield [
            'some',
            'multiselect',
            false,
            80,
            [
                'name'    => 'some',
                'type'    => 'text',
                'options' => ['notnull' => false, 'length' => 65535],
            ],
        ];

        foreach (['html', 'unknown'] as $type) {
            yield [
                'some',
                $type,
                false,
                80,
                [
                    'name'    => 'some',
                    'type'    => 'text',
                    'options' => ['notnull' => false],
                ],
            ];
        }

        $allTypes = [
            'datetime',
            'date',
            'time',
            'boolean',
            'number',
            'timezone',
            'locale',
            'country',
            'email',
            'lookup',
            'select',
            'region',
            'tel',
            'text',
            'multiselect',
            'html',
            'unknown',
        ];

        foreach ($allTypes as $type) {
            yield [
                'some',
                $type,
                true,
                80,
                [
                    'name'    => 'some',
                    'type'    => 'string',
                    'options' => ['notnull' => false],
                ],
            ];
        }
    }

    /**
     * @dataProvider dataGetFieldCharLengthLimit
     *
     * @param mixed[] $schemaDefinition
     */
    public function testGetFieldCharLengthLimit(array $schemaDefinition, ?int $expected): void
    {
        Assert::assertSame($expected, SchemaDefinition::getFieldCharLengthLimit($schemaDefinition));
    }

    /**
     * @return mixed[]
     */
    public function dataGetFieldCharLengthLimit(): iterable
    {
        yield [
            [
                'type'    => 'string',
                'options' => [
                    'length' => 50,
                ],
            ],
            50,
        ];

        yield [
            [
                'type'    => 'string',
            ],
            ClassMetadataBuilder::MAX_VARCHAR_INDEXED_LENGTH,
        ];

        yield [
            [
                'type'    => 'text',
                'options' => [
                    'length' => 60,
                ],
            ],
            60,
        ];

        foreach (['text', 'datetime', 'date', 'time', 'boolean', 'float'] as $type) {
            yield [
                [
                    'type'    => $type,
                ],
                null,
            ];
        }
    }
}