Sublime Plugin : SQL格式化插件

Sublime Plugin : SQL格式化插件

标签（空格分隔）： SublimePlugin

安装SublimeFormatSQL

  • Add Repository
  • 安装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

最后编辑于 ：
©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容