nzsql for Visual Studio Code

Features

Execute highlighted SQL queries in nzsql.

How to use this extension:

1. Select queries by one of the following ways:

• Put the cursor on the line of the query
• Hold Option key (mac) and select multiple lines
• Highlight a range of queries
• Hold Option key (mac) and highlight multiple ranges of queries

  Tip: You don't have highlight the entire line, the extension works even when only a portion of the line is highlighted

2. Press Ctrl + Enter

Requirements

This extension requires nzsql utility - A IBM Netezza's Linux command line SQL client - installed in the host machine.

User settings

One can set a custom path for nzsql binary, nzsql command line options and spin files to watch for in settings.json. For example:

{
    ...
    "nzsql.path": "/home/nz/nps/main/debug/bin/nzsql",
    "nzsql.args": ["-d", "dev", "-e"],
    "nzsql.spinFiles": [
        "spin_hugh",
        "spin_spu",
    ],
    "nzsql.legacy": false
    ...
}

To see the full list of supported nzsql options, run this command in terminal nzsql -h

NOTE: Please do not use -f option as it is preserved for this extension.

Release Notes

1.0.0

Initial release of nzsql

1.0.1

Remove line numbers in the error messages

1.0.2

Do not show the terminal command in vscode's integrated terminal Output the result to a vscode's output channel instead of a built-in terminal window

1.0.3

Add syntax highlighting (log) to the output

1.0.4

Output is more responsive when running a large amount of queries at once

1.0.5

Preserve focus when showing output channel

1.0.6

Source ~/.bashrc before executing nzsql command to ensure nzsql is in $PATH

1.0.7

Show client and server version at the beginning of the output

1.0.8

Add user settings: nzsql.path and nzsql.args

1.0.9

Add keyboard shortcut for the extension: Ctrl + Enter (Mac and Windows)

1.0.10

Remove client and server version

1.0.11

Support a status bar item that shows the status of NPS server

1.0.12

Make the status bar item disappear when NPS server's state can't be determined

1.1.0

Add the ability to attach gdb debugger to processes emiting spin files

2.0.0

Include status bar icons for server status and debug status Better support for concurrent debugging sessions Not compatible with the old spin files method unless legacy mode is turned on

2.0.1

Debugger not to stop at SIG40

2.0.2

Fix spellings