Easy way to suppress SQL output in Rails console?

Question

I frequently need to go on the Rails console with rails c. Then I run some statement which loops through records of a model. I need to output information, but all the SQL code gets littered throughout as well. Like:

Students.all.each {|s| puts s.inspect unless s.attendance};nil

I put that nil at the end so I don't get an ugly dump of all students. This is the output:

  Student Load (4.3ms)  SELECT "students".* FROM "students"
  Attendance Load (3.6ms)  SELECT "attendances".* FROM "attendances" WHERE "attendances"."id" = 2694 LIMIT 1
  Attendance Load (2.7ms)  SELECT "attendances".* FROM "attendances" WHERE "attendances"."id" = 2695 LIMIT 1
  Attendance Load (4.9ms)  SELECT "attendances".* FROM "attendances" WHERE "attendances"."id" = 2689 LIMIT 1
#<Student id: 3, attendance_id: 2689, teacher_id: 6, began_at: "2013-05-21 19:16:37", finished_at: "2013-05-21 20:34:33", created_at: "2013-05-21 19:16:37", updated_at: "2013-05-21 20:34:33">
  Attendance Load (2.0ms)  SELECT "attendances".* FROM "attendances" WHERE "attendances"."id" = 2692 LIMIT 1
#<Student id: 26, attendance_id: 2713, teacher_id: 6, began_at: "2013-05-21 22:44:25", finished_at: "2013-05-21 22:44:42", created_at: "2013-05-21 22:44:25", updated_at: "2013-05-21 22:44:42">
  Attendance Load (1.6ms)  SELECT "attendances".* FROM "attendances" WHERE "attendances"."id" = 2714 LIMIT 1
#<Student id: 27, attendance_id: 2714, teacher_id: 3, began_at: "2013-05-21 22:45:06", finished_at: "2013-05-21 22:45:27", created_at: "2013-05-21 22:45:06", updated_at: "2013-05-21 22:45:27">
  Attendance Load (4.0ms)  SELECT "attendances".* FROM "attendances" WHERE "attendances"."id" = 2712 LIMIT 1

Here it actually is not so bad, but it's still sometimes difficult to see what I want. Easy way to suppress the SQL output?

See stackoverflow.com/questions/7759321/…

eugen
– eugen

2013-05-29 21:33:30 +00:00
Commented May 29, 2013 at 21:33 — eugen
– eugen, Commented May 29, 2013 at 21:33

Mori · Accepted Answer · 2013-05-29 21:36:35Z

20

Enter this in the console, or put it in the console's config file:

ActiveRecord::Base.logger = nil

answered May 29, 2013 at 21:36

Mori

27.8k10 gold badges71 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

MrYoshiji Over a year ago

"console's config file": Can you tell me where is this file? I'd like to customize my console a little bit

Mori Over a year ago

@MrYoshiji, for pry it's ~/.pryrc. Not sure for irb.

smtlaissezfaire Over a year ago

You can also use ~/.irbrc:

smtlaissezfaire Over a year ago

But this isn't a good solution - it omits all output, not just SQL output

Mori Over a year ago

@JeffZivkovic This only persists until the console exits.

|

Collectives™ on Stack Overflow

Easy way to suppress SQL output in Rails console?

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related