Basic Syntax Highlighting and Auto-Completion. Enter key intelligently Auto-completes or Auto-Runs the query. Table names completion NYI.
Console Enhancements for iacademy.oracle.com
Adds in basic Syntax Highlighting and Auto-Completion.
Enter key intelligently Auto-completes or Auto-Runs the query.
Table names completion is NYI.
While its possible to do, table name completion would:
1) Cause delay in first load of the SQL Command Center
2) Require caching tables/columns locally to reduce lag, and thus need to intelligently sync the cache somehow.
3) Require permanent storage to remove lag between reloads/restarts.
I personally believe that all of these changes should be implemented by oracle into their site, especially since they already use the same library as I, 'codemirror' for their Script Editor. Its just a matter of updating this 10yr old site to use the new version and features (eta: 500 lines min to do it to the same quality as the rest of their site, 1000 lines and a complete rewrite of the 10yr old site to make it right).
The CLI does not support running multiple queries. As such, it should auto-run by default when enter is pressed. Or when the query is properly closed with a semicolon and enter is pressed(Give us something closer to an actual command line).
The CLI should do auto-completion, at least of the table names and columns. Finding the table names the first time is difficult, especially since queries against user_tables and other dictionaries causes the site to reject all repeated queries. Claiming the estimated run-time of the query exceeds the 2 minute cap.
Syntax highlighting isn't necessary, but its a big help. Especially for anyone with little to no experience programming.
Like this? Share with your class! Send them a link to:
https://greasyfork.org/en/scripts/25355-oracle-iacademy-suckless
Know javascript? Please Takeover! I wrote this on the last day of class (yes, I didn't submit any assignments until the last 24hrs, and spent an hr and 30min writing scripts to make it less painful. Only finished half of the "homework", but completed all tests and quizzes.), there is lots of room for improvement!
Post your forks on greasyfork and send me a link in feedback. I will redirect people to the most up-to-date script.
TODO
utilize slightly more advanced tokenizer/styler in SQL Script Editor (which uses an outdated version of codemirror). Then replace the SQL Script Editor codemirror with ours (to benefit from auto-completion).
Additional UI downfalls that we do not address:
Comments conditionally work. (Only '--' comments work, and its finky about what lines you can put them on)
All methods of looking up available tables have a 30 seconds to 2 minute delay, an may time out all subsequent queries.
