| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/phpMyAdmin/test/classes/plugin/export/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* tests for PMA\libraries\plugins\export\ExportMediawiki class
*
* @package PhpMyAdmin-test
*/
use PMA\libraries\plugins\export\ExportMediawiki;
require_once 'libraries/export.lib.php';
require_once 'libraries/config.default.php';
require_once 'export.php';
require_once 'test/PMATestCase.php';
/**
* tests for PMA\libraries\plugins\export\ExportMediawiki class
*
* @package PhpMyAdmin-test
* @group medium
*/
class ExportMediawikiTest extends PMATestCase
{
protected $object;
/**
* Configures global environment.
*
* @return void
*/
function setup()
{
$GLOBALS['server'] = 0;
$GLOBALS['output_kanji_conversion'] = false;
$GLOBALS['output_charset_conversion'] = false;
$GLOBALS['buffer_needed'] = false;
$GLOBALS['asfile'] = true;
$GLOBALS['save_on_server'] = false;
$this->object = new ExportMediawiki();
}
/**
* tearDown for test cases
*
* @return void
*/
public function tearDown()
{
unset($this->object);
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::setProperties
*
* @return void
*/
public function testSetProperties()
{
$method = new ReflectionMethod('PMA\libraries\plugins\export\ExportMediawiki', 'setProperties');
$method->setAccessible(true);
$method->invoke($this->object, null);
$attrProperties = new ReflectionProperty('PMA\libraries\plugins\export\ExportMediawiki', 'properties');
$attrProperties->setAccessible(true);
$properties = $attrProperties->getValue($this->object);
$this->assertInstanceOf(
'PMA\libraries\properties\plugins\ExportPluginProperties',
$properties
);
$this->assertEquals(
'MediaWiki Table',
$properties->getText()
);
$this->assertEquals(
'mediawiki',
$properties->getExtension()
);
$this->assertEquals(
'text/plain',
$properties->getMimeType()
);
$this->assertEquals(
'Options',
$properties->getOptionsText()
);
$options = $properties->getOptions();
$this->assertInstanceOf(
'PMA\libraries\properties\options\groups\OptionsPropertyRootGroup',
$options
);
$this->assertEquals(
'Format Specific Options',
$options->getName()
);
$generalOptionsArray = $options->getProperties();
$generalOptions = $generalOptionsArray[0];
$this->assertInstanceOf(
'PMA\libraries\properties\options\groups\OptionsPropertyMainGroup',
$generalOptions
);
$this->assertEquals(
'general_opts',
$generalOptions->getName()
);
$this->assertEquals(
'Dump table',
$generalOptions->getText()
);
$generalProperties = $generalOptions->getProperties();
$property = array_shift($generalProperties);
$this->assertInstanceOf(
'PMA\libraries\properties\options\groups\OptionsPropertySubgroup',
$property
);
$this->assertEquals(
'dump_table',
$property->getName()
);
$this->assertEquals(
'Dump table',
$property->getText()
);
$sgHeader = $property->getSubGroupHeader();
$this->assertInstanceOf(
'PMA\libraries\properties\options\items\RadioPropertyItem',
$sgHeader
);
$this->assertEquals(
'structure_or_data',
$sgHeader->getName()
);
$this->assertEquals(
array(
'structure' => __('structure'),
'data' => __('data'),
'structure_and_data' => __('structure and data')
),
$sgHeader->getValues()
);
$property = array_shift($generalProperties);
$this->assertInstanceOf(
'PMA\libraries\properties\options\items\BoolPropertyItem',
$property
);
$this->assertEquals(
'caption',
$property->getName()
);
$this->assertEquals(
'Export table names',
$property->getText()
);
$property = array_shift($generalProperties);
$this->assertInstanceOf(
'PMA\libraries\properties\options\items\BoolPropertyItem',
$property
);
$this->assertEquals(
'headers',
$property->getName()
);
$this->assertEquals(
'Export table headers',
$property->getText()
);
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::exportHeader
*
* @return void
*/
public function testExportHeader()
{
$this->assertTrue(
$this->object->exportHeader()
);
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::exportFooter
*
* @return void
*/
public function testExportFooter()
{
$this->assertTrue(
$this->object->exportFooter()
);
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::exportDBHeader
*
* @return void
*/
public function testExportDBHeader()
{
$this->assertTrue(
$this->object->exportDBHeader('testDB')
);
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::exportDBFooter
*
* @return void
*/
public function testExportDBFooter()
{
$this->assertTrue(
$this->object->exportDBFooter('testDB')
);
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::exportDBCreate
*
* @return void
*/
public function testExportDBCreate()
{
$this->assertTrue(
$this->object->exportDBCreate('testDB', 'database')
);
}
/**
* Test for ExportMediaWiki::exportStructure
*
* @return void
*/
public function testExportStructure()
{
$dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$columns = array(
array(
'Null' => 'Yes',
'Field' => 'name1',
'Key' => 'PRI',
'Type' => 'set(abc)enum123',
'Default' => '',
'Extra' => ''
),
array(
'Null' => 'NO',
'Field' => 'fields',
'Key' => 'COMP',
'Type' => '',
'Default' => 'def',
'Extra' => 'ext'
)
);
$dbi->expects($this->at(0))
->method('getColumns')
->with('db', 'table')
->will($this->returnValue($columns));
$GLOBALS['dbi'] = $dbi;
$GLOBALS['mediawiki_caption'] = true;
$GLOBALS['mediawiki_headers'] = true;
ob_start();
$this->assertTrue(
$this->object->exportStructure(
'db', 'table', "\n", "example.com", "create_table", "test"
)
);
$result = ob_get_clean();
$this->assertEquals(
"\n<!--\n" .
"Table structure for `table`\n" .
"-->\n" .
"\n" .
"{| class=\"wikitable\" style=\"text-align:center;\"\n" .
"|+'''table'''\n" .
"|- style=\"background:#ffdead;\"\n" .
"! style=\"background:#ffffff\" | \n" .
" | name1\n" .
" | fields\n" .
"|-\n" .
"! Type\n" .
" | set(abc)enum123\n" .
" | \n" .
"|-\n" .
"! Null\n" .
" | Yes\n" .
" | NO\n" .
"|-\n" .
"! Default\n" .
" | \n" .
" | def\n" .
"|-\n" .
"! Extra\n" .
" | \n" .
" | ext\n" .
"|}\n\n",
$result
);
/**
* This case produces an error, should it be tested?
ob_start();
$this->assertTrue(
$this->object->exportStructure(
'db', 'table', "\n", "example.com", "defaultTest", "test"
)
);
$result = ob_get_clean();
*/
}
/**
* Test for PMA\libraries\plugins\export\ExportMediawiki::exportData
*
* @return void
*/
public function testExportData()
{
$dbi = $this->getMockBuilder('PMA\libraries\DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$dbi->expects($this->once())
->method('getColumnNames')
->with('db', 'table')
->will($this->returnValue(array('name1', 'fields')));
$dbi->expects($this->once())
->method('query')
->with('SELECT', null, PMA\libraries\DatabaseInterface::QUERY_UNBUFFERED)
->will($this->returnValue(true));
$dbi->expects($this->once())
->method('numFields')
->with(true)
->will($this->returnValue(2));
$dbi->expects($this->at(3))
->method('fetchRow')
->with(true)
->will($this->returnValue(array('r1', 'r2')));
$dbi->expects($this->at(4))
->method('fetchRow')
->with(true)
->will($this->returnValue(array('r3', '')));
$dbi->expects($this->at(4))
->method('fetchRow')
->with(true)
->will($this->returnValue(null));
$GLOBALS['dbi'] = $dbi;
$GLOBALS['mediawiki_caption'] = true;
$GLOBALS['mediawiki_headers'] = true;
ob_start();
$this->assertTrue(
$this->object->exportData(
'db', 'table', "\n", "example.com", "SELECT"
)
);
$result = ob_get_clean();
$this->assertEquals(
"\n<!--\n" .
"Table data for `table`\n" .
"-->\n" .
"\n" .
"{| class=\"wikitable sortable\" style=\"text-align:" .
"center;\"\n" .
"|+'''table'''\n" .
"|-\n" .
" ! name1\n" .
" ! fields\n" .
"|-\n" .
" | r1\n" .
" | r2\n" .
"|-\n" .
" | r3\n" .
" | \n" .
"|}\n\n",
$result
);
}
}