/** * 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; } }