Sequel Pro Format Sql Bundle

bundle editor.sh

ruby formatsql.rb "$(cat)"

formatsql.rb

# put this in ~/Library/Application Support/Sequel Pro/Bundles/Format SQL.spBundle
require 'net/http'
require 'json'

uri = URI('http://www.gudusoft.com/format.php')

opts = {"capitalization"=>{"keywords"=>{"fmt100_case_keyword"=>"lower"}, "tableName"=>{"fmt105_case_table_name"=>"lower"}}}

# API details: https://github.com/sqlparser/sql-pretty-printer/wiki/SQL-FaaS-API-manual
res = Net::HTTP.post_form(uri, 'rqst_input_sql' => ARGV[0], 'rspn_db_vendor' => 'mysql', 'rqst_formatOptions' => opts.to_json)
puts JSON.parse(res.body)['rspn_formatted_sql']

The 'bundle editor.sh' file is the contents to put into the Command text box of the Bundle Editor. It removes the code that warns this data is being sent in the clear over the internets, so if you still care about that you'll have to dig that out of the original shell Command. here

The gudusoft.com is the current endpoint for the prior dpriver.com functionality.

and where does the formatsql.rb file live?

Ah, I put that in the original location of the bundle files, which is ... ~/Library/Application Support/Sequel Pro/Bundles/Format SQL.spBundle

In the Bundles folder, right? That .spBundle file is a file.

On my box it's a dir