php PMA_executeSqlQuery类(方法)实例源码

/**
  * Test for PMA_executeSqlQuery
  *
  * @return void
  */
 public function testExecuteSqlQueryWithTryQuery()
 {
     $query = array('SELECT 1', 'SELECT 2');
     $GLOBALS['sql_query'] = 'SELECT';
     $GLOBALS['cfg']['IgnoreMultiSubmitErrors'] = true;
     $_REQUEST['submit_type'] = '';
     $dbi = $this->getMockBuilder('PMA_DatabaseInterface')->disableOriginalConstructor()->getMock();
     $dbi->expects($this->at(0))->method('tryQuery')->with('SELECT 1')->will($this->returnValue(true));
     $dbi->expects($this->at(1))->method('affectedRows')->will($this->returnValue(2));
     $dbi->expects($this->at(2))->method('insertId')->will($this->returnValue(1));
     $dbi->expects($this->at(5))->method('tryQuery')->with('SELECT 2')->will($this->returnValue(false));
     $dbi->expects($this->once())->method('getError')->will($this->returnValue('err'));
     $dbi->expects($this->exactly(2))->method('getWarnings')->will($this->returnValue(array()));
     $GLOBALS['dbi'] = $dbi;
     $result = PMA_executeSqlQuery(array(), $query);
     $this->assertEquals(array('sql_query' => 'SELECT'), $result[0]);
     $this->assertEquals(2, $result[1]);
     $this->assertInstanceOf('PMA_Message', $result[2][0]);
     $msg = $result[2][0];
     $reflectionMsg = new ReflectionProperty('PMA_Message', 'params');
     $reflectionMsg->setAccessible(true);
     $this->assertEquals(array(2), $reflectionMsg->getValue($msg));
     $this->assertEquals(array(), $result[3]);
     $this->assertEquals(array('err'), $result[4]);
     $this->assertEquals('SELECT', $result[5]);
 }

// Note: logic passes here for inline edit
    $message = PMA_Message::success(__('No change'));
    $active_page = $goto_include;
    include '' . PMA_securePath($goto_include);
    exit;
}
unset($multi_edit_columns, $is_insertignore);
// If there is a request for SQL previewing.
if (isset($_REQUEST['preview_sql'])) {
    PMA_previewSQL($query);
}
/**
 * Executes the sql query and get the result, then move back to the calling
 * page
 */
list($url_params, $total_affected_rows, $last_messages, $warning_messages, $error_messages, $return_to_sql_query) = PMA_executeSqlQuery($url_params, $query);
if ($is_insert && (count($value_sets) > 0 || $row_skipped)) {
    $message = PMA_Message::getMessageForInsertedRows($total_affected_rows);
    $unsaved_values = array_values($unsaved_values);
} else {
    $message = PMA_Message::getMessageForAffectedRows($total_affected_rows);
}
if ($row_skipped) {
    $goto_include = 'tbl_change.php';
    $message->addMessages($insert_errors, '<br />');
    $message->isError(true);
}
$message->addMessages($last_messages, '<br />');
if (!empty($warning_messages)) {
    $message->addMessages($warning_messages, '<br />');
    $message->isError(true);

//
    // Note: logic passes here for inline edit
    $message = PMA_Message::success(__('No change'));
    $active_page = $goto_include;
    include '' . PMA_securePath($goto_include);
    exit;
}
unset($multi_edit_colummns, $is_insertignore);

/**
 * Executes the sql query and get the result, then move back to the calling
 * page
 */
list ($url_params, $total_affected_rows, $last_messages, $warning_messages,
    $error_messages, $return_to_sql_query)
        = PMA_executeSqlQuery($url_params, $query);

if ($is_insert && count($value_sets) > 0) {
    $message = PMA_Message::getMessageForInsertedRows($total_affected_rows);
} else {
    $message = PMA_Message::getMessageForAffectedRows($total_affected_rows);
}

$message->addMessages($last_messages, '<br />');

if (! empty($warning_messages)) {
    $message->addMessages($warning_messages, '<br />');
    $message->isError(true);
}
if (! empty($error_messages)) {
    $message->addMessages($error_messages);