| Server IP : 62.109.13.187 / Your IP : 216.73.216.11 [ Web Server : Apache/2.4.6 (CentOS) mpm-itk/2.4.7-04 OpenSSL/1.0.2k-fips PHP/8.2.28 System : Linux robothost.ru 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : mosrembit ( 6064) PHP Version : 8.2.28 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/phpMyAdmin/test/libraries/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Tests for libraries/tbl_chart.lib.php
*
* @package PhpMyAdmin-test
*/
/*
* Include to test.
*/
require_once 'libraries/tbl_chart.lib.php';
require_once 'libraries/Util.class.php';
require_once 'libraries/Index.class.php';
require_once 'libraries/Message.class.php';
require_once 'libraries/database_interface.inc.php';
require_once 'libraries/php-gettext/gettext.inc';
require_once 'libraries/relation.lib.php';
require_once 'libraries/url_generating.lib.php';
require_once 'libraries/Theme.class.php';
require_once 'libraries/sanitizing.lib.php';
/**
* Tests for libraries/tbl_chart.lib.php
*
* @package PhpMyAdmin-test
*/
class PMA_TblChartTest extends PHPUnit_Framework_TestCase
{
/**
* Setup function for test cases
*
* @access protected
* @return void
*/
protected function setUp()
{
/**
* SET these to avoid undefined index error
*/
$GLOBALS['server'] = 1;
$GLOBALS['cfg']['Server']['pmadb'] = '';
$GLOBALS['pmaThemeImage'] = 'theme/';
$GLOBALS['cfg']['ServerDefault'] = "server";
$GLOBALS['cfg']['ShowHint'] = true;
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$GLOBALS['dbi'] = $dbi;
//$_SESSION
$_SESSION['PMA_Theme'] = PMA_Theme::load('./themes/pmahomme');
$_SESSION['PMA_Theme'] = new PMA_Theme();
}
/**
* Tests for PMA_getHtmlForPmaTokenAndUrlQuery() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForPmaTokenAndUrlQuery()
{
$url_query = "url_query";
$_SESSION[' PMA_token '] = "PMA_token";
$html = PMA_getHtmlForPmaTokenAndUrlQuery($url_query);
$this->assertContains(
$_SESSION[' PMA_token '],
$html
);
$this->assertContains(
$url_query,
$html
);
}
/**
* Tests for PMA_getHtmlForChartTypeOptions() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForChartTypeOptions()
{
$html = PMA_getHtmlForChartTypeOptions();
$this->assertContains(
_pgettext('Chart type', 'Bar'),
$html
);
$this->assertContains(
_pgettext('Chart type', 'Column'),
$html
);
$this->assertContains(
_pgettext('Chart type', 'Line'),
$html
);
$this->assertContains(
_pgettext('Chart type', 'Spline'),
$html
);
$this->assertContains(
_pgettext('Chart type', 'Area'),
$html
);
$this->assertContains(
_pgettext('Chart type', 'Pie'),
$html
);
$this->assertContains(
_pgettext('Chart type', 'Timeline'),
$html
);
}
/**
* Tests for PMA_getHtmlForStackedOption() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForStackedOption()
{
$html = PMA_getHtmlForStackedOption();
$this->assertContains(
__('Stacked'),
$html
);
}
/**
* Tests for PMA_getHtmlForChartXAxisOptions() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForChartXAxisOptions()
{
$keys = array(
"x1" => "value1",
"x2" => "value2",
);
$yaxis = null;
$html = PMA_getHtmlForChartXAxisOptions($keys, $yaxis);
$this->assertContains(
__('X-Axis:'),
$html
);
//x-Axis values
$this->assertContains(
"x1",
$html
);
$this->assertContains(
"value1",
$html
);
$this->assertContains(
"x2",
$html
);
$this->assertContains(
"value2",
$html
);
}
/**
* Tests for PMA_getHtmlForTableChartDisplay() method.
*
* @return void
* @test
*/
public function testPMAGetHtmlForTableChartDisplay()
{
$_SESSION[' PMA_token '] = "PMA_token";
$_SESSION['tmpval']['pos'] = "pos";
$_SESSION['tmpval']['max_rows'] = "all";
$GLOBALS['cfg']['MaxRows'] = 10;
$url_query = "url_query";
$url_params = array("url" => "url_params");
$keys = array(
"x1" => "value1",
"x2" => "value2",
);
$fields_meta = array(
"x1" => new Mock_Meta("type1"),
"x2" => new Mock_Meta("type3"),
);
$numeric_types = array("type1", "type2");
$numeric_column_count = 2;
$sql_query = "sql_query";
$yaxis = null;
$html = PMA_getHtmlForTableChartDisplay(
$url_query, $url_params, $keys,
$fields_meta, $numeric_types,
$numeric_column_count, $sql_query
);
//case 1: PMA_getHtmlForPmaTokenAndUrlQuery
$this->assertContains(
PMA_getHtmlForPmaTokenAndUrlQuery($url_query),
$html
);
//case 2: PMA_getHtmlForPmaTokenAndUrlQuery
$this->assertContains(
PMA_URL_getHiddenInputs($url_params),
$html
);
//case 3: options
$this->assertContains(
PMA_getHtmlForChartTypeOptions(),
$html
);
$this->assertContains(
PMA_getHtmlForStackedOption(),
$html
);
//case 4: options
$this->assertContains(
__('Chart title'),
$html
);
//case 5: options
$this->assertContains(
PMA_getHtmlForChartXAxisOptions($keys, $yaxis),
$html
);
$this->assertContains(
PMA_getHtmlForChartSeriesOptions(
$keys, $fields_meta, $numeric_types, $yaxis, $numeric_column_count
),
$html
);
//case 6: PMA_getHtmlForDateTimeCols
$this->assertContains(
PMA_getHtmlForDateTimeCols($keys, $fields_meta),
$html
);
$this->assertContains(
PMA_getHtmlForTableAxisLabelOptions($yaxis, $keys),
$html
);
$this->assertContains(
PMA_getHtmlForStartAndNumberOfRowsOptions($sql_query),
$html
);
$this->assertContains(
PMA_getHtmlForChartAreaDiv(),
$html
);
}
}
/**
* Mock class for Meta Field
*
* @package PhpMyAdmin-test
*/
class Mock_Meta
{
var $type;
/**
* Constructor
*
* @param string $type1 meta type
*/
public function __construct($type1)
{
$this->type = $type1;
}
}
?>