ActiveRecord finder: Now we can use hash as conditions


Earlier conditions can either be specified as a string or array now in edge rails we can specify hash also. So if we specify conditions as hash then it will generate conditions based on equality with SQL AND.

Example:

will generate SQL as “where `first_name` = ‘akhil’ and `role` = ‘admin’”

Also we can have range as condition

Example:

will generate SQL as “where `access_level` BETWEEN 3 AND 5″

This is really helpful modification in ActiveRecord :-)

Information and Links

Join the fray by commenting, tracking what others have to say, or linking to it from your blog.

Information
February 22nd, 2007
6 Responses
Feeds and Links
Comment Feed
From This Author
Del.icio.us
Digg
Technorati
Categories
Uncategorized

Other Posts
Engine Yard: Best Hosting for rails applications
Delegation in rails

Reader Comments

Comment Number:
1
Written by:
Paul Davis
Posted on:
February 22, 2007 at 3:25 am

In what version of AR does this functionality appear?

Comment Number:
2
Written by:
zerohalo
Posted on:
February 24, 2007 at 12:47 am

Nice. How do you specify the OR condition?

Comment Number:
3
Written by:
Akhil Bansal
Posted on:
February 24, 2007 at 11:52 am

Zerohalo,
Currently we have no way to specify ‘OR’

Comment Number:
4
Written by:
Akhil Bansal
Posted on:
February 28, 2007 at 10:19 am

Hi zerohalo,
Try this for OR condition as:

:conditions=>[”firstname =>:fname OR lastname => :lname”, {:fname=> @fname, :lname => @lname}]

Comment Number:
5
Written by:
JFSIII
Posted on:
May 3, 2007 at 5:25 pm

This is great. I’ve long thought the current way was cumbersome and not keeping with The Rails Way.

I mean, nearly everything else is Model.method(:param => :value) except find().

When I say not keeping with The Rails Way, I mean that it’s putting the user right into the muck. You don’t write SQL anywhere else in the app (excluding find_by_sql()), so how can we expect a user to know how to properly format a WHERE clause?

Again, great news. In which version of Rails will this appear?

Comment Number:
6
Written by:
Akhil Bansal
Posted on:
May 3, 2007 at 6:32 pm

I don’t have exact idea when it was introduced, but it was near rails 1.2.0

Write a Comment

Take a moment to comment and tell us what you think. Some basic HTML is allowed for formatting.