/
Auto-complete of tables and columns in "Query Database" section [5.3.0-B1]

Auto-complete of tables and columns in "Query Database" section [5.3.0-B1]

Mar 19, 2016

In the https://in-portal.atlassian.net/browse/INP-1174 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.

Solution

  1. create "adm:CodeMirrorDatabaseHintOptions", that, that will:

    1. store results in memcache for 1 hour

    2. get database tables matching used TablePrefix

    3. get column names of these tables

    4. build up a JSON-encoded array from that data

    5. return it

  2. on the "tools/sql_query" template add "hintOptions" to CodeMirror options, that's content would look like: {tables: <inp2:adm:CodeMirrorDatabaseHintOptions/>}

 

Copied from http://codemirror.net/mode/sql/ page source:

hintOptions: { tables: { users: {name: null, score: null, birthDate: null}, countries: {name: null, population: null, size: null} } }

Related Discussions

Related Tasks