/**
  * Test for PMA_getTableDropQueryAndMessage
  *
  * @return void
  */
 public function testPMAGetTableDropQueryAndMessage()
 {
     $current_table = array('TABLE_ROWS' => 3, 'TABLE_NAME' => 'name1', 'ENGINE' => 'ENGINE1');
     $table_is_view = false;
     list($drop_query, $drop_message) = PMA_getTableDropQueryAndMessage($table_is_view, $current_table);
     //$drop_query
     $ret = "DROP TABLE `name1`";
     $this->assertEquals($ret, $drop_query);
     //$drop_message
     $ret = "Table name1 has been dropped.";
     $this->assertEquals($ret, $drop_message);
 }
Beispiel #2
0
    if ($table_is_view) {
        $hidden_fields[] = '<input type="hidden" name="views[]" value="' . htmlspecialchars($current_table['TABLE_NAME']) . '" />';
    }
    /*
     * Always activate links for Browse, Search and Empty, even if
     * the icons are greyed, because
     * 1. for views, we don't know the number of rows at this point
     * 2. for tables, another source could have populated them since the
     *    page was generated
     *
     * I could have used the PHP ternary conditional operator but I find
     * the code easier to read without this operator.
     */
    list($browse_table, $search_table, $browse_table_label, $empty_table, $tracking_icon) = PMA_getHtmlForActionLinks($current_table, $table_is_view, $tbl_url_query, $titles, $truename, $db_is_information_schema, $url_query);
    if (!$db_is_information_schema) {
        list($drop_query, $drop_message) = PMA_getTableDropQueryAndMessage($table_is_view, $current_table);
    }
    if ($num_columns > 0 && $num_tables > $num_columns && $row_count % $num_columns == 0) {
        $row_count = 1;
        $odd_row = true;
        $response->addHTML('</tr></tbody></table>');
        $response->addHTML(PMA_tableHeader(false, $server_slave_status));
    }
    list($do, $ignored) = PMA_getServerSlaveStatus($server_slave_status, $truename);
    list($html_output, $odd_row) = PMA_getHtmlForStructureTableRow($i, $odd_row, $table_is_view, $current_table, $browse_table_label, $tracking_icon, $server_slave_status, $browse_table, $tbl_url_query, $search_table, $db_is_information_schema, $titles, $empty_table, $drop_query, $drop_message, $collation, $formatted_size, $unit, $overhead, isset($create_time) ? $create_time : '', isset($update_time) ? $update_time : '', isset($check_time) ? $check_time : '', $is_show_stats, $ignored, $do, $colspan_for_structure);
    $response->addHTML($html_output);
}
// end foreach
// Show Summary
$response->addHTML('</tbody>');
$response->addHTML(PMA_getHtmlBodyForTableSummary($num_tables, $server_slave_status, $db_is_information_schema, $sum_entries, $db_collation, $is_show_stats, $sum_size, $overhead_size, $create_time_all, $update_time_all, $check_time_all, $sum_row_count_pre));