phpmyadmin/resources/js/database/operations.ts

import $ from 'jquery';
import { AJAX } from '../modules/ajax.ts';
import { emptyCheckTheField, prepareForAjaxRequest } from '../modules/functions.ts';
import { Navigation } from '../modules/navigation.ts';
import { CommonParams } from '../modules/common.ts';
import { ajaxShowMessage } from '../modules/ajax-message.ts';
import getJsConfirmCommonParam from '../modules/functions/getJsConfirmCommonParam.ts';
import { escapeHtml } from '../modules/functions/escape.ts';
import refreshMainContent from '../modules/functions/refreshMainContent.ts';

/**
 * @fileoverview    function used in server privilege pages
 * @name            Database Operations
 *
 * @requires    jQueryUI
 */

/**
 * Ajax event handlers here for /database/operations
 *
 * Actions Ajaxified here:
 * Rename Database
 * Copy Database
 * Change Charset
 * Drop Database
 */

/**
 * Unbind all event handlers before tearing down a page
 */
AJAX.registerTeardown('database/operations.js', function () {
    $(document).off('submit', '#rename_db_form.ajax');
    $(document).off('submit', '#copy_db_form.ajax');
    $(document).off('submit', '#change_db_charset_form.ajax');
    $(document).off('click', '#drop_db_anchor.ajax');
});

AJAX.registerOnload('database/operations.js', function () {
    /**
     * Ajax event handlers for 'Rename Database'
     */
    $(document).on('submit', '#rename_db_form.ajax', function (event) {
        event.preventDefault();

        if (emptyCheckTheField(this, 'newname')) {
            ajaxShowMessage(window.Messages.strFormEmpty, false, 'error');

            return false;
        }

        const oldDbName = CommonParams.get('db');
        const newDbName = $('#new_db_name').val();

        if (newDbName === oldDbName) {
            ajaxShowMessage(window.Messages.strDatabaseRenameToSameName, false, 'error');

            return false;
        }

        const $form = $(this);

        const question = escapeHtml('CREATE DATABASE ' + newDbName + ' / DROP DATABASE ' + oldDbName);

        prepareForAjaxRequest($form);

        $form.confirm(question, $form.attr('action'), function (url) {
            ajaxShowMessage(window.Messages.strRenamingDatabases, false);
            $.post(url, $('#rename_db_form').serialize() + CommonParams.get('arg_separator') + 'is_js_confirmed=1', function (data) {
                if (typeof data !== 'undefined' && data.success === true) {
                    ajaxShowMessage(data.message);
                    Navigation.update(CommonParams.set('db', data.newname));
                    Navigation.reload(function () {
                        $('#pma_navigation_tree')
                            .find('a:not(\'.expander\')')
                            .each(function () {
                                const $thisAnchor = $(this);
                                if ($thisAnchor.text() === data.newname) {
                                    // simulate a click on the new db name
                                    // in navigation
                                    $thisAnchor.trigger('click');
                                }
                            });
                    });
                } else {
                    ajaxShowMessage(data.error, false);
                }
            }); // end $.post()
        });
    }); // end Rename Database

    /**
     * Ajax Event Handler for 'Copy Database'
     */
    $(document).on('submit', '#copy_db_form.ajax', function (event) {
        event.preventDefault();

        if (emptyCheckTheField(this, 'newname')) {
            ajaxShowMessage(window.Messages.strFormEmpty, false, 'error');

            return false;
        }

        ajaxShowMessage(window.Messages.strCopyingDatabase, false);
        const $form = $(this);
        prepareForAjaxRequest($form);
        $.post($form.attr('action'), $form.serialize(), function (data) {
            // use messages that stay on screen
            $('.alert-success, .alert-danger').fadeOut();
            if (typeof data !== 'undefined' && data.success === true) {
                if ($('#checkbox_switch').is(':checked')) {
                    Navigation.update(CommonParams.set('db', data.newname));
                    refreshMainContent(false);
                    AJAX.callback = () => {
                        ajaxShowMessage(data.message);
                    };
                } else {
                    Navigation.update(CommonParams.set('db', data.db));
                    ajaxShowMessage(data.message);
                }

                Navigation.reload();
            } else {
                ajaxShowMessage(data.error, false);
            }
        }); // end $.post()
    }); // end copy database

    /**
     * Change tables columns visible only if change tables is checked
     */
    $('#span_change_all_tables_columns_collations').hide();
    $('#checkbox_change_all_tables_collations').on('click', function () {
        $('#span_change_all_tables_columns_collations').toggle();
    });

    /**
     * Ajax Event handler for 'Change Charset' of the database
     */
    $(document).on('submit', '#change_db_charset_form.ajax', function (event) {
        event.preventDefault();
        const $form = $(this);
        prepareForAjaxRequest($form);
        ajaxShowMessage(window.Messages.strChangingCharset);
        $.post($form.attr('action'), $form.serialize(), function (data) {
            if (typeof data !== 'undefined' && data.success === true) {
                ajaxShowMessage(data.message);
            } else {
                ajaxShowMessage(data.error, false);
            }
        }); // end $.post()
    }); // end change charset

    /**
     * Ajax event handlers for Drop Database
     */
    $(document).on('click', '#drop_db_anchor.ajax', function (event) {
        event.preventDefault();
        const $link = $(this);
        /**
         * @var {string} question String containing the question to be asked for confirmation
         */
        let question = window.Messages.strDropDatabaseStrongWarning + ' ';
        question += window.sprintf(
            window.Messages.strDoYouReally,
            'DROP DATABASE `' + escapeHtml(CommonParams.get('db') + '`')
        );

        const params = getJsConfirmCommonParam(this, $link.getPostData());

        $(this).confirm(question, $(this).attr('href'), function (url) {
            ajaxShowMessage(window.Messages.strProcessingRequest);
            $.post(url, params, function (data) {
                if (typeof data !== 'undefined' && data.success) {
                    // Database deleted successfully, refresh both the frames
                    Navigation.reload();
                    Navigation.update(CommonParams.set('db', ''));
                    refreshMainContent('index.php?route=/server/databases');
                    AJAX.callback = () => {
                        ajaxShowMessage(data.message);
                    };
                } else {
                    ajaxShowMessage(data.error, false);
                }
            });
        });
    });
});