From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001
From: Charles Cabergs <me@cacharle.xyz>
Date: Mon, 27 Jul 2020 10:05:23 +0200
Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well
 and it brings shame on my familly

---
 srcs/phpmyadmin/js/database/query_generator.js | 131 -------------------------
 1 file changed, 131 deletions(-)
 delete mode 100644 srcs/phpmyadmin/js/database/query_generator.js

(limited to 'srcs/phpmyadmin/js/database/query_generator.js')

diff --git a/srcs/phpmyadmin/js/database/query_generator.js b/srcs/phpmyadmin/js/database/query_generator.js
deleted file mode 100644
index 854686c..0000000
--- a/srcs/phpmyadmin/js/database/query_generator.js
+++ /dev/null
@@ -1,131 +0,0 @@
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * @fileoverview    function used in QBE for DB
- * @name            Database Operations
- *
- * @requires    jQuery
- * @requires    jQueryUI
- * @requires    js/functions.js
- *
- */
-
-/* global sprintf */ // js/vendor/sprintf.js
-
-function getFormatsText () {
-    return {
-        '=': ' = \'%s\'',
-        '>': ' > \'%s\'',
-        '>=': ' >= \'%s\'',
-        '<': ' < \'%s\'',
-        '<=': ' <= \'%s\'',
-        '!=': ' != \'%s\'',
-        'LIKE': ' LIKE \'%s\'',
-        'LIKE %...%': ' LIKE \'%%%s%%\'',
-        'NOT LIKE': ' NOT LIKE \'%s\'',
-        'BETWEEN': ' BETWEEN \'%s\'',
-        'NOT BETWEEN': ' NOT BETWEEN \'%s\'',
-        'IS NULL': ' \'%s\' IS NULL',
-        'IS NOT NULL': ' \'%s\' IS NOT NULL',
-        'REGEXP': ' REGEXP \'%s\'',
-        'REGEXP ^...$': ' REGEXP \'^%s$\'',
-        'NOT REGEXP': ' NOT REGEXP \'%s\''
-    };
-}
-
-function generateCondition (criteriaDiv, table) {
-    var query = '`' + Functions.escapeBacktick(table.val()) + '`.';
-    query += '`' + Functions.escapeBacktick(table.siblings('.columnNameSelect').first().val()) + '`';
-    if (criteriaDiv.find('.criteria_rhs').first().val() === 'text') {
-        var formatsText = getFormatsText();
-        query += sprintf(formatsText[criteriaDiv.find('.criteria_op').first().val()], Functions.escapeSingleQuote(criteriaDiv.find('.rhs_text_val').first().val()));
-    } else {
-        query += ' ' + criteriaDiv.find('.criteria_op').first().val();
-        query += ' `' + Functions.escapeBacktick(criteriaDiv.find('.tableNameSelect').first().val()) + '`.';
-        query += '`' + Functions.escapeBacktick(criteriaDiv.find('.columnNameSelect').first().val()) + '`';
-    }
-    return query;
-}
-
-// eslint-disable-next-line no-unused-vars
-function generateWhereBlock () {
-    var count = 0;
-    var query = '';
-    $('.tableNameSelect').each(function () {
-        var criteriaDiv = $(this).siblings('.slide-wrapper').first();
-        var useCriteria = $(this).siblings('.criteria_col').first();
-        if ($(this).val() !== '' && useCriteria.prop('checked')) {
-            if (count > 0) {
-                criteriaDiv.find('input.logical_op').each(function () {
-                    if ($(this).prop('checked')) {
-                        query += ' ' + $(this).val() + ' ';
-                    }
-                });
-            }
-            query += generateCondition(criteriaDiv, $(this));
-            count++;
-        }
-    });
-    return query;
-}
-
-function generateJoin (newTable, tableAliases, fk) {
-    var query = '';
-    query += ' \n\tLEFT JOIN ' + '`' + Functions.escapeBacktick(newTable) + '`';
-    if (tableAliases[fk.TABLE_NAME][0] !== '') {
-        query += ' AS `' + Functions.escapeBacktick(tableAliases[newTable][0]) + '`';
-        query += ' ON `' + Functions.escapeBacktick(tableAliases[fk.TABLE_NAME][0]) + '`';
-    } else {
-        query += ' ON `' + Functions.escapeBacktick(fk.TABLE_NAME) + '`';
-    }
-    query += '.`' + fk.COLUMN_NAME + '`';
-    if (tableAliases[fk.REFERENCED_TABLE_NAME][0] !== '') {
-        query += ' = `' + Functions.escapeBacktick(tableAliases[fk.REFERENCED_TABLE_NAME][0]) + '`';
-    } else {
-        query += ' = `' + Functions.escapeBacktick(fk.REFERENCED_TABLE_NAME) + '`';
-    }
-    query += '.`' + fk.REFERENCED_COLUMN_NAME + '`';
-    return query;
-}
-
-function existReference (table, fk, usedTables) {
-    var isReferredBy = fk.TABLE_NAME === table && usedTables.includes(fk.REFERENCED_TABLE_NAME);
-    var isReferencedBy = fk.REFERENCED_TABLE_NAME === table && usedTables.includes(fk.TABLE_NAME);
-    return isReferredBy || isReferencedBy;
-}
-
-function tryJoinTable (table, tableAliases, usedTables, foreignKeys) {
-    for (var i = 0; i < foreignKeys.length; i++) {
-        var fk = foreignKeys[i];
-        if (existReference(table, fk, usedTables)) {
-            return generateJoin(table, tableAliases, fk);
-        }
-    }
-    return '';
-}
-
-function appendTable (table, tableAliases, usedTables, foreignKeys) {
-    var query = tryJoinTable (table, tableAliases, usedTables, foreignKeys);
-    if (query === '') {
-        if (usedTables.length > 0) {
-            query += '\n\t, ';
-        }
-        query += '`' + Functions.escapeBacktick(table) + '`';
-        if (tableAliases[table][0] !== '') {
-            query += ' AS `' + Functions.escapeBacktick(tableAliases[table][0]) + '`';
-        }
-    }
-    usedTables.push(table);
-    return query;
-}
-
-// eslint-disable-next-line no-unused-vars
-function generateFromBlock (tableAliases, foreignKeys) {
-    var usedTables = [];
-    var query = '';
-    for (var table in tableAliases) {
-        if (tableAliases.hasOwnProperty(table)) {
-            query += appendTable(table, tableAliases, usedTables, foreignKeys);
-        }
-    }
-    return query;
-}
-- 
cgit