SQL and DAX Formatter in Caret Editor.
This Caret plugin formats SQL and DAX for pretty print
The options for sql-formatter are passed via "options"
Please open tickets on GitHub
https://github.com/DanShrader/Caret-Plugin-Pretty-SQL
Change Log:
Fixed the ' = ' issue
To use with Caret
You'll need to add the following to your api.json file, under settings menu. This plugin can pass the same options that sql-formatter does in the 'options' tag. Note: The id is the id found under extensions. The one in here is for the plugin on the webstore.
api.json
{
"sampleMessage": {
"id": "extension id goes here",
"message": {
"data": "message can be any JSON object passable to chrome.runtime.sendMessageExternal"
}
},
"format-SQL": {
"id": "fnkfgnggimkijjldpalcfjfomhipodib",
"message": {
"command": "sql-format",
"options": {
"indent": "\t"
}
},
"sendEditorContext": true
},
"format-DAX": {
"id": "fnkfgnggimkijjldpalcfjfomhipodib",
"message": {
"command": "dax-format",
"options": {
"indent": "\t"
}
},
"sendEditorContext": true
}
}
menus.json
This is optional, but allows the command to be accessable in menu system.
{
"label": "Format SQL",
"command": "api:execute",
"argument": "format-SQL"
}, {
"label": "Format DAX",
"command": "api:execute",
"argument": "format-DAX"
}
The following have contributed works
Without the following, this plug-in would not exist. Thanks to their works.
Caret
https://github.com/thomaswilburn/Caret
sql-formatter
https://github.com/zeroturnaround/sql-formatter
Microsoft for SSAS and DAX
Statistics
Installs
43
history
Category
Rating
0.0 (0 votes)
Last update / version
2019-03-08 / 1.1.1
Listing languages