/**
* Test for PMA_getJsonForLogDataTypeSlow
*
* @return void
*/
public function testPMAGetJsonForLogDataTypeSlow()
{
//Mock DBI
$dbi = $this->getMockBuilder('PMA\\libraries\\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']);
}
case 'chartgrid':
// Data for the monitor
$ret = PMA_getJsonForChartingData();
PMA_Response::getInstance()->addJSON('message', $ret);
exit;
}
}
if (isset($_REQUEST['log_data'])) {
if (PMA_MYSQL_INT_VERSION < 50106) {
// Table logging is only available since 5.1.6
exit('""');
}
$start = intval($_REQUEST['time_start']);
$end = intval($_REQUEST['time_end']);
if ($_REQUEST['type'] == 'slow') {
$return = PMA_getJsonForLogDataTypeSlow($start, $end);
PMA_Response::getInstance()->addJSON('message', $return);
exit;
}
if ($_REQUEST['type'] == 'general') {
$return = PMA_getJsonForLogDataTypeGeneral($start, $end);
PMA_Response::getInstance()->addJSON('message', $return);
exit;
}
}
if (isset($_REQUEST['logging_vars'])) {
$loggingVars = PMA_getJsonForLoggingVars();
PMA_Response::getInstance()->addJSON('message', $loggingVars);
exit;
}
if (isset($_REQUEST['query_analyzer'])) {
