| 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 PMA_server_status_monitor.lib.php
*
* @package PhpMyAdmin-test
*/
/*
* Include to test.
*/
require_once 'libraries/Util.class.php';
require_once 'libraries/php-gettext/gettext.inc';
require_once 'libraries/url_generating.lib.php';
require_once 'libraries/ServerStatusData.class.php';
require_once 'libraries/server_status_monitor.lib.php';
require_once 'libraries/Theme.class.php';
require_once 'libraries/database_interface.inc.php';
require_once 'libraries/Message.class.php';
require_once 'libraries/sanitizing.lib.php';
require_once 'libraries/sqlparser.lib.php';
require_once 'libraries/js_escape.lib.php';
/**
* class PMA_ServerStatusMonitor_Test
*
* this class is for testing PMA_server_status_monitor.lib.php functions
*
* @package PhpMyAdmin-test
*/
class PMA_ServerStatusMonitor_Test extends PHPUnit_Framework_TestCase
{
/**
* Prepares environment for the test.
*
* @return void
*/
public $ServerStatusData;
/**
* Test for setUp
*
* @return void
*/
public function setUp()
{
//$_REQUEST
$_REQUEST['log'] = "index1";
$_REQUEST['pos'] = 3;
//$GLOBALS
$GLOBALS['cfg']['MaxRows'] = 10;
$GLOBALS['cfg']['ServerDefault'] = "server";
$GLOBALS['cfg']['RememberSorting'] = true;
$GLOBALS['cfg']['SQP'] = array();
$GLOBALS['cfg']['MaxCharactersInDisplayedSQL'] = 1000;
$GLOBALS['cfg']['ShowSQL'] = true;
$GLOBALS['cfg']['Server']['host'] = "localhost";
$GLOBALS['cfg']['ShowHint'] = true;
$GLOBALS['PMA_PHP_SELF'] = PMA_getenv('PHP_SELF');
$GLOBALS['replication_info']['master']['status'] = false;
$GLOBALS['replication_info']['slave']['status'] = false;
$GLOBALS['table'] = "table";
$GLOBALS['pmaThemeImage'] = 'image';
//$_SESSION
$_SESSION['PMA_Theme'] = PMA_Theme::load('./themes/pmahomme');
$_SESSION['PMA_Theme'] = new PMA_Theme();
//Mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
//this data is needed when PMA_ServerStatusData constructs
$server_status = array(
"Aborted_clients" => "0",
"Aborted_connects" => "0",
"Com_delete_multi" => "0",
"Com_create_function" => "0",
"Com_empty_query" => "0",
);
$server_variables= array(
"auto_increment_increment" => "1",
"auto_increment_offset" => "1",
"automatic_sp_privileges" => "ON",
"back_log" => "50",
"big_tables" => "OFF",
);
$fetchResult = array(
array(
"SHOW GLOBAL STATUS",
0,
1,
null,
0,
$server_status
),
array(
"SHOW GLOBAL VARIABLES",
0,
1,
null,
0,
$server_variables
),
array(
"SELECT concat('Com_', variable_name), variable_value "
. "FROM data_dictionary.GLOBAL_STATEMENTS",
0,
1,
null,
0,
$server_status
),
);
$dbi->expects($this->any())->method('fetchResult')
->will($this->returnValueMap($fetchResult));
$GLOBALS['dbi'] = $dbi;
$this->ServerStatusData = new PMA_ServerStatusData();
}
/**
* Test for PMA_getHtmlForMonitor
*
* @return void
* @group medium
*/
public function testPMAGetHtmlForMonitor()
{
//Call the test function
$html = PMA_getHtmlForMonitor($this->ServerStatusData);
//validate 1: PMA_getHtmlForTabLinks
$this->assertContains(
'<div class="tabLinks">',
$html
);
$this->assertContains(
__('Start Monitor'),
$html
);
$this->assertContains(
__('Settings'),
$html
);
$this->assertContains(
__('Done dragging (rearranging) charts'),
$html
);
//validate 2: PMA_getHtmlForSettingsDialog
$this->assertContains(
'<div class="popupContent settingsPopup">',
$html
);
$this->assertContains(
'<a href="#settingsPopup" class="popupLink">',
$html
);
$this->assertContains(
__('Enable charts dragging'),
$html
);
$this->assertContains(
'<option>3</option>',
$html
);
//validate 3: PMA_getHtmlForInstructionsDialog
$this->assertContains(
__('Monitor Instructions'),
$html
);
$this->assertContains(
'monitorInstructionsDialog',
$html
);
//validate 4: PMA_getHtmlForAddChartDialog
$this->assertContains(
'<div id="addChartDialog"',
$html
);
$this->assertContains(
'<div id="chartVariableSettings">',
$html
);
$this->assertContains(
'<option>Processes</option>',
$html
);
$this->assertContains(
'<option>Connections</option>',
$html
);
}
/**
* Test for PMA_getHtmlForClientSideDataAndLinks
*
* @return void
*/
public function testPMAGetHtmlForClientSideDataAndLinks()
{
//Call the test function
$html = PMA_getHtmlForClientSideDataAndLinks($this->ServerStatusData);
//validate 1: PMA_getHtmlForClientSideDataAndLinks
$from = '<form id="js_data" class="hide">'
. '<input type="hidden" name="server_time"';
$this->assertContains(
$from,
$html
);
//validate 2: inputs
$this->assertContains(
'<input type="hidden" name="is_superuser"',
$html
);
$this->assertContains(
'<input type="hidden" name="server_db_isLocal"',
$html
);
$this->assertContains(
'<div id="explain_docu" class="hide">',
$html
);
}
/**
* Test for PMA_getJsonForLogDataTypeSlow
*
* @return void
*/
public function testPMAGetJsonForLogDataTypeSlow()
{
//Mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$value = array(
'sql_text' => 'insert sql_text',
'#' => 'types',
);
$value2 = array(
'sql_text' => 'update sql_text',
'#' => 'types2',
);
$dbi->expects($this->at(1))->method('fetchAssoc')
->will($this->returnValue($value));
$dbi->expects($this->at(2))->method('fetchAssoc')
->will($this->returnValue($value2));
$dbi->expects($this->at(3))->method('fetchAssoc')
->will($this->returnValue(false));
$GLOBALS['dbi'] = $dbi;
//Call the test function
$start = 0;
$end = 10;
$ret = PMA_getJsonForLogDataTypeSlow($start, $end);
$result_rows = array(
array('sql_text' => 'insert sql_text', '#' => 'types'),
array('sql_text' => 'update sql_text', '#' => 'types2')
);
$result_sum = array('insert' =>0, 'TOTAL' =>0, 'update' => 0);
$this->assertEquals(
2,
$ret['numRows']
);
$this->assertEquals(
$result_rows,
$ret['rows']
);
$this->assertEquals(
$result_sum,
$ret['sum']
);
}
/**
* Test for PMA_getJsonForLogDataTypeGeneral
*
* @return void
*/
public function testPMAGetJsonForLogDataTypeGeneral()
{
$_REQUEST['limitTypes'] = true;
//Mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$value = array(
'sql_text' => 'insert sql_text',
'#' => 'types',
'argument' => 'argument argument2',
);
$value2 = array(
'sql_text' => 'update sql_text',
'#' => 'types2',
'argument' => 'argument3 argument4',
);
$dbi->expects($this->at(1))->method('fetchAssoc')
->will($this->returnValue($value));
$dbi->expects($this->at(2))->method('fetchAssoc')
->will($this->returnValue($value2));
$dbi->expects($this->at(3))->method('fetchAssoc')
->will($this->returnValue(false));
$GLOBALS['dbi'] = $dbi;
//Call the test function
$start = 0;
$end = 10;
$ret = PMA_getJsonForLogDataTypeGeneral($start, $end);
$result_rows = array(
$value,
$value2,
);
$result_sum = array('argument' =>0, 'TOTAL' =>0, 'argument3' => 0);
$this->assertEquals(
2,
$ret['numRows']
);
$this->assertEquals(
$result_rows,
$ret['rows']
);
$this->assertEquals(
$result_sum,
$ret['sum']
);
}
/**
* Test for PMA_getJsonForLoggingVars
*
* @return void
*/
public function testPMAGetJsonForLoggingVars()
{
$_REQUEST['varName'] = "varName";
//Mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$value = array(
'sql_text' => 'insert sql_text',
'#' => 'types',
'argument' => 'argument argument2',
);
$dbi->expects($this->any())->method('fetchResult')
->will($this->returnValue($value));
$GLOBALS['dbi'] = $dbi;
//Call the test function
$ret = PMA_getJsonForLoggingVars();
//validate that, the result is the same as fetchResult
$this->assertEquals(
$value,
$ret
);
}
/**
* Test for PMA_getJsonForQueryAnalyzer
*
* @return void
*/
public function testPMAGetJsonForQueryAnalyzer()
{
$_REQUEST['database'] = "database";
$_REQUEST['query'] = 'query';
$GLOBALS['server'] = 'server';
$GLOBALS['cached_affected_rows'] = 'cached_affected_rows';
$_SESSION['cache']['server_server']['profiling_supported'] = true;
//Mock DBI
$dbi = $this->getMockBuilder('PMA_DatabaseInterface')
->disableOriginalConstructor()
->getMock();
$value = array(
'sql_text' => 'insert sql_text',
'#' => 'types',
'argument' => 'argument argument2',
);
$dbi->expects($this->at(4))->method('fetchAssoc')
->will($this->returnValue($value));
$dbi->expects($this->at(5))->method('fetchAssoc')
->will($this->returnValue(false));
$GLOBALS['dbi'] = $dbi;
//Call the test function
$ret = PMA_getJsonForQueryAnalyzer();
$this->assertEquals(
'cached_affected_rows',
$ret['affectedRows']
);
$this->assertEquals(
array(),
$ret['profiling']
);
$this->assertEquals(
array($value),
$ret['explain']
);
}
}