Skip to content

Sublime Text 2 command to format long SQL statement to a more readable form (also available via Package Control)

License

Notifications You must be signed in to change notification settings

bani/SublimeFormatSQL

 
 

Repository files navigation

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

About

Sublime Text 2 command to format long SQL statement to a more readable form (also available via Package Control)

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%