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.
Alternatively, view PpSql alternatives based on common mentions on social networks and blogs.
8.9 6.8 L5 PpSql VS shoulda-matchersSimple one-liner tests for common Rails functionality
6.9 0.0 L5 PpSql VS SporkA DRb server for testing frameworks (RSpec / Cucumber currently) that forks before each run to ensure a clean testing state.
6.3 8.4 L5 PpSql VS ArubaTest command-line applications with Cucumber-Ruby, RSpec or Minitest.
3.4 7.5 L4 PpSql VS RRRR is a test double framework that features a rich selection of double techniques and a terse syntax. ⛺
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
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
Running the tests requires sqlite. To run the tests for different combinations of dependency
bundle exec appraisal install followed by
bundle exec appraisal rake.
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.