Sublime Plugin : SQL格式化插件
标签(空格分隔): SublimePlugin
安装SublimeFormatSQL
- Add Repository
- Crtl + Shift + p 调出 package control,输入 add repository,确定
- 输入 github 仓库地址,例如 https://github.com/bani/SublimeFormatSQL (Notice:结尾的.Git要去掉)
- 安装SublimeFormatSQL
- Crtl + Shift + p 调出 package control,输入 install package,确定,然后再输入 github 仓库的名称,比如 SublimeFormatSQL,确定安装。
Reference: Add Repository
SublimeFormatSQL
This is a fork from SublimeFormatSQL that fixes a known issue with Sublime Text 2. There will be no support for Sublime Text 3.
Because this isn't an official package, you can follow this instructions to install.
From the original README:
Summary
FormatSQL formats long SQL statement to a more readable form by using python-sqlparse library.
How to Use
select sql and click menu Selection -> Format -> SQL
Configure key binding
add the following line to keymap settings
{ "keys": ["super+k", "super+s"], "command": "format_sql" },
Example
Original:
select a,b from foo join bar on val1 = val2 where id = 123 and cd = 99;
Formated:
SELECT a,
b
FROM foo
JOIN bar ON val1 = val2
WHERE id = 123
AND cd = 99;
License
python-sqlparse library and this code are both on 2-clauses BSD