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']

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