683 lines
31 KiB
PHP
683 lines
31 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpMyAdmin\Tests\Plugins\Transformations;
|
|
|
|
use PhpMyAdmin\Config;
|
|
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 ReflectionMethod;
|
|
|
|
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 array<array{0: TransformationsPlugin, 1: string, 2: mixed, 3?: mixed[]}> */
|
|
public static function multiDataProvider(): array
|
|
{
|
|
// TODO: Figure out why this is needed here
|
|
Config::getInstance()->set('CodemirrorEnable', false);
|
|
|
|
return [
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Input\Image_JPEG_Upload plugin
|
|
[new Image_JPEG_Upload(), 'getName', 'Image upload'],
|
|
[
|
|
new 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.',
|
|
],
|
|
[new Image_JPEG_Upload(), 'getMIMEType', 'Image'],
|
|
[new Image_JPEG_Upload(), 'getMIMESubtype', 'JPEG'],
|
|
[new Image_JPEG_Upload(), 'getScripts', ['transformations/image_upload.js']],
|
|
[
|
|
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],
|
|
],
|
|
[
|
|
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
|
|
[new Text_Plain_FileUpload(), 'getName', 'Text file upload'],
|
|
[
|
|
new Text_Plain_FileUpload(),
|
|
'getInfo',
|
|
'File upload functionality for TEXT columns. It does not have a textarea for input.',
|
|
],
|
|
[new Text_Plain_FileUpload(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_FileUpload(), 'getMIMESubtype', 'Plain'],
|
|
[new Text_Plain_FileUpload(), 'getScripts', []],
|
|
[
|
|
new Text_Plain_FileUpload(),
|
|
'getInputHtml',
|
|
'<input type="file" name="fields_uploadtest">',
|
|
['test', [], '', 0, 0],
|
|
],
|
|
[
|
|
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
|
|
[new Text_Plain_RegexValidation(), 'getName', 'Regex Validation'],
|
|
[
|
|
new 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.',
|
|
],
|
|
[new Text_Plain_RegexValidation(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_RegexValidation(), 'getMIMESubtype', 'Plain'],
|
|
[new Text_Plain_RegexValidation(), 'getInputHtml', '', ['', [], '', 0, 0]],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Application_Octetstream_Download plugin
|
|
[new Application_Octetstream_Download(), 'getName', 'Download'],
|
|
[
|
|
new Application_Octetstream_Download(),
|
|
'getInfo',
|
|
'Displays a link to download the binary data of the column.'
|
|
. ' You can use the option to specify the filename.',
|
|
],
|
|
[new Application_Octetstream_Download(), 'getMIMEType', 'Application'],
|
|
[new Application_Octetstream_Download(), 'getMIMESubtype', 'OctetStream'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Application_Octetstream_Hex plugin
|
|
[new Application_Octetstream_Hex(), 'getName', 'Hex'],
|
|
[
|
|
new Application_Octetstream_Hex(),
|
|
'getInfo',
|
|
'Displays hexadecimal representation of data. Optional first'
|
|
. ' parameter specifies how often space will be added (defaults'
|
|
. ' to 2 nibbles).',
|
|
],
|
|
[new Application_Octetstream_Hex(), 'getMIMEType', 'Application'],
|
|
[new Application_Octetstream_Hex(), 'getMIMESubtype', 'OctetStream'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Image_JPEG_Inline plugin
|
|
[new Image_JPEG_Inline(), 'getName', 'Inline'],
|
|
[
|
|
new Image_JPEG_Inline(),
|
|
'getInfo',
|
|
'Displays a clickable thumbnail. The options are the maximum width'
|
|
. ' and height in pixels. The original aspect ratio is preserved.',
|
|
],
|
|
[new Image_JPEG_Inline(), 'getMIMEType', 'Image'],
|
|
[new Image_JPEG_Inline(), 'getMIMESubtype', 'JPEG'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Image_JPEG_Link plugin
|
|
[new Image_JPEG_Link(), 'getName', 'ImageLink'],
|
|
[new Image_JPEG_Link(), 'getInfo', 'Displays a link to download this image.'],
|
|
[new Image_JPEG_Link(), 'getMIMEType', 'Image'],
|
|
[new Image_JPEG_Link(), 'getMIMESubtype', 'JPEG'],
|
|
[new Image_JPEG_Link(), 'applyTransformationNoWrap', false],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Image_PNG_Inline plugin
|
|
[new Image_PNG_Inline(), 'getName', 'Inline'],
|
|
[
|
|
new Image_PNG_Inline(),
|
|
'getInfo',
|
|
'Displays a clickable thumbnail. The options are the maximum width'
|
|
. ' and height in pixels. The original aspect ratio is preserved.',
|
|
],
|
|
[new Image_PNG_Inline(), 'getMIMEType', 'Image'],
|
|
[new Image_PNG_Inline(), 'getMIMESubtype', 'PNG'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Dateformat plugin
|
|
[new Text_Plain_Dateformat(), 'getName', 'Date Format'],
|
|
[
|
|
new 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.',
|
|
],
|
|
[new Text_Plain_Dateformat(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Dateformat(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_External plugin
|
|
[new Text_Plain_External(), 'getName', 'External'],
|
|
[
|
|
new 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).',
|
|
],
|
|
[new Text_Plain_External(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_External(), 'getMIMESubtype', 'Plain'],
|
|
[
|
|
new Text_Plain_External(),
|
|
'applyTransformationNoWrap',
|
|
true,
|
|
[['/dev/null -i -wrap -q', '/dev/null -i -wrap -q']],
|
|
],
|
|
[
|
|
new Text_Plain_External(),
|
|
'applyTransformationNoWrap',
|
|
true,
|
|
[['/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '/dev/null -i -wrap -q', 1]],
|
|
],
|
|
[
|
|
new Text_Plain_External(),
|
|
'applyTransformationNoWrap',
|
|
true,
|
|
[['/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '/dev/null -i -wrap -q', '1']],
|
|
],
|
|
[
|
|
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
|
|
[new Text_Plain_Formatted(), 'getName', 'Formatted'],
|
|
[
|
|
new 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.',
|
|
],
|
|
[new Text_Plain_Formatted(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Formatted(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Imagelink plugin
|
|
[new Text_Plain_Imagelink(), 'getName', 'Image Link'],
|
|
[
|
|
new 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.',
|
|
],
|
|
[new Text_Plain_Imagelink(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Imagelink(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Output\Text_Plain_Sql plugin
|
|
[new Text_Plain_Sql(), 'getName', 'SQL'],
|
|
[new Text_Plain_Sql(), 'getInfo', 'Formats text as SQL query with syntax highlighting.'],
|
|
[new Text_Plain_Sql(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Sql(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Text_Plain_Link plugin
|
|
[new Text_Plain_Link(), 'getName', 'TextLink'],
|
|
[
|
|
new 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.',
|
|
],
|
|
[new Text_Plain_Link(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Link(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Text_Plain_Longtoipv4 plugin
|
|
[new Text_Plain_Longtoipv4(), 'getName', 'Long To IPv4'],
|
|
[
|
|
new Text_Plain_Longtoipv4(),
|
|
'getInfo',
|
|
'Converts an (IPv4) Internet network address stored as a BIGINT'
|
|
. ' into a string in Internet standard dotted format.',
|
|
],
|
|
[new Text_Plain_Longtoipv4(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Longtoipv4(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for Text_Plain_PreApPend plugin
|
|
[new Text_Plain_PreApPend(), 'getName', 'PreApPend'],
|
|
[
|
|
new 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).',
|
|
],
|
|
[new Text_Plain_PreApPend(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_PreApPend(), 'getMIMESubtype', 'Plain'],
|
|
// Test data for PhpMyAdmin\Plugins\Transformations\Text_Plain_Substring plugin
|
|
[new Text_Plain_Substring(), 'getName', 'Substring'],
|
|
[
|
|
new 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: "…").',
|
|
],
|
|
[new Text_Plain_Substring(), 'getMIMEType', 'Text'],
|
|
[new Text_Plain_Substring(), 'getMIMESubtype', 'Plain'],
|
|
[new Text_Plain_Substring(), 'getOptions', ['foo', 'bar', 'baz'], [[], ['foo', 'bar', 'baz']]],
|
|
[
|
|
new Text_Plain_Substring(),
|
|
'getOptions',
|
|
['foo', 'bar', 'baz'],
|
|
[['foo', 'bar', 'baz'], ['foo', 'bar', 'baz']],
|
|
],
|
|
[new Text_Plain_Substring(), 'getOptions', ['foo','bar','baz'], [['foo','bar','baz'],[1,2,3]]],
|
|
];
|
|
}
|
|
|
|
/**
|
|
* Tests for getInfo, getName, getMIMEType, getMIMESubtype
|
|
* getScripts, applyTransformationNoWrap, getOptions
|
|
*
|
|
* @param object $object instance of the plugin
|
|
* @param string $method the method name
|
|
* @param mixed $expected the expected output
|
|
* @param mixed[] $args the array of arguments
|
|
*/
|
|
#[DataProvider('multiDataProvider')]
|
|
public function testGetMulti(object $object, string $method, mixed $expected, array $args = []): void
|
|
{
|
|
$reflectionMethod = new ReflectionMethod($object, $method);
|
|
self::assertSame(
|
|
$expected,
|
|
$reflectionMethod->invokeArgs($object, $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("12345");" 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("12345678");" title="12345678">May 23, 1970 at 09:21 PM</dfn>',
|
|
];
|
|
|
|
yield [
|
|
new Text_Plain_Dateformat(),
|
|
['123456789', [0], FieldHelper::fromArray(['type' => -1])],
|
|
'<dfn onclick="alert("123456789");" title="123456789">Nov 29, 1973 at 09:33 PM</dfn>',
|
|
];
|
|
|
|
yield [
|
|
new Text_Plain_Dateformat(),
|
|
['20100201', [0], FieldHelper::fromArray(['type' => -1])],
|
|
'<dfn onclick="alert("20100201");" 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("1617153941");" 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("1617153941");" 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("1617153941");" 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("1617153941");" 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>'], '<my ip>'];
|
|
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(),
|
|
);
|
|
}
|
|
}
|
