☰

Oracle iAcademy suckless

Basic Syntax Highlighting and Auto-Completion. Enter key intelligently Auto-completes or Auto-Runs the query. Table names completion NYI.

  1. // ==UserScript==
  2. // @name         Oracle iAcademy suckless
  3. // @namespace    http://tampermonkey.net/
  4. // @version      0.2.2
  5. // @description  Basic Syntax Highlighting and Auto-Completion. Enter key intelligently Auto-completes or Auto-Runs the query. Table names completion NYI.
  6. // @author       You
  7. // @match        https://iacademy.oracle.com/*
  8. // @require      https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/codemirror.js
  9. // @require      https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/addon/hint/show-hint.js
  10. // @require      https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/addon/hint/sql-hint.js
  11. // @require      https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/mode/sql/sql.js
  12. // @require      https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/addon/selection/active-line.js
  13. // @require      https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/addon/edit/matchbrackets.js
  14. // ==/UserScript==
  15.  
  16. // Like this? Share with your class! Send them a link to:
  17. // https://greasyfork.org/en/scripts/25355-oracle-iacademy-suckless
  18.  
  19. // Know javascript? Please Takeover! I wrote this on the last day of class, there is lots of room for improvement!
  20. // Post your forks on greasyfork and send me a link in feedback. I will redirect people to the most up-to-date script.
  21.  
  22. function importScript(src) {
  23.     var script = document.createElement('script');
  24.     script.type = "text/javascript";
  25.     script.src = src;
  26.     document.body.appendChild(script);
  27.     return script;
  28. }
  29. function importCSS(src) {
  30.     var script = document.createElement('link');
  31.     script.type = "text/css";
  32.     script.rel='stylesheet';
  33.     script.href = src;
  34.     document.head.appendChild(script);
  35.     return script;
  36. }
  37. importCSS("https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/codemirror.css");
  38. importCSS("https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/addon/hint/show-hint.css");
  39.  
  40. importCSS("https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.21.0/theme/neonsyntax.css");
  41. //importScript();
  42.  
  43. // Wait a second or lineNumber will develop a overlaping problem
  44. setTimeout(function() {
  45.  
  46.     
  47. var ExcludedIntelliSenseTriggerKeys =
  48. {
  49.     "8": "backspace",
  50.     "9": "tab",
  51.     "13": "enter",
  52.     "16": "shift",
  53.     "17": "ctrl",
  54.     "18": "alt",
  55.     "19": "pause",
  56.     "20": "capslock",
  57.     "27": "escape",
  58.     "33": "pageup",
  59.     "34": "pagedown",
  60.     "35": "end",
  61.     "36": "home",
  62.     "37": "left",
  63.     "38": "up",
  64.     "39": "right",
  65.     "40": "down",
  66.     "45": "insert",
  67.     "46": "delete",
  68.     "91": "left window key",
  69.     "92": "right window key",
  70.     "93": "select",
  71.     "107": "add",
  72.     "109": "subtract",
  73.     "110": "decimal point",
  74.     "111": "divide",
  75.     "112": "f1",
  76.     "113": "f2",
  77.     "114": "f3",
  78.     "115": "f4",
  79.     "116": "f5",
  80.     "117": "f6",
  81.     "118": "f7",
  82.     "119": "f8",
  83.     "120": "f9",
  84.     "121": "f10",
  85.     "122": "f11",
  86.     "123": "f12",
  87.     "144": "numlock",
  88.     "145": "scrolllock",
  89.     "186": "semicolon",
  90.     "187": "equalsign",
  91.     "188": "comma",
  92.     "189": "dash",
  93.     "190": "period",
  94.     "191": "slash",
  95.     "192": "graveaccent",
  96.     "220": "backslash",
  97.     "222": "quote"
  98. };
  99.  
  100.  
  101. var RunBtn = document.getElementsByClassName('aButton hotButton')[0];
  102. var RunSQL_Cmd;
  103. if (RunBtn.textContent == 'Run') {
  104.     RunSQL_Cmd = RunBtn.onclick;
  105. }
  106.     
  107. var SQL_Box = document.getElementById('P1003_SQL_COMMAND1');
  108.     CodeMirror.commands.autocomplete = function(cm) {
  109. 			CodeMirror.showHint(cm, CodeMirror.hint.sql);
  110. 		};
  111.     var SQL_Mirror = CodeMirror.fromTextArea(SQL_Box, {
  112.     mode: "text/x-sql",
  113.     //theme: "neonsyntax",
  114.     lineWrapping: true,
  115.     lineNumbers: true,
  116.     styleActiveLine: true,
  117.     extraKeys: {
  118. 					"Ctrl-Space": "autocomplete"
  119. 				},
  120.     matchBrackets: true,
  121.   });
  122.     SQL_Mirror.on("keyup", function(editor, event) {
  123.         var __Cursor = editor.getDoc().getCursor();
  124.         var __Token = editor.getTokenAt(__Cursor);
  125.  
  126.         if (!editor.state.completionActive &&
  127.             !ExcludedIntelliSenseTriggerKeys[(event.keyCode || event.which).toString()] &&
  128.             (__Token.type == "tag" || __Token.string == " " || __Token.string == "<" || __Token.string == "/" ))
  129.         {
  130.             CodeMirror.commands.autocomplete(editor, null, { completeSingle: false });
  131.         } else if (event.keyCode == 13 && event.shiftKey === false) {
  132.             RunSQL_Cmd();
  133.             // TODO eat the enter keypress
  134.         }
  135.     });
  136.     SQL_Mirror.setSize(SQL_Box.style.width, '100%');
  137.     SQL_Mirror.on("change", function(cm, change) { cm.save(); });
  138.  
  139.  
  140.  
  141.     
  142. }, 1000);