How does Rails ActiveRecord chain “where” clauses without multiple queries?

by

The where method returns an ActiveRecord::Relation object, and by itself this object does not issue a database query. It’s where you use this object that matters.

In the console, you’re probably doing this:

@person = Person.where(name: "Jason")

And then blammo it issues a database query and returns what appears to be an array of everyone named Jason. Yay, Active Record!

But then you do something like this:

@person = Person.where(name: "Jason").where(age: 26)

And then that issues another query, but this one’s for people who are called Jason who are 26. But it’s only issuing one query, so where’d the other query go?

As others have suggested, this is happening because the where method returns a proxy object. It doesn’t actually perform a query and return a dataset unless it’s asked to do that.

When you run anything in the console, it’s going to output the inspected version of the outcome of whatever it is you ran. If you put 1 in the console and hit enter, you’ll get 1 back because 1.inspect is 1. Magic! Same goes for "1". A variety of other objects don’t have an inspect method defined and so Ruby falls back to the one on Object which returns something ghastly like <Object#23adbf42560>.

Every single ActiveRecord::Relation object has the inspect method defined on it so that it causes a query. When you write the query in your console, IRB will call inspect on the return value from that query and output something almost human readable, like the Array that you’d see.

If you were just issuing this in a standard Ruby script, then no query would be executed until the object was inspected (via inspect) or was iterated through using each, or had the to_a method called on it.

Up until one of those three things happen, you can chain as many where statements on it as you will like and then when you do call inspect, to_a or each on it, then it will finally execute that query.

More Related Contents:

  1. Rails ActiveRecord methods in different places [closed]
  2. How do I replace accented Latin characters in Ruby?
  3. How to chain scope queries with OR instead of AND?
  4. When to use a “has_many :through” relation in Rails?
  5. Rails 5: ActiveRecord OR query
  6. Ruby on Rails. How do I use the Active Record .build method in a :belongs to relationship?
  7. Alias for column names in Rails
  8. What does inverse_of do? What SQL does it generate?
  9. ActiveRecord Find By Year, Day or Month on a Date field
  10. Rails 3 devise, current_user is not accessible in a Model ?
  11. LEFT OUTER joins in Rails 3
  12. Rails: ActiveRecord query based on association value
  13. How to test for (ActiveRecord) object equality
  14. Rails 3, has_one / has_many with lambda condition
  15. Bulk Insert records into Active Record table
  16. How to use ActiveRecord in a ruby script outside Rails?
  17. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  18. Regular expressions with validations in RoR 4
  19. What are the brackets [5.1] after ActiveRecord Migration and how does it work? [duplicate]
  20. Do rails rake tasks provide access to ActiveRecord models?
  21. Rails 3 migrations: Adding reference column?
  22. how to add records to has_many :through association in rails
  23. How to implement bulk insert in Rails 3
  24. Rails 3.1 limit user created objects
  25. How to show SQL queries run in the Rails console?
  26. Non persistent ActiveRecord model attributes
  27. Rails: Overriding ActiveRecord association method
  28. How do I avoid a race condition in my Rails app?
  29. How can I use ActiveRecord on a database that has a column named ‘valid’? (DangerousAttributeError)
  30. Specifying column name in a “references” migration

Leave a Comment