PpSql

Replace standard ActiveRecord#to_sql method with anbt-sql-formatter gem for pretty SQL code output in console. Rails log will be formatted also. Example output:

log

Or in console

console

Require

Ruby 2.2+

Rails

Rails 4.0+ (optional), will be injected automatically

Usage

Post.first.to_sql

for easy and clean usage with custom string you can use build-in refinement:

  using PpSql::ToSqlBeautifyRefinement

Or if you need to use it wider

class MyAwesomeDecoratedString < String
  include PpSql::ToSqlBeautify
end

Installation

add in Gemfile

gem 'pp_sql', group: :development

And then execute:

$ bundle

With other formatters

If you are pry user, or use custom output formatter, use puts for output whitespaces, like puts User.all.to_sql, or use User.all.pp_sql.

With Rails

If you do not want to rewrite default #to_sql method you may specify PpSql.rewrite_to_sql_method=false in initializers.

License

The gem is available as open source under the terms of the MIT License.