Skip to content

freewizard/SublimeFormatSQL

master
Switch branches/tags
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 
 
 
 
 

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)

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages