Sublime uroboroSQL Formatter

To Nha Notes | Dec. 27, 2021, 2:39 p.m.

Installation

• Install sublimetext version 3 https://www.sublimetext.com/3
• Install plugin uroboroSQL Formatter for sublimtext 3
• Select Package Control > Install Package > search  uroboroSQL Formatter > install
• Clone https://github.com/bitst0rm-pub/Formatter.git >  C:\Users\tonha\AppData\Roaming\Sublime Text 3\Packages\Formatter

Configure

Open settings via Preferences > Package Settings > uroboro SQL Formatter > Settings - User

Add below config specific for SQL formatter

{
    "uf_tab_size": 4,
    "uf_translate_tabs_to_spaces": true,
    "uf_case": "upper", // "upper" or "lower" or "capitalize" or "nochange"
    "uf_reserved_case": "upper", // "upper" or "lower" or "capitalize" or "nochange"
    "uf_reserved_words":"SELECT, FROM, WHERE, CREATE", // Put commas to separate reserved words
    "uf_comment_syntax": "uroboroSQL", // "uroboroSQL" or "doma2"
    "uf_escapesequence_u005c": false,
    "uf_save_on_format": true,
    "uf_save_on_format_extensions": [".sql"]
}

How to use it

• Right click -> SQL Format
• Tools -> Command Palette -> uroboroSQL Formatter -> Format SQL

References

• https://future-architect.github.io/articles/20170228/
• https://github.com/future-architect/Sublime-uroboroSQL-formatter
• https://github.com/future-architect/uroboroSQL-formatter
• https://github.com/bitst0rm-pub/Formatter