webapp/phpmyadmin
1
0
Fork 0
mirror of https://github.com/phpmyadmin/phpmyadmin.git synced 2026-10-25 06:39:48 +03:00
Code Activity
Files
STABLE
phpmyadmin/test/classes/Plugins/Export/ExportTexytextTest.php
Maurício Meneghini Fauth e8c216b17e Fix PHP 8.5 Reflection*::setAccessible() deprecations 
Signed-off-by: Maurício Meneghini Fauth <mauricio@mfauth.net>
2025-08-17 13:32:00 -03:00

434 lines
13 KiB
PHP
Raw Permalink Blame History

<?php
declare(strict_types=1);
namespace PhpMyAdmin\Tests\Plugins\Export;
use PhpMyAdmin\ConfigStorage\Relation;
use PhpMyAdmin\ConfigStorage\RelationParameters;
use PhpMyAdmin\DatabaseInterface;
use PhpMyAdmin\Plugins\Export\ExportTexytext;
use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyMainGroup;
use PhpMyAdmin\Properties\Options\Groups\OptionsPropertyRootGroup;
use PhpMyAdmin\Properties\Options\Items\BoolPropertyItem;
use PhpMyAdmin\Properties\Options\Items\RadioPropertyItem;
use PhpMyAdmin\Properties\Options\Items\TextPropertyItem;
use PhpMyAdmin\Properties\Plugins\ExportPluginProperties;
use PhpMyAdmin\Tests\AbstractTestCase;
use ReflectionMethod;
use ReflectionProperty;
use function array_shift;
use function ob_get_clean;
use function ob_start;
use const PHP_VERSION_ID;
/**
* @covers \PhpMyAdmin\Plugins\Export\ExportTexytext
* @group medium
*/
class ExportTexytextTest extends AbstractTestCase
{
/** @var ExportTexytext */
protected $object;
/**
* Configures global environment.
*/
protected function setUp(): void
{
parent::setUp();
$GLOBALS['server'] = 0;
$GLOBALS['output_kanji_conversion'] = false;
$GLOBALS['buffer_needed'] = false;
$GLOBALS['asfile'] = false;
$GLOBALS['save_on_server'] = false;
$GLOBALS['plugin_param'] = [];
$GLOBALS['plugin_param']['export_type'] = 'table';
$GLOBALS['plugin_param']['single_table'] = false;
$GLOBALS['db'] = '';
$GLOBALS['table'] = '';
$GLOBALS['lang'] = 'en';
$GLOBALS['text_dir'] = 'ltr';
$GLOBALS['PMA_PHP_SELF'] = '';
$GLOBALS['cfg']['Server']['DisableIS'] = true;
$this->object = new ExportTexytext();
}
/**
* tearDown for test cases
*/
protected function tearDown(): void
{
parent::tearDown();
unset($this->object);
}
public function testSetProperties(): void
{
$method = new ReflectionMethod(ExportTexytext::class, 'setProperties');
if (PHP_VERSION_ID < 80100) {
$method->setAccessible(true);
}
$method->invoke($this->object, null);
$attrProperties = new ReflectionProperty(ExportTexytext::class, 'properties');
if (PHP_VERSION_ID < 80100) {
$attrProperties->setAccessible(true);
}
$properties = $attrProperties->getValue($this->object);
self::assertInstanceOf(ExportPluginProperties::class, $properties);
self::assertSame('Texy! text', $properties->getText());
self::assertSame('txt', $properties->getExtension());
self::assertSame('text/plain', $properties->getMimeType());
$options = $properties->getOptions();
self::assertInstanceOf(OptionsPropertyRootGroup::class, $options);
self::assertSame('Format Specific Options', $options->getName());
$generalOptionsArray = $options->getProperties();
$generalOptions = array_shift($generalOptionsArray);
self::assertInstanceOf(OptionsPropertyMainGroup::class, $generalOptions);
self::assertSame('general_opts', $generalOptions->getName());
self::assertSame('Dump table', $generalOptions->getText());
$generalProperties = $generalOptions->getProperties();
$property = array_shift($generalProperties);
self::assertInstanceOf(RadioPropertyItem::class, $property);
$generalOptions = array_shift($generalOptionsArray);
self::assertInstanceOf(OptionsPropertyMainGroup::class, $generalOptions);
self::assertSame('data', $generalOptions->getName());
$generalProperties = $generalOptions->getProperties();
$property = array_shift($generalProperties);
self::assertInstanceOf(BoolPropertyItem::class, $property);
self::assertSame('columns', $property->getName());
$property = array_shift($generalProperties);
self::assertInstanceOf(TextPropertyItem::class, $property);
self::assertSame('null', $property->getName());
}
public function testExportHeader(): void
{
self::assertTrue($this->object->exportHeader());
}
public function testExportFooter(): void
{
self::assertTrue($this->object->exportFooter());
}
public function testExportDBHeader(): void
{
$this->expectOutputString("===Database testDb\n\n");
self::assertTrue($this->object->exportDBHeader('testDb'));
}
public function testExportDBFooter(): void
{
self::assertTrue($this->object->exportDBFooter('testDB'));
}
public function testExportDBCreate(): void
{
self::assertTrue($this->object->exportDBCreate('testDB', 'database'));
}
public function testExportData(): void
{
$GLOBALS['what'] = 'foo';
$GLOBALS['foo_columns'] = '&';
$GLOBALS['foo_null'] = '>';
ob_start();
self::assertTrue($this->object->exportData(
'test_db',
'test_table',
"\n",
'localhost',
'SELECT * FROM `test_db`.`test_table`;'
));
$result = ob_get_clean();
self::assertIsString($result);
self::assertSame('== Dumping data for table test_table' . "\n\n"
. '|------' . "\n"
. '|id|name|datetimefield' . "\n"
. '|------' . "\n"
. '|1|abcd|2011-01-20 02:00:02' . "\n"
. '|2|foo|2010-01-20 02:00:02' . "\n"
. '|3|Abcd|2012-01-20 02:00:02' . "\n", $result);
}
public function testGetTableDefStandIn(): void
{
$this->dummyDbi->addSelectDb('test_db');
$result = $this->object->getTableDefStandIn('test_db', 'test_table', "\n");
$this->assertAllSelectsConsumed();
self::assertSame('|------' . "\n"
. '|Column|Type|Null|Default' . "\n"
. '|------' . "\n"
. '|//**id**//|int(11)|No|NULL' . "\n"
. '|name|varchar(20)|No|NULL' . "\n"
. '|datetimefield|datetime|No|NULL' . "\n", $result);
}
public function testGetTableDef(): void
{
$this->object = $this->getMockBuilder(ExportTexytext::class)
->onlyMethods(['formatOneColumnDefinition'])
->getMock();
// case 1
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$keys = [
[
'Non_unique' => 0,
'Column_name' => 'cname',
],
[
'Non_unique' => 1,
'Column_name' => 'cname2',
],
];
$dbi->expects($this->once())
->method('getTableIndexes')
->with('db', 'table')
->will($this->returnValue($keys));
$dbi->expects($this->exactly(2))
->method('fetchResult')
->willReturnOnConsecutiveCalls(
[
'fname' => [
'foreign_table' => '<ftable',
'foreign_field' => 'ffield>',
],
],
[
'fname' => [
'values' => 'test-',
'transformation' => 'testfoo',
'mimetype' => 'test<',
],
]
);
$dbi->expects($this->once())
->method('fetchValue')
->will(
$this->returnValue(
'SELECT a FROM b'
)
);
$columns = [
'Field' => 'fname',
'Comment' => 'comm',
];
$dbi->expects($this->exactly(2))
->method('getColumns')
->with('db', 'table')
->will($this->returnValue([$columns]));
$GLOBALS['dbi'] = $dbi;
$this->object->relation = new Relation($dbi);
$this->object->expects($this->exactly(1))
->method('formatOneColumnDefinition')
->with(['Field' => 'fname', 'Comment' => 'comm'], ['cname'])
->will($this->returnValue(1));
$_SESSION['relation'] = [];
$_SESSION['relation'][$GLOBALS['server']] = RelationParameters::fromArray([
'relwork' => true,
'commwork' => true,
'mimework' => true,
'db' => 'database',
'relation' => 'rel',
'column_info' => 'col',
])->toArray();
$result = $this->object->getTableDef('db', 'table', "\n", 'example.com', true, true, true);
self::assertStringContainsString('1|&lt;ftable (ffield&gt;)|comm|Test&lt;', $result);
}
public function testGetTriggers(): void
{
$dbi = $this->getMockBuilder(DatabaseInterface::class)
->disableOriginalConstructor()
->getMock();
$triggers = [
[
'name' => 'tna"me',
'action_timing' => 'ac>t',
'event_manipulation' => 'manip&',
'definition' => 'def',
],
];
$dbi->expects($this->once())
->method('getTriggers')
->with('database', 'ta<ble')
->will($this->returnValue($triggers));
$GLOBALS['dbi'] = $dbi;
$result = $this->object->getTriggers('database', 'ta<ble');
self::assertStringContainsString('|tna"me|ac>t|manip&|def', $result);
self::assertStringContainsString('|Name|Time|Event|Definition', $result);
}
public function testExportStructure(): void
{
// case 1
ob_start();
$this->dummyDbi->addSelectDb('test_db');
self::assertTrue($this->object->exportStructure(
'test_db',
'test_table',
"\n",
'localhost',
'create_table',
'test'
));
$this->assertAllSelectsConsumed();
$result = ob_get_clean();
self::assertIsString($result);
self::assertSame('== Table structure for table test_table' . "\n\n"
. '|------' . "\n"
. '|Column|Type|Null|Default' . "\n"
. '|------' . "\n"
. '|//**id**//|int(11)|No|NULL' . "\n"
. '|name|varchar(20)|No|NULL' . "\n"
. '|datetimefield|datetime|No|NULL' . "\n", $result);
// case 2
ob_start();
self::assertTrue($this->object->exportStructure(
'test_db',
'test_table',
"\n",
'localhost',
'triggers',
'test'
));
$result = ob_get_clean();
self::assertSame('== Triggers test_table' . "\n\n"
. '|------' . "\n"
. '|Name|Time|Event|Definition' . "\n"
. '|------' . "\n"
. '|test_trigger|AFTER|INSERT|BEGIN END' . "\n", $result);
// case 3
ob_start();
$this->dummyDbi->addSelectDb('test_db');
self::assertTrue($this->object->exportStructure(
'test_db',
'test_table',
"\n",
'localhost',
'create_view',
'test'
));
$this->assertAllSelectsConsumed();
$result = ob_get_clean();
self::assertSame('== Structure for view test_table' . "\n\n"
. '|------' . "\n"
. '|Column|Type|Null|Default' . "\n"
. '|------' . "\n"
. '|//**id**//|int(11)|No|NULL' . "\n"
. '|name|varchar(20)|No|NULL' . "\n"
. '|datetimefield|datetime|No|NULL' . "\n", $result);
// case 4
ob_start();
$this->dummyDbi->addSelectDb('test_db');
self::assertTrue($this->object->exportStructure(
'test_db',
'test_table',
"\n",
'localhost',
'stand_in',
'test'
));
$this->assertAllSelectsConsumed();
$result = ob_get_clean();
self::assertSame('== Stand-in structure for view test_table' . "\n\n"
. '|------' . "\n"
. '|Column|Type|Null|Default' . "\n"
. '|------' . "\n"
. '|//**id**//|int(11)|No|NULL' . "\n"
. '|name|varchar(20)|No|NULL' . "\n"
. '|datetimefield|datetime|No|NULL' . "\n", $result);
}
public function testFormatOneColumnDefinition(): void
{
$cols = [
'Null' => 'Yes',
'Field' => 'field',
'Key' => 'PRI',
'Type' => 'set(abc)enum123',
];
$unique_keys = ['field'];
self::assertSame(
'|//**field**//|set(abc)|Yes|NULL',
$this->object->formatOneColumnDefinition($cols, $unique_keys)
);
$cols = [
'Null' => 'NO',
'Field' => 'fields',
'Key' => 'COMP',
'Type' => '',
'Default' => 'def',
];
$unique_keys = ['field'];
self::assertSame('|fields|&amp;nbsp;|No|def', $this->object->formatOneColumnDefinition($cols, $unique_keys));
}
}
View Git Blame Copy Permalink