Menu

PoorMansTSqlFormatterNppPlugin - SQL formatti

Tao Klerks
2011-12-29
2012-11-14
  • Tao Klerks

    Tao Klerks - 2011-12-29

    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:

    * 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

     
  • Tao Klerks

    Tao Klerks - 2011-12-29

    (sorry about the URL mangling, looks like I can't go back and edit…)

     
  • Tao Klerks

    Tao Klerks - 2011-12-29

    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

     
  • Tao Klerks

    Tao Klerks - 2012-01-29

    The latest  version (linked above for manual download) includes formatting option settings, and should be available through the plugin manager shortly - any feedback appreciated!

     
MongoDB Logo MongoDB