Extract some sql.js functions from functions.js file

Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>

2 files changed, 192 insertions, 191 deletions

diff --git a/js/src/functions.js b/js/src/functions.js
index 347f996969..58753cc567 100644
--- a/js/src/functions.js
+++ b/js/src/functions.js
@@ -15,16 +15,6 @@
 var Functions = {};
 
 /**
- * @type {boolean} lock for the sqlbox textarea in the querybox
- */
-let sqlBoxLocked = false;
-
-/**
- * @type {boolean[]} holds elements which content should only selected once
- */
-const onlyOnceElements = [];
-
-/**
  * @var {number} ajaxMessageCount Number of AJAX messages shown since page load
  */
 var ajaxMessageCount = 0;
@@ -629,25 +619,6 @@ Functions.displayPasswordGenerateButton = function () {
 };
 
 /**
- * selects the content of a given object, f.e. a textarea
- *
- * @param {HTMLTextAreaElement} element Element of which the content will be selected
- */
-Functions.selectContent = function (element) {
-    if (onlyOnceElements[element.name]) {
-        return;
-    }
-
-    onlyOnceElements[element.name] = true;
-
-    if (sqlBoxLocked) {
-        return;
-    }
-
-    element.select();
-};
-
-/**
  * Displays a confirmation box before submitting a "DROP/DELETE/ALTER" query.
  * This function is called while clicking links
  *
@@ -1114,162 +1085,6 @@ Functions.setSelectOptions = function (theForm, theSelect, doCheck) {
 };
 
 /**
- * Sets current value for query box.
- * @param {string} query
- * @return {void}
- */
-Functions.setQuery = function (query) {
-    if (codeMirrorEditor) {
-        codeMirrorEditor.setValue(query);
-        codeMirrorEditor.focus();
-    } else if (document.sqlform) {
-        document.sqlform.sql_query.value = query;
-        document.sqlform.sql_query.focus();
-    }
-};
-
-/**
-  * Create quick sql statements.
-  *
-  * @param {'clear'|'format'|'saved'|'selectall'|'select'|'insert'|'update'|'delete'} queryType
-  *
-  */
-Functions.insertQuery = function (queryType) {
-    var table;
-    if (queryType === 'clear') {
-        Functions.setQuery('');
-        return;
-    } else if (queryType === 'format') {
-        if (codeMirrorEditor) {
-            $('#querymessage').html(Messages.strFormatting +
-                '&nbsp;<img class="ajaxIcon" src="' +
-                themeImagePath + 'ajax_clock_small.gif" alt="">');
-            var params = {
-                'ajax_request': true,
-                'sql': codeMirrorEditor.getValue(),
-                'server': CommonParams.get('server')
-            };
-            $.ajax({
-                type: 'POST',
-                url: 'index.php?route=/database/sql/format',
-                data: params,
-                success: function (data) {
-                    if (data.success) {
-                        codeMirrorEditor.setValue(data.sql);
-                    }
-                    $('#querymessage').html('');
-                },
-                error: function () {
-                    $('#querymessage').html('');
-                }
-            });
-        }
-        return;
-    } else if (queryType === 'saved') {
-        var db = $('input[name="db"]').val();
-        table = $('input[name="table"]').val();
-        var key = db;
-        if (table !== undefined) {
-            key += '.' + table;
-        }
-        key = 'autoSavedSql_' + key;
-        if (isStorageSupported('localStorage') &&
-            typeof window.localStorage.getItem(key) === 'string') {
-            Functions.setQuery(window.localStorage.getItem(key));
-        } else if (Cookies.get(key, { path: CommonParams.get('rootPath') })) {
-            Functions.setQuery(Cookies.get(key, { path: CommonParams.get('rootPath') }));
-        } else {
-            Functions.ajaxShowMessage(Messages.strNoAutoSavedQuery);
-        }
-        return;
-    }
-
-    var query = '';
-    var myListBox = document.sqlform.dummy;
-    table = document.sqlform.table.value;
-
-    if (myListBox.options.length > 0) {
-        sqlBoxLocked = true;
-        var columnsList = '';
-        var valDis = '';
-        var editDis = '';
-        var NbSelect = 0;
-        for (var i = 0; i < myListBox.options.length; i++) {
-            NbSelect++;
-            if (NbSelect > 1) {
-                columnsList += ', ';
-                valDis += ',';
-                editDis += ',';
-            }
-            columnsList += myListBox.options[i].value;
-            valDis += '\'[value-' + NbSelect + ']\'';
-            editDis += myListBox.options[i].value + '=\'[value-' + NbSelect + ']\'';
-        }
-        if (queryType === 'selectall') {
-            query = 'SELECT * FROM `' + table + '` WHERE 1';
-        } else if (queryType === 'select') {
-            query = 'SELECT ' + columnsList + ' FROM `' + table + '` WHERE 1';
-        } else if (queryType === 'insert') {
-            query = 'INSERT INTO `' + table + '`(' + columnsList + ') VALUES (' + valDis + ')';
-        } else if (queryType === 'update') {
-            query = 'UPDATE `' + table + '` SET ' + editDis + ' WHERE 1';
-        } else if (queryType === 'delete') {
-            query = 'DELETE FROM `' + table + '` WHERE 0';
-        }
-        Functions.setQuery(query);
-        sqlBoxLocked = false;
-    }
-};
-
-/**
-  * Inserts multiple fields.
-  *
-  */
-Functions.insertValueQuery = function () {
-    var myQuery = document.sqlform.sql_query;
-    var myListBox = document.sqlform.dummy;
-
-    if (myListBox.options.length > 0) {
-        sqlBoxLocked = true;
-        var columnsList = '';
-        var NbSelect = 0;
-        for (var i = 0; i < myListBox.options.length; i++) {
-            if (myListBox.options[i].selected) {
-                NbSelect++;
-                if (NbSelect > 1) {
-                    columnsList += ', ';
-                }
-                columnsList += myListBox.options[i].value;
-            }
-        }
-
-        /* CodeMirror support */
-        if (codeMirrorEditor) {
-            codeMirrorEditor.replaceSelection(columnsList);
-            codeMirrorEditor.focus();
-        // IE support
-        } else if (document.selection) {
-            myQuery.focus();
-            var sel = document.selection.createRange();
-            sel.text = columnsList;
-        // MOZILLA/NETSCAPE support
-        } else if (document.sqlform.sql_query.selectionStart || document.sqlform.sql_query.selectionStart === '0') {
-            var startPos = document.sqlform.sql_query.selectionStart;
-            var endPos = document.sqlform.sql_query.selectionEnd;
-            var SqlString = document.sqlform.sql_query.value;
-
-            myQuery.value = SqlString.substring(0, startPos) + columnsList + SqlString.substring(endPos, SqlString.length);
-            myQuery.focus();
-        } else {
-            myQuery.value += columnsList;
-        }
-
-        // eslint-disable-next-line no-unused-vars
-        sqlBoxLocked = false;
-    }
-};
-
-/**
  * Updates the input fields for the parameters based on the query
  */
 Functions.updateQueryParameters = function () {
diff --git a/js/src/sql.js b/js/src/sql.js
index 4185321c29..bcd70ee9e9 100644
--- a/js/src/sql.js
+++ b/js/src/sql.js
@@ -10,6 +10,7 @@
 /* global isStorageSupported */ // js/config.js
 /* global codeMirrorEditor */ // js/functions.js
 /* global makeGrid */ // js/makegrid.js
+/* global themeImagePath */ // templates/javascript/variables.twig
 
 var Sql = {};
 
@@ -182,6 +183,16 @@ Sql.getFieldName = function ($tableResults, $thisField) {
 };
 
 /**
+ * @type {boolean} lock for the sqlbox textarea in the querybox
+ */
+let sqlBoxLocked = false;
+
+/**
+ * @type {boolean[]} holds elements which content should only selected once
+ */
+const onlyOnceElements = [];
+
+/**
  * Handles 'Simulate query' button on SQL query box.
  *
  * @return {void}
@@ -213,6 +224,181 @@ const handleSimulateQueryButton = function () {
 };
 
 /**
+ * selects the content of a given object, f.e. a textarea
+ *
+ * @param {HTMLTextAreaElement} element Element of which the content will be selected
+ */
+const selectContent = function (element) {
+    if (onlyOnceElements[element.name]) {
+        return;
+    }
+
+    onlyOnceElements[element.name] = true;
+
+    if (sqlBoxLocked) {
+        return;
+    }
+
+    element.select();
+};
+
+/**
+ * Sets current value for query box.
+ * @param {string} query
+ * @return {void}
+ */
+const setQuery = function (query) {
+    if (codeMirrorEditor) {
+        codeMirrorEditor.setValue(query);
+        codeMirrorEditor.focus();
+    } else if (document.sqlform) {
+        document.sqlform.sql_query.value = query;
+        document.sqlform.sql_query.focus();
+    }
+};
+
+/**
+ * Create quick sql statements.
+ *
+ * @param {'clear'|'format'|'saved'|'selectall'|'select'|'insert'|'update'|'delete'} queryType
+ *
+ */
+const insertQuery = function (queryType) {
+    var table;
+    if (queryType === 'clear') {
+        setQuery('');
+        return;
+    } else if (queryType === 'format') {
+        if (codeMirrorEditor) {
+            $('#querymessage').html(Messages.strFormatting +
+                '&nbsp;<img class="ajaxIcon" src="' +
+                themeImagePath + 'ajax_clock_small.gif" alt="">');
+            var params = {
+                'ajax_request': true,
+                'sql': codeMirrorEditor.getValue(),
+                'server': CommonParams.get('server')
+            };
+            $.ajax({
+                type: 'POST',
+                url: 'index.php?route=/database/sql/format',
+                data: params,
+                success: function (data) {
+                    if (data.success) {
+                        codeMirrorEditor.setValue(data.sql);
+                    }
+                    $('#querymessage').html('');
+                },
+                error: function () {
+                    $('#querymessage').html('');
+                }
+            });
+        }
+        return;
+    } else if (queryType === 'saved') {
+        var db = $('input[name="db"]').val();
+        table = $('input[name="table"]').val();
+        var key = db;
+        if (table !== undefined) {
+            key += '.' + table;
+        }
+        key = 'autoSavedSql_' + key;
+        if (isStorageSupported('localStorage') &&
+            typeof window.localStorage.getItem(key) === 'string') {
+            setQuery(window.localStorage.getItem(key));
+        } else if (Cookies.get(key, { path: CommonParams.get('rootPath') })) {
+            setQuery(Cookies.get(key, { path: CommonParams.get('rootPath') }));
+        } else {
+            Functions.ajaxShowMessage(Messages.strNoAutoSavedQuery);
+        }
+        return;
+    }
+
+    var query = '';
+    var myListBox = document.sqlform.dummy;
+    table = document.sqlform.table.value;
+
+    if (myListBox.options.length > 0) {
+        sqlBoxLocked = true;
+        var columnsList = '';
+        var valDis = '';
+        var editDis = '';
+        var NbSelect = 0;
+        for (var i = 0; i < myListBox.options.length; i++) {
+            NbSelect++;
+            if (NbSelect > 1) {
+                columnsList += ', ';
+                valDis += ',';
+                editDis += ',';
+            }
+            columnsList += myListBox.options[i].value;
+            valDis += '\'[value-' + NbSelect + ']\'';
+            editDis += myListBox.options[i].value + '=\'[value-' + NbSelect + ']\'';
+        }
+        if (queryType === 'selectall') {
+            query = 'SELECT * FROM `' + table + '` WHERE 1';
+        } else if (queryType === 'select') {
+            query = 'SELECT ' + columnsList + ' FROM `' + table + '` WHERE 1';
+        } else if (queryType === 'insert') {
+            query = 'INSERT INTO `' + table + '`(' + columnsList + ') VALUES (' + valDis + ')';
+        } else if (queryType === 'update') {
+            query = 'UPDATE `' + table + '` SET ' + editDis + ' WHERE 1';
+        } else if (queryType === 'delete') {
+            query = 'DELETE FROM `' + table + '` WHERE 0';
+        }
+        setQuery(query);
+        sqlBoxLocked = false;
+    }
+};
+
+/**
+ * Inserts multiple fields.
+ *
+ */
+const insertValueQuery = function () {
+    var myQuery = document.sqlform.sql_query;
+    var myListBox = document.sqlform.dummy;
+
+    if (myListBox.options.length > 0) {
+        sqlBoxLocked = true;
+        var columnsList = '';
+        var NbSelect = 0;
+        for (var i = 0; i < myListBox.options.length; i++) {
+            if (myListBox.options[i].selected) {
+                NbSelect++;
+                if (NbSelect > 1) {
+                    columnsList += ', ';
+                }
+                columnsList += myListBox.options[i].value;
+            }
+        }
+
+        /* CodeMirror support */
+        if (codeMirrorEditor) {
+            codeMirrorEditor.replaceSelection(columnsList);
+            codeMirrorEditor.focus();
+            // IE support
+        } else if (document.selection) {
+            myQuery.focus();
+            var sel = document.selection.createRange();
+            sel.text = columnsList;
+            // MOZILLA/NETSCAPE support
+        } else if (document.sqlform.sql_query.selectionStart || document.sqlform.sql_query.selectionStart === '0') {
+            var startPos = document.sqlform.sql_query.selectionStart;
+            var endPos = document.sqlform.sql_query.selectionEnd;
+            var SqlString = document.sqlform.sql_query.value;
+
+            myQuery.value = SqlString.substring(0, startPos) + columnsList + SqlString.substring(endPos, SqlString.length);
+            myQuery.focus();
+        } else {
+            myQuery.value += columnsList;
+        }
+
+        // eslint-disable-next-line no-unused-vars
+        sqlBoxLocked = false;
+    }
+};
+
+/**
  * Unbind all event handlers before tearing down a page
  */
 AJAX.registerTeardown('sql.js', function () {
@@ -596,7 +782,7 @@ AJAX.registerOnload('sql.js', function () {
                     if ('1' === data.action_bookmark) {
                         $('#sqlquery').text(data.sql_query);
                         // send to codemirror if possible
-                        Functions.setQuery(data.sql_query);
+                        setQuery(data.sql_query);
                     }
                     // delete
                     if ('2' === data.action_bookmark) {
@@ -872,27 +1058,27 @@ AJAX.registerOnload('sql.js', function () {
     });
 
     $('#insertBtn').on('click', function () {
-        Functions.insertValueQuery();
+        insertValueQuery();
     });
 
     $('#view_as').on('click', function () {
-        Functions.selectContent(this);
+        selectContent(this);
     });
 
     $('#sqlquery').on('click', function () {
         if ($(this).data('textarea-auto-select') === true) {
-            Functions.selectContent(this);
+            selectContent(this);
         }
     });
 
     $(document).on('click', 'input.sqlbutton', function (evt) {
-        Functions.insertQuery(evt.target.id);
+        insertQuery(evt.target.id);
         handleSimulateQueryButton();
         return false;
     });
 
     $('#fieldsSelect').on('dblclick', () => {
-        Functions.insertValueQuery();
+        insertValueQuery();
     });
 });