', $html ); } /** * Test for getJsonForLogDataTypeSlow * * @return void */ public function testPMAGetJsonForLogDataTypeSlow() { //Mock DBI $dbi = $this->getMockBuilder('PhpMyAdmin\DatabaseInterface') ->disableOriginalConstructor() ->getMock(); $value = [ 'sql_text' => 'insert sql_text', '#' => 11, ]; $value2 = [ 'sql_text' => 'update sql_text', '#' => 10, ]; $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 = $this->statusMonitor->getJsonForLogDataTypeSlow($start, $end); $result_rows = [ ['sql_text' => 'insert sql_text', '#' => 11], ['sql_text' => 'update sql_text', '#' => 10] ]; $result_sum = ['insert' => 11, 'TOTAL' => 21, 'update' => 10]; $this->assertEquals( 2, $ret['numRows'] ); $this->assertEquals( $result_rows, $ret['rows'] ); $this->assertEquals( $result_sum, $ret['sum'] ); } /** * Test for getJsonForLogDataTypeGeneral * * @return void */ public function testPMAGetJsonForLogDataTypeGeneral() { $_REQUEST['limitTypes'] = true; //Mock DBI $dbi = $this->getMockBuilder('PhpMyAdmin\DatabaseInterface') ->disableOriginalConstructor() ->getMock(); $value = [ 'sql_text' => 'insert sql_text', '#' => 10, 'argument' => 'argument argument2', ]; $value2 = [ 'sql_text' => 'update sql_text', '#' => 11, '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 = $this->statusMonitor->getJsonForLogDataTypeGeneral($start, $end); $result_rows = [ $value, $value2, ]; $result_sum = ['argument' => 10, 'TOTAL' => 21, 'argument3' => 11]; $this->assertEquals( 2, $ret['numRows'] ); $this->assertEquals( $result_rows, $ret['rows'] ); $this->assertEquals( $result_sum, $ret['sum'] ); } /** * Test for getJsonForLoggingVars * * @return void */ public function testPMAGetJsonForLoggingVars() { $_REQUEST['varName'] = "varName"; //Mock DBI $dbi = $this->getMockBuilder('PhpMyAdmin\DatabaseInterface') ->disableOriginalConstructor() ->getMock(); $value = [ 'sql_text' => 'insert sql_text', '#' => 22, 'argument' => 'argument argument2', ]; $dbi->expects($this->any())->method('fetchResult') ->will($this->returnValue($value)); $GLOBALS['dbi'] = $dbi; //Call the test function $ret = $this->statusMonitor->getJsonForLoggingVars(); //validate that, the result is the same as fetchResult $this->assertEquals( $value, $ret ); } /** * Test for 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('PhpMyAdmin\DatabaseInterface') ->disableOriginalConstructor() ->getMock(); $value = [ 'sql_text' => 'insert sql_text', '#' => 33, '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 = $this->statusMonitor->getJsonForQueryAnalyzer(); $this->assertEquals( 'cached_affected_rows', $ret['affectedRows'] ); $this->assertEquals( [], $ret['profiling'] ); $this->assertEquals( [$value], $ret['explain'] ); } }