chili

Features

This extension provides chili and pepper language support:

• chili syntaxes
• pepper syntaxes
• chili notebook(*.chnb)
• processes group by tags
• process explorer
• query mode
  • grid powered by ag-grid-community & plotly
  • visualization powered by perspective
• language server powered by tree-sitter
  • linter
  • formatter
  • rename symbol (F2)
  • go to definition (F12)
  • go to reference (Shift+F12)
  • workspace symbol (Ctrl+T)
  • document highlight
  • document symbol (Ctrl+Shift+O)
  • completion
    • identifiers defined in code
    • identifiers defined on kdb+ process
    • column names define on kdb+ process
  • completion resolve
  • signature help
  • semantic highlights
  • call hierarchy

chiz Installation

pip install chiz

For windows, use where_exe to find the path of chiz after installation.

Configuration

• To configure globally, type ctrl+, to open Settings, filter the configuration by chili and change the following values.
• To configure for workspace, type ctrl+shift+p, call Preferences: Open Workspace Settings, filter the configuration by chili and change the following values.

chili Language Server

This uses chiz to provide language server features.

chili Notebook

Files with postfix *.chnb are using notebook feature. There are 2 output mode for chili notebook, switch to following query mode for different output format

• Console -> notebook console
• Grid -> notebook html
• Visualization -> notebook html

Chart for Notebook(Pending)

Enable Grid or Visualization mode, insert // @chart lines to a chili notebook cell as the first comment and execute.

Limitations:

• use the first non-number column as label
• support up to 9 series in line/bar/histogram chart
• support up to 4 pair of series in scatter chart

Panel

Processes

List processes, click to switch process. Generate tree structure from tags.

Special tag color:

• green: dev, development
• blue: uat
• red: prd, prod.

Discovery Server

The url should be a REST API endpoint, which returns a list of {host:string, port:number, label:string}. The returned list will be added to Processes panel, but it won't be saved on disk.

Process Explorer

List variables defined on the active server.

Query History

Record query histories.

Query Mode

Type ctrl+shift+p and call chili: Switch Query Mode to switch Query Console.

Visualization

Visualization, powered by perspective, can pivot and virtualize table data. In Visualization mode, only table will be showed in a webview, but other result will still be in output. It will limit to 10000 rows when query a table, click the flame in PROCESSES panel , or call chili: Toggle Unlimited Query, to remove 10000 rows limit. Be noted that, Visualization only supports millisecond precision.

Grid

Grid, powered by ag-grid-community and plotly, can filter and sort table data. In Grid mode, only table will be showed in a webview, but other result will still be in output. It will limit to 10000 rows when query a table, click the flame in PROCESSES panel , or call chili: Toggle Unlimited Query, to remove 10000 rows limit. Grid supports nanosecond precision.

Console(default)

Output console to an output channel. Configure Console Size for Output to change console size for table type output. For non-table type console size, use system "c rows columns" to change console size.

Commands

Connect to Process

Type ctrl+shift+p and call chili: Connect to Process to connect to a process.

Shortcuts

• ctrl+q: query current line
• ctrl+r: query selection
• ctrl+e: query block
• ctrl+shift+q: send current line to terminal
• ctrl+shift+r: send selection to terminal
• ctrl+shift+e: send block to terminal

To change shortcuts

1. type ctrl+shift+p
2. input "shortcut"
3. open the Keyboard Shortcuts
4. search for "chili".

Tips

Enable Auto Scrolling for Output Channel

1. Type ctrl+comma(,), open Settings, disable Output>Smart Scroll.
2. Turn on Auto Scrolling by clicking a small locker icon on the right top of output channel.

Disable Word Wrap in chili Console of Output

Type ctrl+shift+p, call Open Setting(Json), and add following configuration.

    "[Log]": {
        "editor.wordWrap": "off"
    }

No Color in chili Output

There may be a conflict with other extensions. Disable or uninstall them and try again.

Enable Highlight for Attention And TODO of comments

Type ctrl+shift+p, call Open Setting(Json), and add following configuration.

    "editor.tokenColorCustomizations": {
        "textMateRules": [
            {
                "scope":"comment.line.attention",
                "settings": {
                    "fontStyle": "italic",
                    "foreground": "#B71C1C"
                }
            },
            {
                "scope":"comment.line.todo",
                "settings": {
                    "fontStyle": "italic",
                    "foreground": "#2E7D32"
                }
            }
        ]
    }

Special Comment

Querying comment line /<=> quant,prod,local-1800 will connect to quant,prod,local-1800. Type ctrl+shift+p, call chili: Insert Active Connection Label to insert active connection label.