Neer Code - MOCA development support for Visual Studio Code

Neer Code lets you effortlessly connect to a MOCA server, browse the LES directory, and execute .msql scripts with ease. View query results and export them as CSV, JSON, or XML - all within VSCode.

Features

• Store connection information
• List LES directory contents
• Execute MSQL files
• List execution history
• Save results as CSV, JSON, or XML
• Browe available MOCA commands in the command explorer

Extension Settings

This extension contributes the following settings:

• neermoca.enable: Enable/disable this extension.
• neermoca.connectionInfo: Set connection information for LES.
• neermoca.executionHistory: Enable/disable execution history tracking.

Usage

The extension is automatically activated when you open a workspace with .msql or .mcmd files.

Manage Connections

Manage your list of connections in the MOCA Connection Explorer. Use the Connect button next to the connection name to connect to an instance. Once connected, you can browse the files of your $LESDIR.

Execute Queries

Pressing the Run button at the top left of your editor when you have a .msql file open will execute your query against the currently connected instance. Upon completion, results will be viewable in the MOCA Results Explorer.

View Results

A history of recent results is available in the MOCA Results Explorer. The instance name, start time, end time, and .msql file path (including an indicator if it was an unsaved version of the file) are available at the top of each result set. The save button at the top left of the MOCA Results Explorer allows you to save your results as XML, JSON, or CSV. The file format is configurable in the extension settings. The file will be saved in the root of your workspace with a file name format of <instance_name>_<timestamp>.

Known Issues

• No known issues at this time.

Release Notes

See the change log for more detailed release notes.

[0.2.2]

• Fixed bug in les explorer

[0.2.1]

• Displays the file size next to each file in the LES explorer
• Displays the created and modified date for each entry in the LES explorer in the tooltip
• Dipalays the version for each moca level in the command explorer in the tooltip

[0.2.0]

• Updated command explorer to display command arguments
• Added a delete button to result history
• Added the ability to restore a previously executed command from the result history
• Added support for refreshing a directory in the LES explorer
• Added support for refreshing the command explorer
• Added the ability to configure the amount of concurrent operations used when building the command repository cache

[0.1.3]

• Bug fixes

[0.1.2]

• Added command explorer
• Added telemetry suppport to send crash logs

[0.1.1]

• Improved navigation in the MOCA Results Explorer

[0.1.0]

• Added support for storing connection information
• Added support for listing LES directory contents
• Added support for executing MSQL files
• Added support for listing execution history