phpmyadmin/tests/unit/Plugins/Transformations/TransformationPluginsTest.php

<?php

declare(strict_types=1);

namespace PhpMyAdmin\Tests\Plugins\Transformations;

use Closure;
use PhpMyAdmin\FieldMetadata;
use PhpMyAdmin\Plugins\IOTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\DateFormatTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\DownloadTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\ExternalTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\FormattedTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\HexTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\ImageLinkTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\ImageUploadTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\InlineTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\LongToIPv4TransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\PreApPendTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\RegexValidationTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\SQLTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\SubstringTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\TextFileUploadTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\TextImageLinkTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Abs\TextLinkTransformationsPlugin;
use PhpMyAdmin\Plugins\Transformations\Input\Image_JPEG_Upload;
use PhpMyAdmin\Plugins\Transformations\Input\Text_Plain_FileUpload;
use PhpMyAdmin\Plugins\Transformations\Input\Text_Plain_Iptolong;
use PhpMyAdmin\Plugins\Transformations\Input\Text_Plain_RegexValidation;
use PhpMyAdmin\Plugins\Transformations\Output\Application_Octetstream_Download;
use PhpMyAdmin\Plugins\Transformations\Output\Application_Octetstream_Hex;
use PhpMyAdmin\Plugins\Transformations\Output\Image_JPEG_Inline;
use PhpMyAdmin\Plugins\Transformations\Output\Image_JPEG_Link;
use PhpMyAdmin\Plugins\Transformations\Output\Image_PNG_Inline;
use PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Dateformat;
use PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_External;
use PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Formatted;
use PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Imagelink;
use PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Sql;
use PhpMyAdmin\Plugins\Transformations\Text_Plain_Link;
use PhpMyAdmin\Plugins\Transformations\Text_Plain_Longtoipv4;
use PhpMyAdmin\Plugins\Transformations\Text_Plain_PreApPend;
use PhpMyAdmin\Plugins\Transformations\Text_Plain_Substring;
use PhpMyAdmin\Plugins\TransformationsPlugin;
use PhpMyAdmin\Tests\AbstractTestCase;
use PhpMyAdmin\Tests\FieldHelper;
use PHPUnit\Framework\Attributes\CoversClass;
use PHPUnit\Framework\Attributes\DataProvider;
use PHPUnit\Framework\Attributes\Medium;

use function date_default_timezone_set;
use function function_exists;

use const MYSQLI_TYPE_STRING;
use const MYSQLI_TYPE_TINY;

/**
 * Tests for different input/output transformation plugins
 */
#[CoversClass(TransformationsPlugin::class)]
#[CoversClass(IOTransformationsPlugin::class)]
#[CoversClass(DateFormatTransformationsPlugin::class)]
#[CoversClass(DownloadTransformationsPlugin::class)]
#[CoversClass(ExternalTransformationsPlugin::class)]
#[CoversClass(FormattedTransformationsPlugin::class)]
#[CoversClass(HexTransformationsPlugin::class)]
#[CoversClass(ImageLinkTransformationsPlugin::class)]
#[CoversClass(ImageUploadTransformationsPlugin::class)]
#[CoversClass(InlineTransformationsPlugin::class)]
#[CoversClass(LongToIPv4TransformationsPlugin::class)]
#[CoversClass(PreApPendTransformationsPlugin::class)]
#[CoversClass(RegexValidationTransformationsPlugin::class)]
#[CoversClass(SQLTransformationsPlugin::class)]
#[CoversClass(SubstringTransformationsPlugin::class)]
#[CoversClass(TextFileUploadTransformationsPlugin::class)]
#[CoversClass(TextImageLinkTransformationsPlugin::class)]
#[CoversClass(TextLinkTransformationsPlugin::class)]
#[CoversClass(Image_JPEG_Upload::class)]
#[CoversClass(Text_Plain_FileUpload::class)]
#[CoversClass(Text_Plain_Iptolong::class)]
#[CoversClass(Text_Plain_RegexValidation::class)]
#[CoversClass(Application_Octetstream_Download::class)]
#[CoversClass(Application_Octetstream_Hex::class)]
#[CoversClass(Image_JPEG_Inline::class)]
#[CoversClass(Image_JPEG_Link::class)]
#[CoversClass(Image_PNG_Inline::class)]
#[CoversClass(Text_Plain_Dateformat::class)]
#[CoversClass(Text_Plain_External::class)]
#[CoversClass(Text_Plain_Formatted::class)]
#[CoversClass(Text_Plain_Imagelink::class)]
#[CoversClass(Text_Plain_Sql::class)]
#[CoversClass(Text_Plain_Link::class)]
#[CoversClass(Text_Plain_Longtoipv4::class)]
#[CoversClass(Text_Plain_PreApPend::class)]
#[CoversClass(Text_Plain_Substring::class)]
#[Medium]
class TransformationPluginsTest extends AbstractTestCase
{
    /**
     * Sets up the fixture, for example, opens a network connection.
     * This method is called before a test is executed.
     */
    protected function setUp(): void
    {
        parent::setUp();

        // For Date Format plugin
        date_default_timezone_set('UTC');
    }

    /** @return iterable<array-key, array{0: Closure, 1: mixed, 2?: mixed[]}> */
    public static function multiDataProvider(): iterable
    {
        // Test data for PhpMyAdmin\Plugins\Transformations\Input\Image_JPEG_Upload plugin
        yield [Image_JPEG_Upload::getName(...), 'Image upload'];
        yield [
            Image_JPEG_Upload::getInfo(...),
            'Image upload functionality which also displays a thumbnail.'
            . ' The options are the width and height of the thumbnail'
            . ' in pixels. Defaults to 100 X 100.',
        ];

        yield [Image_JPEG_Upload::getMIMEType(...), 'Image'];
        yield [Image_JPEG_Upload::getMIMESubtype(...), 'JPEG'];
        yield [(new Image_JPEG_Upload())->getScripts(...), ['transformations/image_upload.js']];
        yield [
            (new Image_JPEG_Upload())->getInputHtml(...),
            '<img src="" width="150" height="100" '
            . 'alt="Image preview here"><br><input type="file" '
            . 'name="fields_uploadtest" accept="image/*" class="image-upload">',
            ['test', ['150'], '', 0, 0],
        ];

        yield [
            (new Image_JPEG_Upload())->getInputHtml(...),
            '<input type="hidden" name="fields_prev2ndtest" '
            . 'value="736f6d657468696e67"><input type="hidden" '
            . 'name="fields2ndtest" value="736f6d657468696e67">'
            . '<img src="index.php?route=/transformation/wrapper&key=value&lang=en" width="100" '
            . 'height="100" alt="Image preview here"><br><input type="file" '
            . 'name="fields_upload2ndtest" accept="image/*" '
            . 'class="image-upload">',
            [
                '2ndtest',
                ['wrapper_link' => '?table=a', 'wrapper_params' => ['key' => 'value']],
                'something',
                0,
                0,
            ],
        ];

        // Test data for TextPlainFileupload plugin
        yield [Text_Plain_FileUpload::getName(...), 'Text file upload'];
        yield [
            Text_Plain_FileUpload::getInfo(...),
            'File upload functionality for TEXT columns. It does not have a textarea for input.',
        ];

        yield [Text_Plain_FileUpload::getMIMEType(...), 'Text'];
        yield [Text_Plain_FileUpload::getMIMESubtype(...), 'Plain'];
        yield [(new Text_Plain_FileUpload())->getScripts(...), []];
        yield [
            (new Text_Plain_FileUpload())->getInputHtml(...),
            '<input type="file" name="fields_uploadtest">',
            ['test', [], '', 0, 0],
        ];

        yield [
            (new Text_Plain_FileUpload())->getInputHtml(...),
            '<input type="hidden" name="fields_prev2ndtest" '
            . 'value="something"><input type="hidden" name="fields2ndtest" '
            . 'value="something"><input type="file" '
            . 'name="fields_upload2ndtest">',
            ['2ndtest', [], 'something', 0, 0],
        ];

        // Test data for Text_Plain_Regexvalidation plugin
        yield [Text_Plain_RegexValidation::getName(...), 'Regex Validation'];
        yield [
            Text_Plain_RegexValidation::getInfo(...),
            'Validates the string using regular expression '
            . 'and performs insert only if string matches it. '
            . 'The first option is the Regular Expression.',
        ];

        yield [Text_Plain_RegexValidation::getMIMEType(...), 'Text'];
        yield [Text_Plain_RegexValidation::getMIMESubtype(...), 'Plain'];
        yield [(new Text_Plain_RegexValidation())->getInputHtml(...), '', ['', [], '', 0, 0]];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Application_Octetstream_Download plugin
        yield [Application_Octetstream_Download::getName(...), 'Download'];
        yield [
            Application_Octetstream_Download::getInfo(...),
            'Displays a link to download the binary data of the column.'
            . ' You can use the option to specify the filename.',
        ];

        yield [Application_Octetstream_Download::getMIMEType(...), 'Application'];
        yield [Application_Octetstream_Download::getMIMESubtype(...), 'OctetStream'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Application_Octetstream_Hex plugin
        yield [Application_Octetstream_Hex::getName(...), 'Hex'];
        yield [
            Application_Octetstream_Hex::getInfo(...),
            'Displays hexadecimal representation of data. Optional first'
            . ' parameter specifies how often space will be added (defaults'
            . ' to 2 nibbles).',
        ];

        yield [Application_Octetstream_Hex::getMIMEType(...), 'Application'];
        yield [Application_Octetstream_Hex::getMIMESubtype(...), 'OctetStream'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Image_JPEG_Inline plugin
        yield [Image_JPEG_Inline::getName(...), 'Inline'];
        yield [
            Image_JPEG_Inline::getInfo(...),
            'Displays a clickable thumbnail. The options are the maximum width'
            . ' and height in pixels. The original aspect ratio is preserved.',
        ];

        yield [Image_JPEG_Inline::getMIMEType(...), 'Image'];
        yield [Image_JPEG_Inline::getMIMESubtype(...), 'JPEG'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Image_JPEG_Link plugin
        yield [Image_JPEG_Link::getName(...), 'ImageLink'];
        yield [Image_JPEG_Link::getInfo(...), 'Displays a link to download this image.'];
        yield [Image_JPEG_Link::getMIMEType(...), 'Image'];
        yield [Image_JPEG_Link::getMIMESubtype(...), 'JPEG'];
        yield [(new Image_JPEG_Link())->applyTransformationNoWrap(...), false];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Image_PNG_Inline plugin
        yield [Image_PNG_Inline::getName(...), 'Inline'];
        yield [
            Image_PNG_Inline::getInfo(...),
            'Displays a clickable thumbnail. The options are the maximum width'
            . ' and height in pixels. The original aspect ratio is preserved.',
        ];

        yield [Image_PNG_Inline::getMIMEType(...), 'Image'];
        yield [Image_PNG_Inline::getMIMESubtype(...), 'PNG'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Dateformat plugin
        yield [Text_Plain_Dateformat::getName(...), 'Date Format'];
        yield [
            Text_Plain_Dateformat::getInfo(...),
            'Displays a TIME, TIMESTAMP, DATETIME or numeric unix timestamp'
            . ' column as formatted date. The first option is the offset (in'
            . ' hours) which will be added to the timestamp (Default: 0). Use'
            . ' second option to specify a different date/time format string.'
            . ' Third option determines whether you want to see local date or'
            . ' UTC one (use "local" or "utc" strings) for that. According to'
            . ' that, date format has different value - for "local" see the'
            . ' documentation for PHP\'s strftime() function and for "utc" it'
            . ' is done using gmdate() function.',
        ];

        yield [Text_Plain_Dateformat::getMIMEType(...), 'Text'];
        yield [Text_Plain_Dateformat::getMIMESubtype(...), 'Plain'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_External plugin
        yield [Text_Plain_External::getName(...), 'External'];
        yield [
            Text_Plain_External::getInfo(...),
            'LINUX ONLY:'
            . ' Launches an external application and feeds it the column'
            . ' data via standard input. Returns the standard output of the'
            . ' application. The default is Tidy, to pretty-print HTML code.'
            . ' For security reasons, you have to manually edit the file'
            . ' src/Plugins/Transformations/Abs/ExternalTransformationsPlugin'
            . '.php and list the tools you want to make available.'
            . ' The first option is then the number of the program you want to'
            . ' use. The second option should be blank for historical reasons.'
            . ' The third option, if set to 1, will convert the output using'
            . ' htmlspecialchars() (Default 1). The fourth option, if set to 1,'
            . ' will prevent wrapping and ensure that the output appears all on'
            . ' one line (Default 1).',
        ];

        yield [Text_Plain_External::getMIMEType(...), 'Text'];
        yield [Text_Plain_External::getMIMESubtype(...), 'Plain'];
        yield [
            (new Text_Plain_External())->applyTransformationNoWrap(...),
            true,
            [['/dev/null -i -wrap -q', '/dev/null -i -wrap -q']],
        ];

        yield [
            (new Text_Plain_External())->applyTransformationNoWrap(...),
            true,
            [['/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '/dev/null -i -wrap -q', 1]],
        ];

        yield [
            (new Text_Plain_External())->applyTransformationNoWrap(...),
            true,
            [['/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '1']],
        ];

        yield [
            (new Text_Plain_External())->applyTransformationNoWrap(...),
            false,
            [['/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '/dev/null -i -wrap -q', 2]],
        ];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Formatted plugin
        yield [Text_Plain_Formatted::getName(...), 'Formatted'];
        yield [
            Text_Plain_Formatted::getInfo(...),
            'Displays the contents of the column as-is, without running it'
            . ' through htmlspecialchars(). That is, the column is assumed'
            . ' to contain valid HTML.',
        ];

        yield [Text_Plain_Formatted::getMIMEType(...), 'Text'];
        yield [Text_Plain_Formatted::getMIMESubtype(...), 'Plain'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Imagelink plugin
        yield [Text_Plain_Imagelink::getName(...), 'Image Link'];
        yield [
            Text_Plain_Imagelink::getInfo(...),
            'Displays an image and a link; '
            . 'the column contains the filename. The first option'
            . ' is a URL prefix like "https://www.example.com/". '
            . 'The second and third options'
            . ' are the width and the height in pixels.',
        ];

        yield [Text_Plain_Imagelink::getMIMEType(...), 'Text'];
        yield [Text_Plain_Imagelink::getMIMESubtype(...), 'Plain'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Sql plugin
        yield [Text_Plain_Sql::getName(...), 'SQL'];
        yield [Text_Plain_Sql::getInfo(...), 'Formats text as SQL query with syntax highlighting.'];
        yield [Text_Plain_Sql::getMIMEType(...), 'Text'];
        yield [Text_Plain_Sql::getMIMESubtype(...), 'Plain'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Text_Plain_Link plugin
        yield [Text_Plain_Link::getName(...), 'TextLink'];
        yield [
            Text_Plain_Link::getInfo(...),
            'Displays a link; the column contains the filename. The first option'
            . ' is a URL prefix like "https://www.example.com/".'
            . ' The second option is a title for the link.',
        ];

        yield [Text_Plain_Link::getMIMEType(...), 'Text'];
        yield [Text_Plain_Link::getMIMESubtype(...), 'Plain'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Text_Plain_Longtoipv4 plugin
        yield [Text_Plain_Longtoipv4::getName(...), 'Long To IPv4'];
        yield [
            Text_Plain_Longtoipv4::getInfo(...),
            'Converts an (IPv4) Internet network address stored as a BIGINT'
            . ' into a string in Internet standard dotted format.',
        ];

        yield [Text_Plain_Longtoipv4::getMIMEType(...), 'Text'];
        yield [Text_Plain_Longtoipv4::getMIMESubtype(...), 'Plain'];

        // Test data for Text_Plain_PreApPend plugin
        yield [Text_Plain_PreApPend::getName(...), 'PreApPend'];
        yield [
            Text_Plain_PreApPend::getInfo(...),
            'Prepends and/or Appends text to a string. First option is text'
            . ' to be prepended, second is appended (enclosed in single'
            . ' quotes, default empty string).',
        ];

        yield [Text_Plain_PreApPend::getMIMEType(...), 'Text'];
        yield [Text_Plain_PreApPend::getMIMESubtype(...), 'Plain'];

        // Test data for PhpMyAdmin\Plugins\Transformations\Text_Plain_Substring plugin
        yield [Text_Plain_Substring::getName(...), 'Substring'];
        yield [
            Text_Plain_Substring::getInfo(...),
            'Displays a part of a string. The first option is the number '
            . 'of characters to skip from the beginning of the string '
            . '(Default 0). The second option is the number of characters '
            . 'to return (Default: until end of string). The third option is '
            . 'the string to append and/or prepend when truncation occurs '
            . '(Default: "…").',
        ];

        yield [Text_Plain_Substring::getMIMEType(...), 'Text'];
        yield [Text_Plain_Substring::getMIMESubtype(...), 'Plain'];
        yield [(new Text_Plain_Substring())->getOptions(...), ['foo', 'bar', 'baz'], [[], ['foo', 'bar', 'baz']]];
        yield [
            (new Text_Plain_Substring())->getOptions(...),
            ['foo', 'bar', 'baz'],
            [['foo', 'bar', 'baz'], ['foo', 'bar', 'baz']],
        ];

        yield [
            (new Text_Plain_Substring())->getOptions(...),
            ['foo', 'bar', 'baz'],
            [['foo', 'bar', 'baz'], [1, 2, 3]],
        ];
    }

    /**
     * Tests for getInfo, getName, getMIMEType, getMIMESubtype
     * getScripts, applyTransformationNoWrap, getOptions
     *
     * @param Closure $callable the plugin method callable
     * @param mixed   $expected the expected output
     * @param mixed[] $args     the array of arguments
     */
    #[DataProvider('multiDataProvider')]
    public function testGetMulti(Closure $callable, mixed $expected, array $args = []): void
    {
        self::assertSame($expected, $callable(...$args));
    }

    /**
     * @return iterable<array-key, array{
     *     0: TransformationsPlugin,
     *     1: array{0: string, 1?: mixed[], 2?: FieldMetadata|null},
     *     2: string|int,
     *     3?: bool,
     *     4?: string
     * }>
     */
    public static function transformationDataProvider(): iterable
    {
        yield [new Image_JPEG_Upload(), ['test', [150, 100]], 'test'];
        yield [new Text_Plain_FileUpload(), ['test', []], 'test'];
        yield [new Text_Plain_RegexValidation(), ['phpMyAdmin', ['/php/i']], 'phpMyAdmin', true, ''];
        yield [
            new Text_Plain_RegexValidation(),
            ['qwerty', ['/^a/']],
            'qwerty',
            false,
            'Validation failed for the input string qwerty.',
        ];

        yield [
            new Application_Octetstream_Download(),
            [
                'PMA_BUFFER',
                [0 => 'filename', 'wrapper_link' => 'PMA_wrapper_link', 'wrapper_params' => ['key' => 'value']],
            ],
            '<a href="index.php?route=/transformation/wrapper&key=value'
            . '&ct=application%2Foctet-stream&cn=filename&lang=en" '
            . 'title="filename" class="disableAjax">filename</a>',
        ];

        yield [
            new Application_Octetstream_Download(),
            [
                'PMA_BUFFER',
                [
                    0 => '',
                    1 => 'cloumn',
                    'wrapper_link' => 'PMA_wrapper_link',
                    'wrapper_params' => ['key' => 'value'],
                ],
            ],
            '<a href="index.php?route=/transformation/wrapper&key=value'
            . '&ct=application%2Foctet-stream&cn=binary_file.dat&lang=en" '
            . 'title="binary_file.dat" class="disableAjax">binary_file.dat</a>',
        ];

        yield [new Application_Octetstream_Hex(), ['11111001', [3]], '313 131 313 130 303 1 '];
        yield [new Application_Octetstream_Hex(), ['11111001', [0]], '3131313131303031'];
        yield [new Application_Octetstream_Hex(), ['11111001', []], '31 31 31 31 31 30 30 31 '];
        yield [
            new Image_JPEG_Link(),
            [
                'PMA_IMAGE_LINK',
                [
                    0 => './image/',
                    1 => '200',
                    'wrapper_link' => 'PMA_wrapper_link',
                    'wrapper_params' => ['key' => 'value'],
                ],
            ],
            '<a class="disableAjax" target="_blank" rel="noopener noreferrer"'
            . ' href="index.php?route=/transformation/wrapper&key=value&lang=en"'
            . ' alt="[PMA_IMAGE_LINK]">[BLOB]</a>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            ['12345', [0], FieldHelper::fromArray(['type' => MYSQLI_TYPE_TINY])],
            '<dfn onclick="alert(&quot;12345&quot;);" title="12345">Jan 01, 1970 at 03:25 AM</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            ['12345678', [0], FieldHelper::fromArray(['type' => MYSQLI_TYPE_STRING])],
            '<dfn onclick="alert(&quot;12345678&quot;);" title="12345678">May 23, 1970 at 09:21 PM</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            ['123456789', [0], FieldHelper::fromArray(['type' => -1])],
            '<dfn onclick="alert(&quot;123456789&quot;);" title="123456789">Nov 29, 1973 at 09:33 PM</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            ['20100201', [0], FieldHelper::fromArray(['type' => -1])],
            '<dfn onclick="alert(&quot;20100201&quot;);" title="20100201">Feb 01, 2010 at 12:00 AM</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            ['1617153941', ['0', '%B %d, %Y at %I:%M %p', 'local'], FieldHelper::fromArray(['type' => -1])],
            '<dfn onclick="alert(&quot;1617153941&quot;);" title="1617153941">Mar 31, 2021 at 01:25 AM</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            [
                '1617153941',
                [
                    '0',
                    '',// Empty uses the "Y-m-d  H:i:s" format
                    'utc',
                ],
                FieldHelper::fromArray(['type' => -1]),
            ],
            '<dfn onclick="alert(&quot;1617153941&quot;);" title="1617153941">2021-03-31  01:25:41</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            [
                '1617153941',
                [
                    '0',
                    '',// Empty uses the "%B %d, %Y at %I:%M %p" format
                    'local',
                ],
                FieldHelper::fromArray(['type' => -1]),
            ],
            '<dfn onclick="alert(&quot;1617153941&quot;);" title="1617153941">Mar 31, 2021 at 01:25 AM</dfn>',
        ];

        yield [
            new Text_Plain_Dateformat(),
            ['1617153941', ['0', 'H:i:s Y-d-m', 'utc'], FieldHelper::fromArray(['type' => -1])],
            '<dfn onclick="alert(&quot;1617153941&quot;);" title="1617153941">01:25:41 2021-31-03</dfn>',
        ];

        yield [
            new Text_Plain_External(),
            ['PMA_BUFFER', ['/dev/null -i -wrap -q', '/dev/null -i -wrap -q']],
            'PMA_BUFFER',
        ];

        yield [
            new Text_Plain_Formatted(),
            ["<a ref='https://www.example.com/'>PMA_BUFFER</a>", ['option1', 'option2']],
            "<iframe srcdoc=\"<a ref='https://www.example.com/'>PMA_BUFFER</a>\" sandbox=\"\"></iframe>",
        ];

        yield [
            new Text_Plain_Formatted(),
            ['<a ref="https://www.example.com/">PMA_BUFFER</a>', ['option1', 'option2']],
            "<iframe srcdoc=\"<a ref='https://www.example.com/'>PMA_BUFFER</a>\" sandbox=\"\"></iframe>",
        ];

        yield [
            new Text_Plain_Imagelink(),
            ['PMA_IMAGE', ['http://image/', '200']],
            '<a href="http://image/PMA_IMAGE" rel="noopener noreferrer" target="_blank">' . "\n"
            . '    <img src="http://image/PMA_IMAGE" border="0" width="200" height="50">' . "\n"
            . '    PMA_IMAGE' . "\n"
            . '</a>' . "\n",
        ];

        yield [new Text_Plain_Imagelink(), ['PMA_IMAGE', ['./image/', '200']], './image/PMA_IMAGE'];
        yield [
            new Text_Plain_Sql(),
            ['select *', ['option1', 'option2']],
            '<pre><code class="sql" dir="ltr">'
            . 'select *'
            . '</code></pre>',
        ];

        yield [new Text_Plain_Link(), ['PMA_TXT_LINK', ['./php/', 'text_name']], './php/PMA_TXT_LINK'];
        yield [new Text_Plain_Link(), ['PMA_TXT_LINK', []], 'PMA_TXT_LINK'];
        yield [
            new Text_Plain_Link(),
            ['https://example.com/PMA_TXT_LINK', []],
            '<a href="https://example.com/PMA_TXT_LINK" title=""'
            . ' target="_blank" rel="noopener noreferrer">https://example.com/PMA_TXT_LINK</a>',
        ];

        yield [new Text_Plain_Link(), ['PMA_TXT_LINK', ['./php/', 'text_name']], './php/PMA_TXT_LINK'];
        yield [new Text_Plain_Longtoipv4(), ['42949672', []], '2.143.92.40'];
        yield [new Text_Plain_Longtoipv4(), ['4294967295', ['option1', 'option2']], '255.255.255.255'];
        yield [new Text_Plain_PreApPend(), ['My', ['php', 'Admin']], 'phpMyAdmin'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', [1, 3, 'suffix']], 'suffixMA_suffix'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', ['1', '3', 'suffix']], 'suffixMA_suffix'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', ['2']], '…A_BUFFER'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', [2]], '…A_BUFFER'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', [0]], 'PMA_BUFFER'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', ['0']], 'PMA_BUFFER'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', [-1]], '…R…'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', ['-1']], '…R…'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', [0, 2]], 'PM…'];
        yield [new Text_Plain_Substring(), ['PMA_BUFFER', ['0', '2']], 'PM…'];
        yield [new Text_Plain_Substring(), ['2', []], '2'];
        yield [new Text_Plain_Longtoipv4(), ['168496141'], '10.11.12.13'];
        yield [new Text_Plain_Longtoipv4(), ['my ip'], 'my ip'];
        yield [new Text_Plain_Longtoipv4(), ['<my ip>'], '&lt;my ip&gt;'];
        yield [new Text_Plain_Iptolong(), ['10.11.12.13'], '168496141'];
        yield [new Text_Plain_Iptolong(), ['10.11.12.913'], '10.11.12.913'];
        yield [new Text_Plain_Iptolong(), ['my ip'], 'my ip'];
        yield [new Text_Plain_Iptolong(), ['<my ip>'], '<my ip>'];

        if (! function_exists('imagecreatetruecolor')) {
            return;
        }

        yield [
            new Image_JPEG_Inline(),
            [
                'PMA_JPEG_Inline',
                [
                    0 => './image/',
                    1 => '200',
                    'wrapper_link' => 'PMA_wrapper_link',
                    'wrapper_params' => ['key' => 'value'],
                ],
            ],
            '<a href="index.php?route=/transformation/wrapper&key=value&lang=en" '
            . 'rel="noopener noreferrer" target="_blank"><img src="index.php?route=/transformation/wrapper'
            . '&key=value&resize=jpeg&newWidth=0&'
            . 'newHeight=200&lang=en" alt="[PMA_JPEG_Inline]" border="0"></a>',
        ];

        yield [
            new Image_PNG_Inline(),
            [
                'PMA_PNG_Inline',
                [
                    0 => './image/',
                    1 => '200',
                    'wrapper_link' => 'PMA_wrapper_link',
                    'wrapper_params' => ['key' => 'value'],
                ],
            ],
            '<a href="index.php?route=/transformation/wrapper&key=value&lang=en"'
            . ' rel="noopener noreferrer" target="_blank"><img src="index.php?route=/transformation/wrapper'
            . '&key=value&resize=jpeg&newWidth=0&newHeight=200&lang=en" '
            . 'alt="[PMA_PNG_Inline]" border="0"></a>',
        ];
    }

    /**
     * Tests for applyTransformation, isSuccess, getError
     *
     * @param TransformationsPlugin $object      instance of the plugin
     * @param array                 $applyArgs   arguments for applyTransformation
     * @param string                $transformed the expected output of applyTransformation
     * @param bool                  $success     the expected output of isSuccess
     * @param string                $error       the expected output of getError
     * @psalm-param array{string, array, FieldMetadata|null} $applyArgs
     */
    #[DataProvider('transformationDataProvider')]
    public function testTransformation(
        TransformationsPlugin $object,
        array $applyArgs,
        string $transformed,
        bool $success = true,
        string $error = '',
    ): void {
        $actual = $object->applyTransformation(...$applyArgs);
        self::assertSame($transformed, $actual);

        if (! ($object instanceof IOTransformationsPlugin)) {
            return;
        }

        self::assertSame(
            $success,
            $object->isSuccess(),
        );

        self::assertSame(
            $error,
            $object->getError(),
        );
    }
}