Viewing file:  PMA_transformation_test.php (8.65 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* tests for transformation wrappers
*
* @package PhpMyAdmin-test
*/
/*
* Include to test.
*/
require_once 'libraries/transformations.lib.php';
require_once 'libraries/Util.class.php';
require_once 'libraries/database_interface.inc.php';
require_once 'libraries/Tracker.class.php';
require_once 'libraries/relation.lib.php';
require_once 'libraries/Theme.class.php';
/**
* tests for transformation wrappers
*
* @package PhpMyAdmin-test
*/
class PMA_Transformation_Test extends PHPUnit_Framework_TestCase
{
/**
* Set up global environment.
*
* @return void
*/
public function setup()
{
$GLOBALS['table'] = 'table';
$GLOBALS['db'] = 'db';
$_SESSION['PMA_Theme'] = PMA_Theme::load('./themes/pmahomme');
$GLOBALS['cfg'] = array(
'ServerDefault' => 1,
'ActionLinksMode' => 'icons',
);
$GLOBALS['server'] = 1;
$GLOBALS['cfg']['Server']['pmadb'] = 'pmadb';
$GLOBALS['cfg']['Server']['user'] = 'user';
$GLOBALS['cfg']['Server']['bookmarktable'] = '';
$GLOBALS['cfg']['Server']['relation'] = '';
$GLOBALS['cfg']['Server']['table_info'] = '';
$GLOBALS['cfg']['Server']['table_coords'] = '';
$GLOBALS['cfg']['Server']['column_info'] = 'column_info';
$GLOBALS['cfg']['DBG']['sql'] = false;
// need to clear relation test cache
unset($_SESSION['relation']);
}
/**
* Test for parsing options.
*
* @param string $input String to parse
* @param array $expected Expected result
*
* @return void
*
* @dataProvider getOptionsData
*/
public function testGetOptions($input, $expected)
{
$this->assertEquals(
$expected,
PMA_Transformation_getOptions($input)
);
}
/**
* Data provided for parsing options
*
* @return array with test data
*/
public function getOptionsData()
{
return array(
array("option1 , option2 ", array('option1 ', ' option2 ')),
array("'option1' ,' option2' ", array('option1', ' option2')),
array("'2,3' ,' ,, option ,,' ", array('2,3', ' ,, option ,,')),
array("'',,", array('', '', '')),
array('', array()),
);
}
/**
* Test for getting available types.
*
* @return void
*/
public function testGetTypes()
{
$this->assertEquals(
array (
'mimetype' => array (
'Application/Octetstream' => 'Application/Octetstream',
'Image/JPEG' => 'Image/JPEG',
'Image/PNG' => 'Image/PNG',
'Text/Plain' => 'Text/Plain',
'Text/Octetstream' => 'Text/Octetstream'
),
'transformation' => array (
0 => 'Application/Octetstream: Download',
1 => 'Application/Octetstream: Hex',
2 => 'Image/JPEG: Inline',
3 => 'Image/JPEG: Link',
4 => 'Image/PNG: Inline',
5 => 'Text/Octetstream: Sql',
6 => 'Text/Plain: Bool2text',
7 => 'Text/Plain: Dateformat',
8 => 'Text/Plain: External',
9 => 'Text/Plain: Formatted',
10 => 'Text/Plain: Imagelink',
11 => 'Text/Plain: Json',
12 => 'Text/Plain: Sql',
13 => 'Text/Plain: Xml',
14 => 'Text/Plain: Link',
15 => 'Text/Plain: Longtoipv4',
16 => 'Text/Plain: Preappend',
17 => 'Text/Plain: Substring',
),
'transformation_file' => array (
0 => 'output/Application_Octetstream_Download.class.php',
1 => 'output/Application_Octetstream_Hex.class.php',
2 => 'output/Image_JPEG_Inline.class.php',
3 => 'output/Image_JPEG_Link.class.php',
4 => 'output/Image_PNG_Inline.class.php',
5 => 'output/Text_Octetstream_Sql.class.php',
6 => 'output/Text_Plain_Bool2text.class.php',
7 => 'output/Text_Plain_Dateformat.class.php',
8 => 'output/Text_Plain_External.class.php',
9 => 'output/Text_Plain_Formatted.class.php',
10 => 'output/Text_Plain_Imagelink.class.php',
11 => 'output/Text_Plain_Json.class.php',
12 => 'output/Text_Plain_Sql.class.php',
13 => 'output/Text_Plain_Xml.class.php',
14 => 'Text_Plain_Link.class.php',
15 => 'Text_Plain_Longtoipv4.class.php',
16 => 'Text_Plain_Preappend.class.php',
17 => 'Text_Plain_Substring.class.php',
),
'input_transformation' => array(
'Image/JPEG: Upload',
'Text/Plain: Fileupload',
'Text/Plain: JsonEditor',
'Text/Plain: Regexvalidation',
'Text/Plain: SqlEditor',
'Text/Plain: XmlEditor',
'Text/Plain: Link',
'Text/Plain: Longtoipv4',
'Text/Plain: Preappend',
'Text/Plain: Substring',
),
'input_transformation_file' => array(
'input/Image_JPEG_Upload.class.php',
'input/Text_Plain_Fileupload.class.php',
'input/Text_Plain_JsonEditor.class.php',
'input/Text_Plain_Regexvalidation.class.php',
'input/Text_Plain_SqlEditor.class.php',
'input/Text_Plain_XmlEditor.class.php',
'Text_Plain_Link.class.php',
'Text_Plain_Longtoipv4.class.php',
'Text_Plain_Preappend.class.php',
'Text_Plain_Substring.class.php',
),
),
PMA_getAvailableMIMEtypes()
);
}
/**
* Tests getting mime types for table
*
* @return void
*/
public function testGetMime()
{
$_SESSION['relation'][$GLOBALS['server']]['commwork'] = true;
$_SESSION['relation'][$GLOBALS['server']]['db'] = "pmadb";
$_SESSION['relation'][$GLOBALS['server']]['column_info'] = "column_info";
$_SESSION['relation'][$GLOBALS['server']]['trackingwork'] = false;
$this->assertEquals(
array(
'o' => array(
'column_name' => 'o',
'mimetype' => 'Text/plain',
'transformation' => 'Sql',
'transformation_options' => '',
'input_transformation' => 'regex',
'input_transformation_options' => '/pma/i',
),
'col' => array(
'column_name' => 'col',
'mimetype' => 'T',
'transformation' => 'o/P',
'transformation_options' => '',
'input_transformation' => 'i/p',
'input_transformation_options' => '',
),
),
PMA_getMIME('pma_test', 'table1')
);
}
/**
* Test for PMA_clearTransformations
*
* @return void
*/
public function testClearTransformations()
{
// Mock dbi
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$dbi->expects($this->any())
->method('tryQuery')
->will($this->returnValue(true));
$GLOBALS['dbi'] = $dbi;
// Case 1 : no configuration storage
$actual = PMA_clearTransformations('db');
$this->assertEquals(
false,
$actual
);
$_SESSION['relation'][$GLOBALS['server']]['column_info'] = "column_info";
$_SESSION['relation'][$GLOBALS['server']]['db'] = "pmadb";
// Case 2 : database delete
$actual = PMA_clearTransformations('db');
$this->assertEquals(
true,
$actual
);
// Case 3 : table delete
$actual = PMA_clearTransformations('db', 'table');
$this->assertEquals(
true,
$actual
);
// Case 4 : column delete
$actual = PMA_clearTransformations('db', 'table', 'col');
$this->assertEquals(
true,
$actual
);
}
}
?>
|