SQL Formatting Plugin

[freewizard]

Hi,

I've written a plugin that formats long SQL statement to a more readable form by using python-sqlparse library.

You may install via Package Control, or find manual setup instructions and examples here: https://github.com/freewizard/SublimeFormatSQL

[theadamlt]

Hi,

I just installed this plugin, but i can't make it work. When i select my SQL statement in a PHP file and click menu "Selection", i don't see any menu called "Format". I'm running Ubuntu 11.10 32bit.

Thank you for creating an awesome plugin like this

Thank you in advance
Adam

[freewizard]

Hi,

I just installed this plugin, but i can't make it work. When i select my SQL statement in a PHP file and click menu "Selection", i don't see any menu called "Format". I'm running Ubuntu 11.10 32bit.

Thank you for creating an awesome plugin like this

Thank you in advance
Adam

Hi,
I tested it with a fresh installed latest dev build (b2160) on my Mac and works ok.

As a troubleshooting step, could you open console and see if the plugin get loaded like this without any error:

Code: Select all

Reloading plugin /Users/xxxx/Library/Application Support/Sublime Text 2/Packages/Format SQL/FormatSQL.py


Also if it did load, can you check if the key bind config mentioned in the web site works?

[jtreher]

Hello. Thanks for the plugin.

Of note, this seems to have problems whenever brackets are present. I had to remove all of my brackets from the sql for it to work.

[thecrumb]

This is a great plugin!

Anyone know if it's possible to get comma first formatting with this?

select joe
, bob
, sue

I've tinkered with the settings but so far no luck.

Thanks for great plugin, it's a huge timesaver!

Jim