Replace standard ActieRecord#to_sql method with anbt-sql-formatter gem for pretty formatted SQL code output in console.
PpSql alternatives and similar gems
Based on the "Formatters" category
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest. Visit our partner's website for more details.
Do you think we are missing an alternative of PpSql or a related project?
ActiveRecord#to_sql method with
gem for pretty SQL code output in console. Rails log will be formatted also.
Or in console
Rails 4.2+ (optional), will be injected automatically
You can use version
~> 0.2 of this gem with Ruby 2.2, 2.3 and/or Rails 4.0, 4.1
for easy and clean usage with custom string you can use build-in refinement:
Or if you need to use it wider
class MyAwesomeDecoratedString < String include PpSql::ToSqlBeautify end
add in Gemfile
gem 'pp_sql', group: :development
And then execute:
With other formatters
If you are
pry user, or use custom output formatter, use
puts for output whitespaces,
puts User.all.to_sql, or use
If you do not want to rewrite default
#to_sql method you may specify
PpSql.rewrite_to_sql_method=false in initializers.
You can also disable log formatting by specifying
### Add to Application record
I found usefull this trick:
class ApplicationRecord < ActiveRecord::Base include PpSql::ToSqlBeautify if defined?(Rails::Console) self.abstract_class = true end
The gem is available as open source under the terms of the MIT License.
*Note that all licence references and agreements mentioned in the PpSql README section above are relevant to that project's source code only.