Best way to find a single record using ActiveRecord 3 / Arel?

ruby-on-rails ruby activerecord arel
John Bachir picture John Bachir · Jun 13, 2011 · Viewed 31.1k times · Source

Where I used to do this:

Foo.find_by_bar('a-value')

I can now do this:

Foo.where(:bar => 'a-value').limit(1).first

Is this recommended? Is this the best way? Should I continue to use the "old" way because it continues to be useful syntactic sugar, or is there an Even Better way I can do that now, which will support chaining and all the other good stuff?

Answer

SureshCS picture SureshCS · Feb 10, 2014

Rails 4 :

Foo.find_by bar: 'a_value' , wibble: 'a wibble value'

Related questions

ActiveRecord Arel OR condition

How can you combine 2 different conditions using logical OR instead of AND? NOTE: 2 conditions are generated as rails scopes and can't be easily changed into something like where("x or y") directly. Simple example: admins = User.where(:kind => :admin) …

Read More
How to order included elements in Rails 3

I have a model relationship where today has many tasks I'm trying to retrieve a user's today object, include the tasks and render them all to Json. All of this was going great until I decided I wanted to order …

Read More
What exactly is Arel in Rails 3.0?

I understand that it is a replacement for ActiveRecord and that it uses objects instead of queries. But... why is this better? will objects/queries be "easier" to create? will it lead to more efficient SQL queries? will it be …

Read More