I just completed a "first functional version" of my new T-SQL formatting plugin. It uses "my" Poor Man's T-SQL Formatter C# library (to quickly test, go to http://poorsql.com).
The plugin can temporarily be downoaded from github (I'll add it to the main project page when I'm happy with it):
* First draft of Poor Man's T-SQL formatter plugin for Notepad++:
* - One command on the menu, no other functionality
* - Reformats the selected code as T-SQL
* - If there is no selection, reformats the entire file (scintilla buffer/window, rather)
* - If a parsing error is encountered, request is aborted with an error
* - Keyboards shortcut can be assigned using notepad++ built-in feature: Settings -> Shortcut Mapper…
* - If anyone has a suggestion for a default mapping, I'm all ears (the default MS ones are taken I think)
*
* Future functionality (for first "Official" release):
* - Option to format even if a parsing error is encountered
* - Default file extension check with warning if doesn't appear to be a sql file
* - option to customize list file extensions that are expected to be SQL
* - Formatting options, like in SSMS plugin or UI program.
* - Translation? (don't know how locale information is propagated to plugins in notepad++ yet)
Any feedback would be appreciated!
Tao
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The latest version (linked above for manual download) includes formatting option settings, and should be available through the plugin manager shortly - any feedback appreciated!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just completed a "first functional version" of my new T-SQL formatting plugin. It uses "my" Poor Man's T-SQL Formatter C# library (to quickly test, go to http://poorsql.com).
The plugin can temporarily be downoaded from github (I'll add it to the main project page when I'm happy with it):
https://github.com/downloads/TaoK/PoorMansTSqlFormatter/PoorMansTSqlFormatterNppPlugin.zip
Release Notes / Status:
Any feedback would be appreciated!
Tao
(sorry about the URL mangling, looks like I can't go back and edit…)
One more note on this: The source for the plugin is in the main Poor Man's T-SQL Formatter project repository, on github:
https://github.com/TaoK/PoorMansTSqlFormatter
Latest version is now available from the project page:
http://www.architectshack.com/GetFile.aspx?File=SqlFormatterNppPlugin1.2.1.zip&Page=PoorMansTSqlFormatter
(I'll remove the temporary/beta version from github to avoid confusion)
The latest version (linked above for manual download) includes formatting option settings, and should be available through the plugin manager shortly - any feedback appreciated!