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

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