sql-formatter
A Sublime Text plugin that runs the cli-sql-formatter node library on the current file
Details
Installs
- Total 38K
- Win 19K
- Mac 15K
- Linux 4K
Jul 27 | Jul 26 | Jul 25 | Jul 24 | Jul 23 | Jul 22 | Jul 21 | Jul 20 | Jul 19 | Jul 18 | Jul 17 | Jul 16 | Jul 15 | Jul 14 | Jul 13 | Jul 12 | Jul 11 | Jul 10 | Jul 9 | Jul 8 | Jul 7 | Jul 6 | Jul 5 | Jul 4 | Jul 3 | Jul 2 | Jul 1 | Jun 30 | Jun 29 | Jun 28 | Jun 27 | Jun 26 | Jun 25 | Jun 24 | Jun 23 | Jun 22 | Jun 21 | Jun 20 | Jun 19 | Jun 18 | Jun 17 | Jun 16 | Jun 15 | Jun 14 | Jun 13 | Jun 12 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Windows | 0 | 7 | 8 | 10 | 9 | 5 | 2 | 1 | 8 | 6 | 16 | 12 | 11 | 2 | 2 | 9 | 6 | 7 | 4 | 12 | 1 | 2 | 5 | 7 | 6 | 11 | 8 | 2 | 1 | 7 | 11 | 11 | 7 | 8 | 0 | 2 | 6 | 9 | 14 | 8 | 4 | 3 | 2 | 7 | 9 | 8 |
Mac | 0 | 5 | 9 | 3 | 11 | 5 | 1 | 1 | 5 | 9 | 8 | 10 | 7 | 2 | 5 | 5 | 9 | 7 | 8 | 4 | 1 | 2 | 8 | 10 | 5 | 10 | 7 | 0 | 4 | 10 | 6 | 11 | 12 | 10 | 2 | 1 | 7 | 10 | 10 | 6 | 8 | 1 | 1 | 8 | 10 | 10 |
Linux | 0 | 2 | 2 | 3 | 4 | 4 | 1 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 0 | 2 | 1 | 3 | 0 | 1 | 5 | 2 | 4 | 2 | 1 | 1 | 0 | 0 | 4 | 0 | 2 | 1 | 0 | 1 | 2 | 0 | 2 | 2 | 3 | 0 | 1 | 1 | 7 | 2 |
Readme
- Source
- raw.githubusercontent.com
sublime-sql-formatter
A Sublime Text plugin that runs the cli-sql-formatter node library on the current file. cli-sql-formatter is in turn a command line interface for the sql-formatter node library.
Installation
Dependencies
This plugin requires node.js, and also requires cli-sql-formatter to be globally installed.
npm install -g cli-sql-formatter
Plugin Installation
This plugin is installable via Package Control
To install via Package Control, do the following:
Within Sublime Text, bring up the Command Palette and type
install
. Among the commands you should seePackage Control: Install Package
. If that command is not highlighted, use the keyboard or mouse to select it. There will be a pause of a few seconds while Package Control fetches the list of available plugins.When the plugin list appears, type
sql-formatter
. Among the entries you should seesql-formatter
. Select this entry to install it.
Commands
Command Palette
Format SQL
: Runs the formatter with the default dialect defined in your settings.Format SQL With Dialect
: Runs the formatter with a dialect of your choosing.
Default Hotkeys
By default, these hotkeys will run the formatter with the default dialect defined in your settings.
- Linux/Windows: [Ctrl + KQ]
- Mac: [Cmd + KQ]
Settings
By default the following settings are used:
{
// The paths to look for executables
"paths": {
"linux": [],
"osx": [],
"windows": []
},
// The default dialect to use for formatting
// Options:
// "sql" - Standard SQL
// "n1ql" - Couchbase N1QL
// "db2" - IBM DB2
// "pl/sql" - Oracle PL/SQL
"default_dialect": "sql",
// The number of spaces to indent with
"indent_size": 2,
// Indent with tabs instead of spaces
"use_tabs": false
}
You can modify any settings by going to Preferences > Package Settings > sql-formatter > Settings.
Project-Specific Settings Override
To override global plugin configuration for a specific project, add a settings object with an sql-formatter
key in your .sublime-project
. This file is accessible via Project -> Edit Project
.
For example:
{
"folders": [
{
"path": "."
}
],
"settings": {
"use_tabs": true
}
}