Replace stanpard ActieRecord#to_sql
method with anbt-sql-formatter
gem for pretty SQL code output in console. For example:
# was
User.all # =>
"SELECT `users`. * FROM `users`"
# thus
# =>
SELECT
`users`. *
FROM
`users`
Post.first.to_sql
If you need yo use it in some custome strings, you may include this funcional with
String.send :include, PpSql::ToSqlBeautify
and use formatter with any String.
add in Gemfile
gem 'pp_sql', group :development
And then execute:
$ bundle
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
The gem is available as open source under the terms of the MIT License.