sqlcl-codescan README

This extension adds the SQLcl codescan ability to VS Code

Features

Allows the usage of SQLcl codescan in VS code for any given sql file

Requirements

A working installation of SQLcl above version 23

Extension Settings

This extension contributes the following settings:

• sqlclCodescan.checkOnSave: Check files on save
• sqlclCodescan.checkOnOpen: Check files on open
• sqlclCodescan.sqlClPath: Path to sqlcl executable
• sqlclCodescan.ignorePaths: List of paths to ignore similar to .gitignore
• sqlclCodescan.enableFormatting: Enable sql formatting
• sqlclCodescan.formattingRulePath: Path to advanced formatting rules xml
• sqlclCodescan.tvdFormatterPath: Path to format.js to load tvdformatter script
• sqlclCodescan.tvdArboriPath: Path to tvd custom formatting arbori file
• sqlclCodescan.websiteInfo: URL where details about the rules can be found

Known Issues

Release Notes

1.0.0

Initial release of sqlcl-codescan

1.1.0

Added severity level to diagnostics Added code formatting capability

1.1.1

Added support for UTF-8 BOM encoded files Showing results in vscode output channel

1.1.2

Refactored stdin/out handling for sqlcl Improved output channel info Improved error handling for failing scans

1.1.3

Fixed handling when no error occured