In the - INP-1174Getting issue details... STATUS the task the CodeMirror (see https://codemirror.net/) editor was added to "Tools > Query Database" section. This allowed to have syntax highlighting and line numbering to enhance use experience.
To make user experience even better proposing to enable auto-complete of tables and their column names.
- create "
adm:CodeMirrorDatabaseHintOptions", that, that will:
- store results in memcache for 1 hour
- get database tables matching used TablePrefix
- get column names of these tables
- build up a JSON-encoded array from that data
- return it
on the "
tools/sql_query" template add "
hintOptions" to CodeMirror options, that's content would look like:
Copied from http://codemirror.net/mode/sql/ page source: