JavaScript - Palabras reservadas

// Lista de sugerencias

var suggestions = ["SELECT", "FROM", "WHERE", "INSERT", "UPDATE", "DELETE", "CREATE", "ALTER", "DROP", "INDEX",

"AND", "OR", "NOT","ALL", "ALTER", "ANALYZE", "AND", "AS", "ASC", "ASENSITIVE", "BEFORE", "BETWEEN", "BIGINT",

"BINARY", "BLOB", "BOTH", "BY", "CALL", "CASCADE", "CASE", "CHANGE", "CHAR", "CHARACTER", "CHECK", "COLLATE",

"COLUMN", "CONDITION", "CONNECTION", "CONSTRAINT", "CONTINUE", "CONVERT", "CROSS", "CURRENT_DATE",

"CURRENT_TIME", "CURRENT_TIMESTAMP", "CURRENT_USER", "CURSOR", "DATABASE", "DATABASES", "DAY_HOUR", "DAY_MICROSECOND",

"DAY_MINUTE", "DAY_SECOND", "DEC", "DECIMAL", "DECLARE", "DEFAULT", "DELAYED", "DELETE", "DESC", "DESCRIBE", "DETERMINISTIC",

"DISTINCT", "DISTINCTROW", "DIV", "DOUBLE", "DROP", "DUAL", "EACH", "ELSE", "ELSEIF", "ENCLOSED", "ESCAPED", "EXISTS", "EXIT", "EXPLAIN",

"FALSE", "FETCH", "FLOAT", "FOR", "FORCE", "FOREIGN", "FROM", "FULLTEXT", "GOTO", "GRANT", "GROUP", "HAVING", "HIGH_PRIORITY", "HOUR_MICROSECOND",

"HOUR_MINUTE", "HOUR_SECOND", "IF", "IGNORE", "IN", "INDEX", "INFILE", "INNER", "INOUT", "INSENSITIVE", "INSERT", "INT", "INTEGER", "INTERVAL",

"INTO", "IS", "ITERATE", "JOIN", "KEY", "KEYS", "KILL", "LEADING", "LEAVE", "LEFT", "LIKE", "LIMIT", "LINES", "LOAD", "LOCALTIME", "LOCALTIMESTAMP",

"LOCK", "LONG", "LONGBLOB", "LONGTEXT", "LOOP", "LOW_PRIORITY", "MATCH", "MEDIUMBLOB", "MEDIUMINT", "MEDIUMTEXT", "MIDDLEINT", "MINUTE_MICROSECOND",

"MINUTE_SECOND", "MOD", "MODIFIES", "NATURAL", "NOT", "NO_WRITE_TO_BINLOG", "NULL", "NUMERIC", "ON", "OPTIMIZE", "OPTION", "OPTIONALLY", "OR",

"ORDER", "OUT", "OUTER", "OUTFILE", "PRECISION", "PRIMARY", "PROCEDURE", "PURGE", "READ", "READS", "REAL", "REFERENCES", "REGEXP", "RENAME",

"REPEAT", "REPLACE", "REQUIRE", "RESTRICT", "RETURN", "REVOKE", "RIGHT", "RLIKE", "SCHEMA", "SCHEMAS", "SECOND_MICROSECOND", "SELECT",

"SENSITIVE", "SEPARATOR", "SET", "SHOW", "SMALLINT", "SONAME", "SPATIA", "SPECIFIC", "SQL", "SQLEXCEPTION", "SQLSTATE", "SQLWARNING",

"SQL_BIG_RESULT", "SQL_CALC_FOUND_ROWS", "SQL_SMALL_RESULT", "SSL", "STARTING", "STRAIGHT_JOIN", "TABLE", "TERMINATED", "THEN", "TINYBLOB",

"TINYINT", "TINYTEXT", "TO", "TRAILING", "TRIGGER", "TRUE", "UNDO", "UNION", "UNIQUE", "UNLOCK", "UNSIGNED", "UPDATE", "USAGE", "USE", "USING",

"UTC_DATE", "UTC_TIME", "UTC_TIMESTAMP", "VALUES", "VARBINARY", "VARCHAR", "VARCHARACTER", "VARYING", "WHEN", "WHERE", "WHILE", "WITH", "WRITE",

"XOR", "YEAR_MONTH", "ZEROFILL"];

// Detectar la entrada del usuario

var codeInput = document.getElementById("code-input");

var suggestionsList = document.getElementById("suggestions");

codeInput.addEventListener("keydown", function(event) {

  var key = event.keyCode || event.which;

  if (key === 9) { // Tab key

    event.preventDefault();

    var input = this.value;

    var lastWord = getLastWord(input);

    for (var i = 0; i < suggestions.length; i++) {

      if (suggestions[i].toLowerCase().startsWith(lastWord.toLowerCase())) {

        var suggestion = suggestions[i];

        var updatedInput = input.substr(0, input.lastIndexOf(lastWord)) + suggestion;

        this.value = updatedInput;

        break;

      }

    }

  }

});

codeInput.addEventListener("input", function() {

  var input = this.value;

  var lastWord = getLastWord(input);

  var matchingSuggestions = [];

  for (var i = 0; i < suggestions.length; i++) {

    if (suggestions[i].toLowerCase().startsWith(lastWord.toLowerCase())) {

      matchingSuggestions.push(suggestions[i]);

    }

  }

  showSuggestions(matchingSuggestions);

});

function showSuggestions(matchingSuggestions) {

  suggestionsList.innerHTML = "";

  for (var i = 0; i < matchingSuggestions.length; i++) {

    var suggestion = document.createElement("a");

    suggestion.innerHTML = matchingSuggestions[i];

    suggestion.addEventListener("click", function() {

      var input = codeInput.value;

      var lastWord = getLastWord(input);

      var updatedInput = input.substr(0, input.lastIndexOf(lastWord)) + this.innerHTML;

      codeInput.value = updatedInput;

      suggestionsList.style.display = "none";

    });

    suggestionsList.appendChild(suggestion);

  }

  if (matchingSuggestions.length > 0) {

    suggestionsList.style.display = "block";

  } else {

    suggestionsList.style.display = "none";

  }

}

// Obtener la última palabra ingresada por el usuario, incluso si está dentro de símbolos

function getLastWord(input) {

  var words = input.split(" ");

  var lastWord = words[words.length - 1];

  // Verificar si la última palabra está dentro de símbolos

  var symbols = ["(", ")", "{", "}", "[", "]", ";", ",", ".", "'", "\""];

  while (symbols.includes(lastWord.charAt(0))) {

    lastWord = lastWord.substr(1);

  }

  return lastWord;

}

// Botón para descargar en .sql

document.getElementById("download-btn").addEventListener("click", function() {

  var content = codeInput.value;

  var filename = "archivo.sql";

  var blob = new Blob([content], {type: "text/plain;charset=utf-8"});

  var link = document.createElement("a");

  link.setAttribute("href", window.URL.createObjectURL(blob));

  link.setAttribute("download", filename);

  link.click();

});

// Quitar linea roja de ortografia

var textInputs = document.querySelectorAll('input[type="text"], textarea');

textInputs.forEach(input => {

  input.spellcheck = false;

});