aboutsummaryrefslogtreecommitdiff
path: root/srcs/phpmyadmin/js/console.js
diff options
context:
space:
mode:
Diffstat (limited to 'srcs/phpmyadmin/js/console.js')
-rw-r--r--srcs/phpmyadmin/js/console.js1509
1 files changed, 0 insertions, 1509 deletions
diff --git a/srcs/phpmyadmin/js/console.js b/srcs/phpmyadmin/js/console.js
deleted file mode 100644
index 2ec580e..0000000
--- a/srcs/phpmyadmin/js/console.js
+++ /dev/null
@@ -1,1509 +0,0 @@
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * Used in or for console
- *
- * @package phpMyAdmin-Console
- */
-
-/* global debugSQLInfo */ // libraries/classes/Footer.php
-
-/**
- * Console object
- */
-var Console = {
- /**
- * @var object, jQuery object, selector is '#pma_console>.content'
- * @access private
- */
- $consoleContent: null,
- /**
- * @var object, jQuery object, selector is '#pma_console .content',
- * used for resizer
- * @access private
- */
- $consoleAllContents: null,
- /**
- * @var object, jQuery object, selector is '#pma_console .toolbar'
- * @access private
- */
- $consoleToolbar: null,
- /**
- * @var object, jQuery object, selector is '#pma_console .template'
- * @access private
- */
- $consoleTemplates: null,
- /**
- * @var object, jQuery object, form for submit
- * @access private
- */
- $requestForm: null,
- /**
- * @var object, contain console config
- * @access private
- */
- config: null,
- /**
- * @var bool, if console element exist, it'll be true
- * @access public
- */
- isEnabled: false,
- /**
- * @var bool, make sure console events bind only once
- * @access private
- */
- isInitialized: false,
- /**
- * Used for console initialize, reinit is ok, just some variable assignment
- *
- * @return void
- */
- initialize: function () {
- if ($('#pma_console').length === 0) {
- return;
- }
-
- Console.config = Functions.configGet('Console', false);
-
- Console.isEnabled = true;
-
- // Vars init
- Console.$consoleToolbar = $('#pma_console').find('>.toolbar');
- Console.$consoleContent = $('#pma_console').find('>.content');
- Console.$consoleAllContents = $('#pma_console').find('.content');
- Console.$consoleTemplates = $('#pma_console').find('>.templates');
-
- // Generate a from for post
- Console.$requestForm = $('<form method="post" action="import.php">' +
- '<input name="is_js_confirmed" value="0">' +
- '<textarea name="sql_query"></textarea>' +
- '<input name="console_message_id" value="0">' +
- '<input name="server" value="">' +
- '<input name="db" value="">' +
- '<input name="table" value="">' +
- '<input name="token" value="">' +
- '</form>'
- );
- Console.$requestForm.children('[name=token]').val(CommonParams.get('token'));
- Console.$requestForm.on('submit', AJAX.requestHandler);
-
- // Event binds shouldn't run again
- if (Console.isInitialized === false) {
- // Load config first
- if (Console.config.AlwaysExpand === true) {
- $('#pma_console_options input[name=always_expand]').prop('checked', true);
- }
- if (Console.config.StartHistory === true) {
- $('#pma_console_options').find('input[name=start_history]').prop('checked', true);
- }
- if (Console.config.CurrentQuery === true) {
- $('#pma_console_options').find('input[name=current_query]').prop('checked', true);
- }
- if (Console.config.EnterExecutes === true) {
- $('#pma_console_options').find('input[name=enter_executes]').prop('checked', true);
- }
- if (Console.config.DarkTheme === true) {
- $('#pma_console_options').find('input[name=dark_theme]').prop('checked', true);
- $('#pma_console').find('>.content').addClass('console_dark_theme');
- }
-
- ConsoleResizer.initialize();
- ConsoleInput.initialize();
- ConsoleMessages.initialize();
- ConsoleBookmarks.initialize();
- ConsoleDebug.initialize();
-
- Console.$consoleToolbar.children('.console_switch').on('click', Console.toggle);
-
- $('#pma_console').find('.toolbar').children().on('mousedown', function (event) {
- event.preventDefault();
- event.stopImmediatePropagation();
- });
-
- $('#pma_console').find('.button.clear').on('click', function () {
- ConsoleMessages.clear();
- });
-
- $('#pma_console').find('.button.history').on('click', function () {
- ConsoleMessages.showHistory();
- });
-
- $('#pma_console').find('.button.options').on('click', function () {
- Console.showCard('#pma_console_options');
- });
-
- $('#pma_console').find('.button.debug').on('click', function () {
- Console.showCard('#debug_console');
- });
-
- Console.$consoleContent.on('click', function (event) {
- if (event.target === this) {
- ConsoleInput.focus();
- }
- });
-
- $('#pma_console').find('.mid_layer').on('click', function () {
- Console.hideCard($(this).parent().children('.card'));
- });
- $('#debug_console').find('.switch_button').on('click', function () {
- Console.hideCard($(this).closest('.card'));
- });
- $('#pma_bookmarks').find('.switch_button').on('click', function () {
- Console.hideCard($(this).closest('.card'));
- });
- $('#pma_console_options').find('.switch_button').on('click', function () {
- Console.hideCard($(this).closest('.card'));
- });
-
- $('#pma_console_options').find('input[type=checkbox]').on('change', function () {
- Console.updateConfig();
- });
-
- $('#pma_console_options').find('.button.default').on('click', function () {
- $('#pma_console_options input[name=always_expand]').prop('checked', false);
- $('#pma_console_options').find('input[name=start_history]').prop('checked', false);
- $('#pma_console_options').find('input[name=current_query]').prop('checked', true);
- $('#pma_console_options').find('input[name=enter_executes]').prop('checked', false);
- $('#pma_console_options').find('input[name=dark_theme]').prop('checked', false);
- Console.updateConfig();
- });
-
- $('#pma_console_options').find('input[name=enter_executes]').on('change', function () {
- ConsoleMessages.showInstructions(Console.config.EnterExecutes);
- });
-
- $(document).ajaxComplete(function (event, xhr, ajaxOptions) {
- if (ajaxOptions.dataType && ajaxOptions.dataType.indexOf('json') !== -1) {
- return;
- }
- if (xhr.status !== 200) {
- return;
- }
- try {
- var data = JSON.parse(xhr.responseText);
- Console.ajaxCallback(data);
- } catch (e) {
- // eslint-disable-next-line no-console
- console.trace();
- // eslint-disable-next-line no-console
- console.log('Failed to parse JSON: ' + e.message);
- }
- });
-
- Console.isInitialized = true;
- }
-
- // Change console mode from cookie
- switch (Console.config.Mode) {
- case 'collapse':
- Console.collapse();
- break;
- case 'info':
- Console.info();
- break;
- case 'show':
- Console.show(true);
- Console.scrollBottom();
- break;
- default:
- Console.setConfig('Mode', 'info');
- Console.info();
- }
- },
- /**
- * Execute query and show results in console
- *
- * @return void
- */
- execute: function (queryString, options) {
- if (typeof(queryString) !== 'string' || ! /[a-z]|[A-Z]/.test(queryString)) {
- return;
- }
- Console.$requestForm.children('textarea').val(queryString);
- Console.$requestForm.children('[name=server]').attr('value', CommonParams.get('server'));
- if (options && options.db) {
- Console.$requestForm.children('[name=db]').val(options.db);
- if (options.table) {
- Console.$requestForm.children('[name=table]').val(options.table);
- } else {
- Console.$requestForm.children('[name=table]').val('');
- }
- } else {
- Console.$requestForm.children('[name=db]').val(
- (CommonParams.get('db').length > 0 ? CommonParams.get('db') : ''));
- }
- Console.$requestForm.find('[name=profiling]').remove();
- if (options && options.profiling === true) {
- Console.$requestForm.append('<input name="profiling" value="on">');
- }
- if (! Functions.confirmQuery(Console.$requestForm[0], Console.$requestForm.children('textarea')[0].value)) {
- return;
- }
- Console.$requestForm.children('[name=console_message_id]')
- .val(ConsoleMessages.appendQuery({ 'sql_query': queryString }).message_id);
- Console.$requestForm.trigger('submit');
- ConsoleInput.clear();
- Navigation.reload();
- },
- ajaxCallback: function (data) {
- if (data && data.console_message_id) {
- ConsoleMessages.updateQuery(data.console_message_id, data.success,
- (data.reloadQuerywindow ? data.reloadQuerywindow : false));
- } else if (data && data.reloadQuerywindow) {
- if (data.reloadQuerywindow.sql_query.length > 0) {
- ConsoleMessages.appendQuery(data.reloadQuerywindow, 'successed')
- .$message.addClass(Console.config.CurrentQuery ? '' : 'hide');
- }
- }
- },
- /**
- * Change console to collapse mode
- *
- * @return void
- */
- collapse: function () {
- Console.setConfig('Mode', 'collapse');
- var pmaConsoleHeight = Math.max(92, Console.config.Height);
-
- Console.$consoleToolbar.addClass('collapsed');
- Console.$consoleAllContents.height(pmaConsoleHeight);
- Console.$consoleContent.stop();
- Console.$consoleContent.animate({ 'margin-bottom': -1 * Console.$consoleContent.outerHeight() + 'px' },
- 'fast', 'easeOutQuart', function () {
- Console.$consoleContent.css({ display:'none' });
- $(window).trigger('resize');
- });
- Console.hideCard();
- },
- /**
- * Show console
- *
- * @param bool inputFocus If true, focus the input line after show()
- * @return void
- */
- show: function (inputFocus) {
- Console.setConfig('Mode', 'show');
-
- var pmaConsoleHeight = Math.max(92, Console.config.Height);
- pmaConsoleHeight = Math.min(Console.config.Height, (window.innerHeight || document.documentElement.clientHeight || document.body.clientHeight) - 25);
- Console.$consoleContent.css({ display:'block' });
- if (Console.$consoleToolbar.hasClass('collapsed')) {
- Console.$consoleToolbar.removeClass('collapsed');
- }
- Console.$consoleAllContents.height(pmaConsoleHeight);
- Console.$consoleContent.stop();
- Console.$consoleContent.animate({ 'margin-bottom': 0 },
- 'fast', 'easeOutQuart', function () {
- $(window).trigger('resize');
- if (inputFocus) {
- ConsoleInput.focus();
- }
- });
- },
- /**
- * Change console to SQL information mode
- * this mode shows current SQL query
- * This mode is the default mode
- *
- * @return void
- */
- info: function () {
- // Under construction
- Console.collapse();
- },
- /**
- * Toggle console mode between collapse/show
- * Used for toggle buttons and shortcuts
- *
- * @return void
- */
- toggle: function () {
- switch (Console.config.Mode) {
- case 'collapse':
- case 'info':
- Console.show(true);
- break;
- case 'show':
- Console.collapse();
- break;
- }
- },
- /**
- * Scroll console to bottom
- *
- * @return void
- */
- scrollBottom: function () {
- Console.$consoleContent.scrollTop(Console.$consoleContent.prop('scrollHeight'));
- },
- /**
- * Show card
- *
- * @param string cardSelector Selector, select string will be "#pma_console " + cardSelector
- * this param also can be JQuery object, if you need.
- *
- * @return void
- */
- showCard: function (cardSelector) {
- var $card = null;
- if (typeof(cardSelector) !== 'string') {
- if (cardSelector.length > 0) {
- $card = cardSelector;
- } else {
- return;
- }
- } else {
- $card = $('#pma_console ' + cardSelector);
- }
- if ($card.length === 0) {
- return;
- }
- $card.parent().children('.mid_layer').show().fadeTo(0, 0.15);
- $card.addClass('show');
- ConsoleInput.blur();
- if ($card.parents('.card').length > 0) {
- Console.showCard($card.parents('.card'));
- }
- },
- /**
- * Scroll console to bottom
- *
- * @param object $targetCard Target card JQuery object, if it's empty, function will hide all cards
- * @return void
- */
- hideCard: function ($targetCard) {
- if (! $targetCard) {
- $('#pma_console').find('.mid_layer').fadeOut(140);
- $('#pma_console').find('.card').removeClass('show');
- } else if ($targetCard.length > 0) {
- $targetCard.parent().find('.mid_layer').fadeOut(140);
- $targetCard.find('.card').removeClass('show');
- $targetCard.removeClass('show');
- }
- },
- /**
- * Used for update console config
- *
- * @return void
- */
- updateConfig: function () {
- Console.setConfig('AlwaysExpand', $('#pma_console_options input[name=always_expand]').prop('checked'));
- Console.setConfig('StartHistory', $('#pma_console_options').find('input[name=start_history]').prop('checked'));
- Console.setConfig('CurrentQuery', $('#pma_console_options').find('input[name=current_query]').prop('checked'));
- Console.setConfig('EnterExecutes', $('#pma_console_options').find('input[name=enter_executes]').prop('checked'));
- Console.setConfig('DarkTheme', $('#pma_console_options').find('input[name=dark_theme]').prop('checked'));
- /* Setting the dark theme of the console*/
- if (Console.config.DarkTheme) {
- $('#pma_console').find('>.content').addClass('console_dark_theme');
- } else {
- $('#pma_console').find('>.content').removeClass('console_dark_theme');
- }
- },
- setConfig: function (key, value) {
- Console.config[key] = value;
- Functions.configSet('Console/' + key, value);
- },
- isSelect: function (queryString) {
- var regExp = /^SELECT\s+/i;
- return regExp.test(queryString);
- }
-};
-
-/**
- * Resizer object
- * Careful: this object UI logics highly related with functions under Console
- * Resizing min-height is 32, if small than it, console will collapse
- */
-var ConsoleResizer = {
- posY: 0,
- height: 0,
- resultHeight: 0,
- /**
- * Mousedown event handler for bind to resizer
- *
- * @return void
- */
- mouseDown: function (event) {
- if (Console.config.Mode !== 'show') {
- return;
- }
- ConsoleResizer.posY = event.pageY;
- ConsoleResizer.height = Console.$consoleContent.height();
- $(document).on('mousemove', ConsoleResizer.mouseMove);
- $(document).on('mouseup', ConsoleResizer.mouseUp);
- // Disable text selection while resizing
- $(document).on('selectstart', function () {
- return false;
- });
- },
- /**
- * Mousemove event handler for bind to resizer
- *
- * @return void
- */
- mouseMove: function (event) {
- if (event.pageY < 35) {
- event.pageY = 35;
- }
- ConsoleResizer.resultHeight = ConsoleResizer.height + (ConsoleResizer.posY - event.pageY);
- // Content min-height is 32, if adjusting height small than it we'll move it out of the page
- if (ConsoleResizer.resultHeight <= 32) {
- Console.$consoleAllContents.height(32);
- Console.$consoleContent.css('margin-bottom', ConsoleResizer.resultHeight - 32);
- } else {
- // Logic below makes viewable area always at bottom when adjusting height and content already at bottom
- if (Console.$consoleContent.scrollTop() + Console.$consoleContent.innerHeight() + 16
- >= Console.$consoleContent.prop('scrollHeight')) {
- Console.$consoleAllContents.height(ConsoleResizer.resultHeight);
- Console.scrollBottom();
- } else {
- Console.$consoleAllContents.height(ConsoleResizer.resultHeight);
- }
- }
- },
- /**
- * Mouseup event handler for bind to resizer
- *
- * @return void
- */
- mouseUp: function () {
- Console.setConfig('Height', ConsoleResizer.resultHeight);
- Console.show();
- $(document).off('mousemove');
- $(document).off('mouseup');
- $(document).off('selectstart');
- },
- /**
- * Used for console resizer initialize
- *
- * @return void
- */
- initialize: function () {
- $('#pma_console').find('.toolbar').off('mousedown');
- $('#pma_console').find('.toolbar').on('mousedown', ConsoleResizer.mouseDown);
- }
-};
-
-/**
- * Console input object
- */
-var ConsoleInput = {
- /**
- * @var array, contains Codemirror objects or input jQuery objects
- * @access private
- */
- inputs: null,
- /**
- * @var bool, if codemirror enabled
- * @access private
- */
- codeMirror: false,
- /**
- * @var int, count for history navigation, 0 for current input
- * @access private
- */
- historyCount: 0,
- /**
- * @var string, current input when navigating through history
- * @access private
- */
- historyPreserveCurrent: null,
- /**
- * Used for console input initialize
- *
- * @return void
- */
- initialize: function () {
- // _cm object can't be reinitialize
- if (ConsoleInput.inputs !== null) {
- return;
- }
- if (typeof CodeMirror !== 'undefined') {
- ConsoleInput.codeMirror = true;
- }
- ConsoleInput.inputs = [];
- if (ConsoleInput.codeMirror) {
- // eslint-disable-next-line new-cap
- ConsoleInput.inputs.console = CodeMirror($('#pma_console').find('.console_query_input')[0], {
- theme: 'pma',
- mode: 'text/x-sql',
- lineWrapping: true,
- extraKeys: { 'Ctrl-Space': 'autocomplete' },
- hintOptions: { 'completeSingle': false, 'completeOnSingleClick': true },
- gutters: ['CodeMirror-lint-markers'],
- lint: {
- 'getAnnotations': CodeMirror.sqlLint,
- 'async': true,
- }
- });
- ConsoleInput.inputs.console.on('inputRead', Functions.codeMirrorAutoCompleteOnInputRead);
- ConsoleInput.inputs.console.on('keydown', function (instance, event) {
- ConsoleInput.historyNavigate(event);
- });
- if ($('#pma_bookmarks').length !== 0) {
- // eslint-disable-next-line new-cap
- ConsoleInput.inputs.bookmark = CodeMirror($('#pma_console').find('.bookmark_add_input')[0], {
- theme: 'pma',
- mode: 'text/x-sql',
- lineWrapping: true,
- extraKeys: { 'Ctrl-Space': 'autocomplete' },
- hintOptions: { 'completeSingle': false, 'completeOnSingleClick': true },
- gutters: ['CodeMirror-lint-markers'],
- lint: {
- 'getAnnotations': CodeMirror.sqlLint,
- 'async': true,
- }
- });
- ConsoleInput.inputs.bookmark.on('inputRead', Functions.codeMirrorAutoCompleteOnInputRead);
- }
- } else {
- ConsoleInput.inputs.console =
- $('<textarea>').appendTo('#pma_console .console_query_input')
- .on('keydown', ConsoleInput.historyNavigate);
- if ($('#pma_bookmarks').length !== 0) {
- ConsoleInput.inputs.bookmark =
- $('<textarea>').appendTo('#pma_console .bookmark_add_input');
- }
- }
- $('#pma_console').find('.console_query_input').on('keydown', ConsoleInput.keyDown);
- },
- historyNavigate: function (event) {
- if (event.keyCode === 38 || event.keyCode === 40) {
- var upPermitted = false;
- var downPermitted = false;
- var editor = ConsoleInput.inputs.console;
- var cursorLine;
- var totalLine;
- if (ConsoleInput.codeMirror) {
- cursorLine = editor.getCursor().line;
- totalLine = editor.lineCount();
- } else {
- // Get cursor position from textarea
- var text = ConsoleInput.getText();
- cursorLine = text.substr(0, editor.prop('selectionStart')).split('\n').length - 1;
- totalLine = text.split(/\r*\n/).length;
- }
- if (cursorLine === 0) {
- upPermitted = true;
- }
- if (cursorLine === totalLine - 1) {
- downPermitted = true;
- }
- var nextCount;
- var queryString = false;
- if (upPermitted && event.keyCode === 38) {
- // Navigate up in history
- if (ConsoleInput.historyCount === 0) {
- ConsoleInput.historyPreserveCurrent = ConsoleInput.getText();
- }
- nextCount = ConsoleInput.historyCount + 1;
- queryString = ConsoleMessages.getHistory(nextCount);
- } else if (downPermitted && event.keyCode === 40) {
- // Navigate down in history
- if (ConsoleInput.historyCount === 0) {
- return;
- }
- nextCount = ConsoleInput.historyCount - 1;
- if (nextCount === 0) {
- queryString = ConsoleInput.historyPreserveCurrent;
- } else {
- queryString = ConsoleMessages.getHistory(nextCount);
- }
- }
- if (queryString !== false) {
- ConsoleInput.historyCount = nextCount;
- ConsoleInput.setText(queryString, 'console');
- if (ConsoleInput.codeMirror) {
- editor.setCursor(editor.lineCount(), 0);
- }
- event.preventDefault();
- }
- }
- },
- /**
- * Mousedown event handler for bind to input
- * Shortcut is Ctrl+Enter key or just ENTER, depending on console's
- * configuration.
- *
- * @return void
- */
- keyDown: function (event) {
- // Execute command
- if (Console.config.EnterExecutes) {
- // Enter, but not in combination with Shift (which writes a new line).
- if (!event.shiftKey && event.keyCode === 13) {
- ConsoleInput.execute();
- }
- } else {
- // Ctrl+Enter
- if (event.ctrlKey && event.keyCode === 13) {
- ConsoleInput.execute();
- }
- }
- // Clear line
- if (event.ctrlKey && event.keyCode === 76) {
- ConsoleInput.clear();
- }
- // Clear console
- if (event.ctrlKey && event.keyCode === 85) {
- ConsoleMessages.clear();
- }
- },
- /**
- * Used for send text to Console.execute()
- *
- * @return void
- */
- execute: function () {
- if (ConsoleInput.codeMirror) {
- Console.execute(ConsoleInput.inputs.console.getValue());
- } else {
- Console.execute(ConsoleInput.inputs.console.val());
- }
- },
- /**
- * Used for clear the input
- *
- * @param string target, default target is console input
- * @return void
- */
- clear: function (target) {
- ConsoleInput.setText('', target);
- },
- /**
- * Used for set focus to input
- *
- * @return void
- */
- focus: function () {
- ConsoleInput.inputs.console.focus();
- },
- /**
- * Used for blur input
- *
- * @return void
- */
- blur: function () {
- if (ConsoleInput.codeMirror) {
- ConsoleInput.inputs.console.getInputField().blur();
- } else {
- ConsoleInput.inputs.console.blur();
- }
- },
- /**
- * Used for set text in input
- *
- * @param string text
- * @param string target
- * @return void
- */
- setText: function (text, target) {
- if (ConsoleInput.codeMirror) {
- switch (target) {
- case 'bookmark':
- Console.execute(ConsoleInput.inputs.bookmark.setValue(text));
- break;
- default:
- case 'console':
- Console.execute(ConsoleInput.inputs.console.setValue(text));
- }
- } else {
- switch (target) {
- case 'bookmark':
- Console.execute(ConsoleInput.inputs.bookmark.val(text));
- break;
- default:
- case 'console':
- Console.execute(ConsoleInput.inputs.console.val(text));
- }
- }
- },
- getText: function (target) {
- if (ConsoleInput.codeMirror) {
- switch (target) {
- case 'bookmark':
- return ConsoleInput.inputs.bookmark.getValue();
- default:
- case 'console':
- return ConsoleInput.inputs.console.getValue();
- }
- } else {
- switch (target) {
- case 'bookmark':
- return ConsoleInput.inputs.bookmark.val();
- default:
- case 'console':
- return ConsoleInput.inputs.console.val();
- }
- }
- }
-
-};
-
-/**
- * Console messages, and message items management object
- */
-var ConsoleMessages = {
- /**
- * Used for clear the messages
- *
- * @return void
- */
- clear: function () {
- $('#pma_console').find('.content .console_message_container .message:not(.welcome)').addClass('hide');
- $('#pma_console').find('.content .console_message_container .message.failed').remove();
- $('#pma_console').find('.content .console_message_container .message.expanded').find('.action.collapse').trigger('click');
- },
- /**
- * Used for show history messages
- *
- * @return void
- */
- showHistory: function () {
- $('#pma_console').find('.content .console_message_container .message.hide').removeClass('hide');
- },
- /**
- * Used for getting a perticular history query
- *
- * @param int nthLast get nth query message from latest, i.e 1st is last
- * @return string message
- */
- getHistory: function (nthLast) {
- var $queries = $('#pma_console').find('.content .console_message_container .query');
- var length = $queries.length;
- var $query = $queries.eq(length - nthLast);
- if (!$query || (length - nthLast) < 0) {
- return false;
- } else {
- return $query.text();
- }
- },
- /**
- * Used to show the correct message depending on which key
- * combination executes the query (Ctrl+Enter or Enter).
- *
- * @param bool enterExecutes Only Enter has to be pressed to execute query.
- * @return void
- */
- showInstructions: function (enterExecutes) {
- var enter = +enterExecutes || 0; // conversion to int
- var $welcomeMsg = $('#pma_console').find('.content .console_message_container .message.welcome span');
- $welcomeMsg.children('[id^=instructions]').hide();
- $welcomeMsg.children('#instructions-' + enter).show();
- },
- /**
- * Used for log new message
- *
- * @param string msgString Message to show
- * @param string msgType Message type
- * @return object, {message_id, $message}
- */
- append: function (msgString, msgType) {
- if (typeof(msgString) !== 'string') {
- return false;
- }
- // Generate an ID for each message, we can find them later
- var msgId = Math.round(Math.random() * (899999999999) + 100000000000);
- var now = new Date();
- var $newMessage =
- $('<div class="message ' +
- (Console.config.AlwaysExpand ? 'expanded' : 'collapsed') +
- '" msgid="' + msgId + '"><div class="action_content"></div></div>');
- switch (msgType) {
- case 'query':
- $newMessage.append('<div class="query highlighted"></div>');
- if (ConsoleInput.codeMirror) {
- CodeMirror.runMode(msgString,
- 'text/x-sql', $newMessage.children('.query')[0]);
- } else {
- $newMessage.children('.query').text(msgString);
- }
- $newMessage.children('.action_content')
- .append(Console.$consoleTemplates.children('.query_actions').html());
- break;
- default:
- case 'normal':
- $newMessage.append('<div>' + msgString + '</div>');
- }
- ConsoleMessages.messageEventBinds($newMessage);
- $newMessage.find('span.text.query_time span')
- .text(now.getHours() + ':' + now.getMinutes() + ':' + now.getSeconds())
- .parent().attr('title', now);
- return {
- 'message_id': msgId,
- $message: $newMessage.appendTo('#pma_console .content .console_message_container')
- };
- },
- /**
- * Used for log new query
- *
- * @param string queryData Struct should be
- * {sql_query: "Query string", db: "Target DB", table: "Target Table"}
- * @param string state Message state
- * @return object, {message_id: string message id, $message: JQuery object}
- */
- appendQuery: function (queryData, state) {
- var targetMessage = ConsoleMessages.append(queryData.sql_query, 'query');
- if (! targetMessage) {
- return false;
- }
- if (queryData.db && queryData.table) {
- targetMessage.$message.attr('targetdb', queryData.db);
- targetMessage.$message.attr('targettable', queryData.table);
- targetMessage.$message.find('.text.targetdb span').text(queryData.db);
- }
- if (Console.isSelect(queryData.sql_query)) {
- targetMessage.$message.addClass('select');
- }
- switch (state) {
- case 'failed':
- targetMessage.$message.addClass('failed');
- break;
- case 'successed':
- targetMessage.$message.addClass('successed');
- break;
- default:
- case 'pending':
- targetMessage.$message.addClass('pending');
- }
- return targetMessage;
- },
- messageEventBinds: function ($target) {
- // Leave unbinded elements, remove binded.
- var $targetMessage = $target.filter(':not(.binded)');
- if ($targetMessage.length === 0) {
- return;
- }
- $targetMessage.addClass('binded');
-
- $targetMessage.find('.action.expand').on('click', function () {
- $(this).closest('.message').removeClass('collapsed');
- $(this).closest('.message').addClass('expanded');
- });
- $targetMessage.find('.action.collapse').on('click', function () {
- $(this).closest('.message').addClass('collapsed');
- $(this).closest('.message').removeClass('expanded');
- });
- $targetMessage.find('.action.edit').on('click', function () {
- ConsoleInput.setText($(this).parent().siblings('.query').text());
- ConsoleInput.focus();
- });
- $targetMessage.find('.action.requery').on('click', function () {
- var query = $(this).parent().siblings('.query').text();
- var $message = $(this).closest('.message');
- if (confirm(Messages.strConsoleRequeryConfirm + '\n' +
- (query.length < 100 ? query : query.slice(0, 100) + '...'))
- ) {
- Console.execute(query, { db: $message.attr('targetdb'), table: $message.attr('targettable') });
- }
- });
- $targetMessage.find('.action.bookmark').on('click', function () {
- var query = $(this).parent().siblings('.query').text();
- var $message = $(this).closest('.message');
- ConsoleBookmarks.addBookmark(query, $message.attr('targetdb'));
- Console.showCard('#pma_bookmarks .card.add');
- });
- $targetMessage.find('.action.edit_bookmark').on('click', function () {
- var query = $(this).parent().siblings('.query').text();
- var $message = $(this).closest('.message');
- var isShared = $message.find('span.bookmark_label').hasClass('shared');
- var label = $message.find('span.bookmark_label').text();
- ConsoleBookmarks.addBookmark(query, $message.attr('targetdb'), label, isShared);
- Console.showCard('#pma_bookmarks .card.add');
- });
- $targetMessage.find('.action.delete_bookmark').on('click', function () {
- var $message = $(this).closest('.message');
- if (confirm(Messages.strConsoleDeleteBookmarkConfirm + '\n' + $message.find('.bookmark_label').text())) {
- $.post('import.php',
- {
- 'server': CommonParams.get('server'),
- 'action_bookmark': 2,
- 'ajax_request': true,
- 'id_bookmark': $message.attr('bookmarkid')
- },
- function () {
- ConsoleBookmarks.refresh();
- });
- }
- });
- $targetMessage.find('.action.profiling').on('click', function () {
- var $message = $(this).closest('.message');
- Console.execute($(this).parent().siblings('.query').text(),
- { db: $message.attr('targetdb'),
- table: $message.attr('targettable'),
- profiling: true });
- });
- $targetMessage.find('.action.explain').on('click', function () {
- var $message = $(this).closest('.message');
- Console.execute('EXPLAIN ' + $(this).parent().siblings('.query').text(),
- { db: $message.attr('targetdb'),
- table: $message.attr('targettable') });
- });
- $targetMessage.find('.action.dbg_show_trace').on('click', function () {
- var $message = $(this).closest('.message');
- if (!$message.find('.trace').length) {
- ConsoleDebug.getQueryDetails(
- $message.data('queryInfo'),
- $message.data('totalTime'),
- $message
- );
- ConsoleMessages.messageEventBinds($message.find('.message:not(.binded)'));
- }
- $message.addClass('show_trace');
- $message.removeClass('hide_trace');
- });
- $targetMessage.find('.action.dbg_hide_trace').on('click', function () {
- var $message = $(this).closest('.message');
- $message.addClass('hide_trace');
- $message.removeClass('show_trace');
- });
- $targetMessage.find('.action.dbg_show_args').on('click', function () {
- var $message = $(this).closest('.message');
- $message.addClass('show_args expanded');
- $message.removeClass('hide_args collapsed');
- });
- $targetMessage.find('.action.dbg_hide_args').on('click', function () {
- var $message = $(this).closest('.message');
- $message.addClass('hide_args collapsed');
- $message.removeClass('show_args expanded');
- });
- if (ConsoleInput.codeMirror) {
- $targetMessage.find('.query:not(.highlighted)').each(function (index, elem) {
- CodeMirror.runMode($(elem).text(),
- 'text/x-sql', elem);
- $(this).addClass('highlighted');
- });
- }
- },
- msgAppend: function (msgId, msgString) {
- var $targetMessage = $('#pma_console').find('.content .console_message_container .message[msgid=' + msgId + ']');
- if ($targetMessage.length === 0 || isNaN(parseInt(msgId)) || typeof(msgString) !== 'string') {
- return false;
- }
- $targetMessage.append('<div>' + msgString + '</div>');
- },
- updateQuery: function (msgId, isSuccessed, queryData) {
- var $targetMessage = $('#pma_console').find('.console_message_container .message[msgid=' + parseInt(msgId) + ']');
- if ($targetMessage.length === 0 || isNaN(parseInt(msgId))) {
- return false;
- }
- $targetMessage.removeClass('pending failed successed');
- if (isSuccessed) {
- $targetMessage.addClass('successed');
- if (queryData) {
- $targetMessage.children('.query').text('');
- $targetMessage.removeClass('select');
- if (Console.isSelect(queryData.sql_query)) {
- $targetMessage.addClass('select');
- }
- if (ConsoleInput.codeMirror) {
- CodeMirror.runMode(queryData.sql_query, 'text/x-sql', $targetMessage.children('.query')[0]);
- } else {
- $targetMessage.children('.query').text(queryData.sql_query);
- }
- $targetMessage.attr('targetdb', queryData.db);
- $targetMessage.attr('targettable', queryData.table);
- $targetMessage.find('.text.targetdb span').text(queryData.db);
- }
- } else {
- $targetMessage.addClass('failed');
- }
- },
- /**
- * Used for console messages initialize
- *
- * @return void
- */
- initialize: function () {
- ConsoleMessages.messageEventBinds($('#pma_console').find('.message:not(.binded)'));
- if (Console.config.StartHistory) {
- ConsoleMessages.showHistory();
- }
- ConsoleMessages.showInstructions(Console.config.EnterExecutes);
- }
-};
-
-/**
- * Console bookmarks card, and bookmarks items management object
- */
-var ConsoleBookmarks = {
- bookmarks: [],
- addBookmark: function (queryString, targetDb, label, isShared) {
- $('#pma_bookmarks').find('.add [name=shared]').prop('checked', false);
- $('#pma_bookmarks').find('.add [name=label]').val('');
- $('#pma_bookmarks').find('.add [name=targetdb]').val('');
- $('#pma_bookmarks').find('.add [name=id_bookmark]').val('');
- ConsoleInput.setText('', 'bookmark');
-
- if (typeof queryString !== 'undefined') {
- ConsoleInput.setText(queryString, 'bookmark');
- }
- if (typeof targetDb !== 'undefined') {
- $('#pma_bookmarks').find('.add [name=targetdb]').val(targetDb);
- }
- if (typeof label !== 'undefined') {
- $('#pma_bookmarks').find('.add [name=label]').val(label);
- }
- if (typeof isShared !== 'undefined') {
- $('#pma_bookmarks').find('.add [name=shared]').prop('checked', isShared);
- }
- },
- refresh: function () {
- $.get('import.php',
- {
- 'ajax_request': true,
- 'server': CommonParams.get('server'),
- 'console_bookmark_refresh': 'refresh'
- },
- function (data) {
- if (data.console_message_bookmark) {
- $('#pma_bookmarks').find('.content.bookmark').html(data.console_message_bookmark);
- ConsoleMessages.messageEventBinds($('#pma_bookmarks').find('.message:not(.binded)'));
- }
- });
- },
- /**
- * Used for console bookmarks initialize
- * message events are already binded by ConsoleMsg.messageEventBinds
- *
- * @return void
- */
- initialize: function () {
- if ($('#pma_bookmarks').length === 0) {
- return;
- }
- $('#pma_console').find('.button.bookmarks').on('click', function () {
- Console.showCard('#pma_bookmarks');
- });
- $('#pma_bookmarks').find('.button.add').on('click', function () {
- Console.showCard('#pma_bookmarks .card.add');
- });
- $('#pma_bookmarks').find('.card.add [name=submit]').on('click', function () {
- if ($('#pma_bookmarks').find('.card.add [name=label]').val().length === 0
- || ConsoleInput.getText('bookmark').length === 0) {
- alert(Messages.strFormEmpty);
- return;
- }
- $(this).prop('disabled', true);
- $.post('import.php',
- {
- 'ajax_request': true,
- 'console_bookmark_add': 'true',
- 'label': $('#pma_bookmarks').find('.card.add [name=label]').val(),
- 'server': CommonParams.get('server'),
- 'db': $('#pma_bookmarks').find('.card.add [name=targetdb]').val(),
- 'bookmark_query': ConsoleInput.getText('bookmark'),
- 'shared': $('#pma_bookmarks').find('.card.add [name=shared]').prop('checked')
- },
- function () {
- ConsoleBookmarks.refresh();
- $('#pma_bookmarks').find('.card.add [name=submit]').prop('disabled', false);
- Console.hideCard($('#pma_bookmarks').find('.card.add'));
- });
- });
- $('#pma_console').find('.button.refresh').on('click', function () {
- ConsoleBookmarks.refresh();
- });
- }
-};
-
-var ConsoleDebug = {
- config: {
- groupQueries: false,
- orderBy: 'exec', // Possible 'exec' => Execution order, 'time' => Time taken, 'count'
- order: 'asc' // Possible 'asc', 'desc'
- },
- lastDebugInfo: {
- debugInfo: null,
- url: null
- },
- initialize: function () {
- // Try to get debug info after every AJAX request
- $(document).ajaxSuccess(function (event, xhr, settings, data) {
- if (data.debug) {
- ConsoleDebug.showLog(data.debug, settings.url);
- }
- });
-
- if (Console.config.GroupQueries) {
- $('#debug_console').addClass('grouped');
- } else {
- $('#debug_console').addClass('ungrouped');
- if (Console.config.OrderBy === 'count') {
- $('#debug_console').find('.button.order_by.sort_exec').addClass('active');
- }
- }
- var orderBy = Console.config.OrderBy;
- var order = Console.config.Order;
- $('#debug_console').find('.button.order_by.sort_' + orderBy).addClass('active');
- $('#debug_console').find('.button.order.order_' + order).addClass('active');
-
- // Initialize actions in toolbar
- $('#debug_console').find('.button.group_queries').on('click', function () {
- $('#debug_console').addClass('grouped');
- $('#debug_console').removeClass('ungrouped');
- Console.setConfig('GroupQueries', true);
- ConsoleDebug.refresh();
- if (Console.config.OrderBy === 'count') {
- $('#debug_console').find('.button.order_by.sort_exec').removeClass('active');
- }
- });
- $('#debug_console').find('.button.ungroup_queries').on('click', function () {
- $('#debug_console').addClass('ungrouped');
- $('#debug_console').removeClass('grouped');
- Console.setConfig('GroupQueries', false);
- ConsoleDebug.refresh();
- if (Console.config.OrderBy === 'count') {
- $('#debug_console').find('.button.order_by.sort_exec').addClass('active');
- }
- });
- $('#debug_console').find('.button.order_by').on('click', function () {
- var $this = $(this);
- $('#debug_console').find('.button.order_by').removeClass('active');
- $this.addClass('active');
- if ($this.hasClass('sort_time')) {
- Console.setConfig('OrderBy', 'time');
- } else if ($this.hasClass('sort_exec')) {
- Console.setConfig('OrderBy', 'exec');
- } else if ($this.hasClass('sort_count')) {
- Console.setConfig('OrderBy', 'count');
- }
- ConsoleDebug.refresh();
- });
- $('#debug_console').find('.button.order').on('click', function () {
- var $this = $(this);
- $('#debug_console').find('.button.order').removeClass('active');
- $this.addClass('active');
- if ($this.hasClass('order_asc')) {
- Console.setConfig('Order', 'asc');
- } else if ($this.hasClass('order_desc')) {
- Console.setConfig('Order', 'desc');
- }
- ConsoleDebug.refresh();
- });
-
- // Show SQL debug info for first page load
- if (typeof debugSQLInfo !== 'undefined' && debugSQLInfo !== 'null') {
- $('#pma_console').find('.button.debug').removeClass('hide');
- } else {
- return;
- }
- ConsoleDebug.showLog(debugSQLInfo);
- },
- formatFunctionCall: function (dbgStep) {
- var functionName = '';
- if ('class' in dbgStep) {
- functionName += dbgStep.class;
- functionName += dbgStep.type;
- }
- functionName += dbgStep.function;
- if (dbgStep.args && dbgStep.args.length) {
- functionName += '(...)';
- } else {
- functionName += '()';
- }
- return functionName;
- },
- formatFunctionArgs: function (dbgStep) {
- var $args = $('<div>');
- if (dbgStep.args.length) {
- $args.append('<div class="message welcome">')
- .append(
- $('<div class="message welcome">')
- .text(
- Functions.sprintf(
- Messages.strConsoleDebugArgsSummary,
- dbgStep.args.length
- )
- )
- );
- for (var i = 0; i < dbgStep.args.length; i++) {
- $args.append(
- $('<div class="message">')
- .html(
- '<pre>' +
- Functions.escapeHtml(JSON.stringify(dbgStep.args[i], null, ' ')) +
- '</pre>'
- )
- );
- }
- }
- return $args;
- },
- formatFileName: function (dbgStep) {
- var fileName = '';
- if ('file' in dbgStep) {
- fileName += dbgStep.file;
- fileName += '#' + dbgStep.line;
- }
- return fileName;
- },
- formatBackTrace: function (dbgTrace) {
- var $traceElem = $('<div class="trace">');
- $traceElem.append(
- $('<div class="message welcome">')
- );
- var step;
- var $stepElem;
- for (var stepId in dbgTrace) {
- if (dbgTrace.hasOwnProperty(stepId)) {
- step = dbgTrace[stepId];
- if (!Array.isArray(step) && typeof step !== 'object') {
- $stepElem =
- $('<div class="message traceStep collapsed hide_args">')
- .append(
- $('<span>').text(step)
- );
- } else {
- if (typeof step.args === 'string' && step.args) {
- step.args = [step.args];
- }
- $stepElem =
- $('<div class="message traceStep collapsed hide_args">')
- .append(
- $('<span class="function">').text(this.formatFunctionCall(step))
- )
- .append(
- $('<span class="file">').text(this.formatFileName(step))
- );
- if (step.args && step.args.length) {
- $stepElem
- .append(
- $('<span class="args">').html(this.formatFunctionArgs(step))
- )
- .prepend(
- $('<div class="action_content">')
- .append(
- '<span class="action dbg_show_args">' +
- Messages.strConsoleDebugShowArgs +
- '</span> '
- )
- .append(
- '<span class="action dbg_hide_args">' +
- Messages.strConsoleDebugHideArgs +
- '</span> '
- )
- );
- }
- }
- $traceElem.append($stepElem);
- }
- }
- return $traceElem;
- },
- formatQueryOrGroup: function (queryInfo, totalTime) {
- var grouped;
- var queryText;
- var queryTime;
- var count;
- var i;
- if (Array.isArray(queryInfo)) {
- // It is grouped
- grouped = true;
-
- queryText = queryInfo[0].query;
-
- queryTime = 0;
- for (i in queryInfo) {
- queryTime += queryInfo[i].time;
- }
-
- count = queryInfo.length;
- } else {
- queryText = queryInfo.query;
- queryTime = queryInfo.time;
- }
-
- var $query = $('<div class="message collapsed hide_trace">')
- .append(
- $('#debug_console').find('.templates .debug_query').clone()
- )
- .append(
- $('<div class="query">')
- .text(queryText)
- )
- .data('queryInfo', queryInfo)
- .data('totalTime', totalTime);
- if (grouped) {
- $query.find('.text.count').removeClass('hide');
- $query.find('.text.count span').text(count);
- }
- $query.find('.text.time span').text(queryTime + 's (' + ((queryTime * 100) / totalTime).toFixed(3) + '%)');
-
- return $query;
- },
- appendQueryExtraInfo: function (query, $elem) {
- if ('error' in query) {
- $elem.append(
- $('<div>').html(query.error)
- );
- }
- $elem.append(this.formatBackTrace(query.trace));
- },
- getQueryDetails: function (queryInfo, totalTime, $query) {
- if (Array.isArray(queryInfo)) {
- var $singleQuery;
- for (var i in queryInfo) {
- $singleQuery = $('<div class="message welcome trace">')
- .text((parseInt(i) + 1) + '.')
- .append(
- $('<span class="time">').text(
- Messages.strConsoleDebugTimeTaken +
- ' ' + queryInfo[i].time + 's' +
- ' (' + ((queryInfo[i].time * 100) / totalTime).toFixed(3) + '%)'
- )
- );
- this.appendQueryExtraInfo(queryInfo[i], $singleQuery);
- $query
- .append('<div class="message welcome trace">')
- .append($singleQuery);
- }
- } else {
- this.appendQueryExtraInfo(queryInfo, $query);
- }
- },
- showLog: function (debugInfo, url) {
- this.lastDebugInfo.debugInfo = debugInfo;
- this.lastDebugInfo.url = url;
-
- $('#debug_console').find('.debugLog').empty();
- $('#debug_console').find('.debug>.welcome').empty();
-
- var debugJson = false;
- var i;
- if (typeof debugInfo === 'object' && 'queries' in debugInfo) {
- // Copy it to debugJson, so that it doesn't get changed
- if (!('queries' in debugInfo)) {
- debugJson = false;
- } else {
- debugJson = { queries: [] };
- for (i in debugInfo.queries) {
- debugJson.queries[i] = debugInfo.queries[i];
- }
- }
- } else if (typeof debugInfo === 'string') {
- try {
- debugJson = JSON.parse(debugInfo);
- } catch (e) {
- debugJson = false;
- }
- if (debugJson && !('queries' in debugJson)) {
- debugJson = false;
- }
- }
- if (debugJson === false) {
- $('#debug_console').find('.debug>.welcome').text(
- Messages.strConsoleDebugError
- );
- return;
- }
- var allQueries = debugJson.queries;
- var uniqueQueries = {};
-
- var totalExec = allQueries.length;
-
- // Calculate total time and make unique query array
- var totalTime = 0;
- for (i = 0; i < totalExec; ++i) {
- totalTime += allQueries[i].time;
- if (!(allQueries[i].hash in uniqueQueries)) {
- uniqueQueries[allQueries[i].hash] = [];
- }
- uniqueQueries[allQueries[i].hash].push(allQueries[i]);
- }
- // Count total unique queries, convert uniqueQueries to Array
- var totalUnique = 0;
- var uniqueArray = [];
- for (var hash in uniqueQueries) {
- if (uniqueQueries.hasOwnProperty(hash)) {
- ++totalUnique;
- uniqueArray.push(uniqueQueries[hash]);
- }
- }
- uniqueQueries = uniqueArray;
- // Show summary
- $('#debug_console').find('.debug>.welcome').append(
- $('<span class="debug_summary">').text(
- Functions.sprintf(
- Messages.strConsoleDebugSummary,
- totalUnique,
- totalExec,
- totalTime
- )
- )
- );
- if (url) {
- $('#debug_console').find('.debug>.welcome').append(
- $('<span class="script_name">').text(url.split('?')[0])
- );
- }
-
- // For sorting queries
- function sortByTime (a, b) {
- var order = ((Console.config.Order === 'asc') ? 1 : -1);
- if (Array.isArray(a) && Array.isArray(b)) {
- // It is grouped
- var timeA = 0;
- var timeB = 0;
- var i;
- for (i in a) {
- timeA += a[i].time;
- }
- for (i in b) {
- timeB += b[i].time;
- }
- return (timeA - timeB) * order;
- } else {
- return (a.time - b.time) * order;
- }
- }
-
- function sortByCount (a, b) {
- var order = ((Console.config.Oorder === 'asc') ? 1 : -1);
- return (a.length - b.length) * order;
- }
-
- var orderBy = Console.config.OrderBy;
- var order = Console.config.Order;
-
- if (Console.config.GroupQueries) {
- // Sort queries
- if (orderBy === 'time') {
- uniqueQueries.sort(sortByTime);
- } else if (orderBy === 'count') {
- uniqueQueries.sort(sortByCount);
- } else if (orderBy === 'exec' && order === 'desc') {
- uniqueQueries.reverse();
- }
- for (i in uniqueQueries) {
- if (orderBy === 'time') {
- uniqueQueries[i].sort(sortByTime);
- } else if (orderBy === 'exec' && order === 'desc') {
- uniqueQueries[i].reverse();
- }
- $('#debug_console').find('.debugLog').append(this.formatQueryOrGroup(uniqueQueries[i], totalTime));
- }
- } else {
- if (orderBy === 'time') {
- allQueries.sort(sortByTime);
- } else if (order === 'desc') {
- allQueries.reverse();
- }
- for (i = 0; i < totalExec; ++i) {
- $('#debug_console').find('.debugLog').append(this.formatQueryOrGroup(allQueries[i], totalTime));
- }
- }
-
- ConsoleMessages.messageEventBinds($('#debug_console').find('.message:not(.binded)'));
- },
- refresh: function () {
- var last = this.lastDebugInfo;
- ConsoleDebug.showLog(last.debugInfo, last.url);
- }
-};
-
-/** s
- * Executed on page load
- */
-$(function () {
- Console.initialize();
-});
generated by cgit (git 2.34.1) at 2026-05-16 05:56:56 +0000