AccuTermClient

AccuTerm client is a plugin for Sublime Text allows you to connect to a MultiValue server using AccuTerm. This plugin allows for source code editing and compiling on remote MV servers as well as executing commands and using the native data conversion processing codes (OCONV/ICONV).

Features

Standard Features

These features will work with all MV DBMS that support Accuterm.

Download & upload files
Compile source code
Lock/Unlock items on the MultiValue server
Iconv/Oconv from Sublime
Run currently open file
Execute commands on the MV Server and display output in Sublime
Global case change while preserving case in comments & strings

Extended Features

These features require DBMS specific configuration to run. D3, QM, and jBASE are configured automatically. Additional DBMS can be setup manually (see the Settings section below).

Prev/Next compile error
Browse command stack
Browse files on MV server (jBASE Windows not supported)

Requirements

Sublime Text 3
PyWin32 Sublime Package
Windows Operating System
AccuTerm terminal emulator running the FTSERVER program

Installation

Using Sublime Package Manager

Package Control: Install
AccuTermClient

Using Github

cd %appdata%\Sublime Text 3\Packages
git clone https://github.com/ianharper/AccuTermClient.git
Install the PyWin32 Sublime package.

Usage

This package connects to your MV database using AccuTerm's FTSERVER program. To use, launch AccuTerm and run FTSERVER from TCL. AccuTermClient will connect to the AccuTerm server with no additional configuration.

This package expects that all files on your local machine to be contained in a folder that matches the file on the MV server. Files will be named on your local machine with a ".bp" suffix. When uploaded to the MV server this suffix will be removed. Example: C:\code\BP\HELLO.WORLD.bp will be uploaded to BP HELLO.WORLD in the account that FTSERVER is running in.

Commands

Open - Download item from MV server by entering MV file reference. Will lock item on MV server if open_with_readu setting is true.
Open (Read Only) - Download item from MV sever without locking by entering MV file reference.
Upload - Upload current file to MV server.
Compile - Compile Current file on MV server.
Release - Release lock of current file on MV server.
Release All - Release all locks held by current user on MV server.
Unlock - unlock item on MV server by entering MV file reference.
Refresh - Update currently open file in Sublime from MV server and lock item on MV server.
Check Sync (Current File) - Compare the currently open file to the item on the MV server. If the item on the MV server is different than the local file you will be asked if you want to download the changes from the MV server.
List - Browse files on MV server using Sublime's command palate, select item with enter to download.
Lock - Lock item on MV server by entering MV file reference.
Execute - Run commands on MV server and show output in Sublime (to console, new file, or append to current file).
Run - Run the currently open file. If the item is in the MD/VOC then the item name will be used to run (enables running PROC, PARAGRAPH, or MACRO commands).
Iconv/Oconv - Convert data using the MV server's iconv/oconv functions.
Global Upcase - Convert case of currently open file to uppercase while preserving case in strings and comments.
Global Downcase - Convert case of currently open file to lowercase while preserving case in strings and comments.

Settings

The settings can be accessed in the Preferences>Package Settings>AccuTermClient>Settings. The settings are in json format. Each top level key-value pair will be explained below. Some settings are specific to the MV DBMS, they will have a second key that specifies the DBMS. This key for your DBMS can be found in ACCUTERM,ACCUTERMCTRL, KMTCFG<51>. These settings can be set for general editing in Sublime or for specific Sublime projects.

Setting Key	Description
multivalue_syntaxes	List of MV syntaxes. Referenced to determine if a file in Sublime is MultiValue.
default_save_location	Location to save MV files by default. When editing a file in a Sublime project the project folder will be used instead.
remove_file_extensions	File extensions to remove when uploading to the MV server.
compile_command	Command to execute when the Sublime Build command is run.
open_with_readu	Lock files on MV server when opening.
result_line_regex	Regular expression used to find the line number of compile errors. See exec Target Options in the Sublime Docs for details.
list_files_command	Command to list all the files in the account. Used in the AccuTermClient List command. The output must contain only the file name, one per line.
list_command	This command is run after a file is chosen from the List command. The value is appended to a "SORT (filename) " command to limit the output to only the item names.
syntax_file_locations	List of MV syntaxes to apply after downloading. The default values come from the MultiValue Basic Sublime package
command_history	MV file and item for the command stack.

Custom Commands

Custom commands can be easily added from Preferences>Package Settings>AccuTermClient>Custom Commands. When added these commands will be shown in Sublime's command palate. The syntax for these commands follows Sublime's command syntax which is in JSON format (with comments).

Example:

[
  {
    // Name the command
    "caption": "Term - Disable page breaks",
    // Set the Sublime command to run
    "command": "accu_term_execute",
    // Set the command to run on the MV server and where to show the output (console, new, append, or replace).
    "args": { "command": "TERM 150,0", "output_to": "console"}
   }
]

Todo

Add support for jBASE windows.
Set MV syntax automatically based on DBMS type and file contents (ex. PQ in line 1 should set PROC).
Allow file extensions to be set based on DBMS type and file contents (ex. PQ in line 1 should set proc ext.).