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.allowSelfSignedCertificates: Set to true if you are using an internal MOCA server with a self-signed certificate.
  • boolean, default is false
• neermoca.resultSetExportFormat: Set the format for exporting a moca result set.
  • string, valid values are csv, json, or xml
  • default is csv
• neermoca.repoBuildConcurrency: The maximum number of concurrent oparations permitted when building the command repository cache.
  • integer, default is 25

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>.

Preview Files in the LES Directory

You can now click on the download icon in files in the LES Directory Explorer to open a new tab with the contents of the file. If the file is more than 1 MB in size, you will get a warning before proceeding. If the file is more than 10 MB in size, download will not be available.

Known Issues

• No known issues at this time.

Release Notes

See the change log for more detailed release notes.

[0.4.0]

• Added the ability to preview MOCA command files from MOCA server.

[0.3.1]

• Downloaded file from LES directory rather than just opening a text document with the contents. This should better handle binary files.

[0.3.0]

• Added download option for files less tha 10 MB in the LES directory.

[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