/**
* Test for PMA_getJsonForLogDataTypeGeneral
*
* @return void
*/
public function testPMAGetJsonForLogDataTypeGeneral()
{
$_REQUEST['limitTypes'] = true;
//Mock DBI
$dbi = $this->getMockBuilder('PMA\\libraries\\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']);
}
}
}
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'])) {
$return = PMA_getJsonForQueryAnalyzer();
PMA_Response::getInstance()->addJSON('message', $return);
exit;
}
}
