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:

Or in console

Require

Ruby 2.2+

Usage

Post.first.to_sql

If you need to use it in some custom strings, you may include this functionality with

String.send :include, PpSql::ToSqlBeautify

and use formatter with any String.

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.