Testing Rails: How to test Rails ActiveRecord Named Scopes

One of my biggest challenges when approaching new features in Rails is the correct answer to the question "how should I test this?".

Some would probably assert that everything you code can be tested and, even though I perfectly agree with that, I would probably be more interested in how that shiny piece of code can be tested. Rails made the creation of tests a piece of cake, but it's not always so easy.

Have you ever tried to test the correct creation of a cookie in Rails 2.2? Have you ever written a helper test that involves routing rules in Rails 2.0? Have you ever created a test to ensure your caching strategy works as expected?

If you answered yes to at least one of those questions, you probably know what I mean.

The first requirement to write effective tests is to know what you are playing with. You can't really know how to test an ActiveRecord callback unless you know how callbacks work in ActiveRecord and, of course, what your hook is supposed to do.

The second suggestion if you get stuck writing a test is to start reading how that feature or the underlying implementation has been tested in the original framework. So, if you need to write a test for your custom Rails foo_tag helper, you probably want to start reading how the Rails team tested the helpers available with the Rails framework. Believe me, you'll discover tons of new features just reading the tests.

I don't want to go further on how to write effective tests, I'm already writing something special about that topic. This time, let me show you how to test one of the most recent ActiveRecord features: named_scope.

What are named_scope(s)?

Named scopes have been introduced in Rails 2.1. Ok, this is probably not the very latest feature, but one of those I have been testing in the "wrong" way since a few weeks ago.

Named scopes enable you to define custom ActiveRecord filters to narrow down a database query without explicitly passing conditions or query options. You can also chain multiple scopes to get all the records matching the sum of all the conditions merged altogether.

Look at the following example, taken from the great Ryan's What's New in Edge Rails: Has Finder Functionality blog post.

class User < ActiveRecord::Base
  named_scope :active, :conditions => {:active => true}
  named_scope :inactive, :conditions => {:active => false}
  named_scope :recent, lambda { { :conditions => ['created_at > ?', 1.week.ago] } }
end

# Standard usage
User.active    # same as User.find(:all, :conditions => {:active => true})
User.inactive # same as User.find(:all, :conditions => {:active => false})
User.recent   # same as User.find(:all, :conditions => ['created_at > ?', 1.week.ago])

How to test named_scope(s) (the wrong way)

Now that you know what named scopes are and how they work, at least on the surface, you probably want to know how to test them.

When I first started writing named scope tests, the most obvious way seemed to me to use fixtures. Unfortunately, my fixture files started to be cluttered by fake definitions quickly enough. Tons of records were required just to test a single method.

# The following fixtures are used to test the Airport #best named_scope.
# The value for search doesn't match current number of search instances
# but it doesn't really matter in this case.

<% 10.times do |index| %>
initial_airport_code_ROM_<%= index %>:
  search: search_hotels_example
  custom_field: initial_airport_code
  value: ROM
<% end %>

<% 5.times do |index| %>
initial_airport_code_FCO_<%= index %>:
  search: search_hotels_example
  custom_field: initial_airport_code
  value: FCO
<% end %>

<% 5.times do |index| %>
initial_airport_code_RMA_<%= index %>:
  search: search_hotels_example
  custom_field: initial_airport_code
  value: RMA
<% end %>

Even worse, my code started to be overwhelmed by ugly precondition checks in order to ensure my test didn't pass just because of inconsistent fixtures.

def test_recent_should_returns_latest_N_records_ordered_by_created_at
  # precondition: ensure the test doesn't pass
  # just because there are only 3 users.
  assert User.count > 3

  users = User.recent(3).all
  assert_equal(3, users.length)
  assert_equal(User.find(:all, :limit => 3, :order => 'created_at DESC'), users)
end

Needless to say, the work to maintain all the fixtures was driving me crazy. I couldn't believe that was the right way.

Then came Factory, and developers started to say factories are better than fixtures. I agree, at least you don't have to deal with messy fixtures.

At this point I quickly decided to change my tests from the old fixture-school to the fashionable factory-style.

test "named_scope :latest should return all bookmarks ordered by create_at DESC" do
  Bookmark.delete_all
  bookmarks = (0..3).map { |t| Factory(:bookmark, :created_at => t.months.from_now) }
  assert_equal bookmarks.reverse, Bookmark.latest
end

test "named scope :localized" do
  Tutorial.delete_all
  one = Factory(:tutorial, :language => languages(:italian))
  two = Factory(:tutorial, :language => languages(:english))
  thr = Factory(:tutorial, :language => languages(:italian))

  assert_equal([one, thr], Tutorial.localized(languages(:italian)).all)
end

test "named scope :published" do
  Tutorial.delete_all
  one = Factory(:tutorial, :published => true)
  two = Factory(:tutorial, :published => false)
  thr = Factory(:tutorial, :published => true)

  assert_equal([one, thr], Tutorial.published)
end

Yeah, this code started to smell less than the previous one. Do you agree?

But there's still something wrong with those tests. Ok, they work and they are definitely better than the previous ones or than no tests at all. But there's still an unnoticeable smell in the air. No, it's not you, don't worry.

The question is: Do you really need to use real ActiveRecord instances? Do you really need to test against the database? No, you don't and you probably won't.

How to test named_scope(s) (the right way)

There's a better way to test named scopes. You can write your tests to test the conditions generated by the named scope instead of the records returned by the query.

Let's say you need to test the following named scopes.

class Video < ActiveRecord::Base
  named_scope :localized, lambda { |language| { :conditions => { :language_id => language.id }}}
  named_scope :latest, lambda { |*args| { :limit => (args.shift || nil), :order => "#{self.table_name}.created_at DESC" }}
end

You already wrote these tests using the factory-way.

test "named scope :localized" do
  Video.delete_all

  one = Factory(:video, :language => languages(:italian))
  two = Factory(:video, :language => languages(:english))
  thr = Factory(:video, :language => languages(:italian))

  assert_equal([one, thr], Video.localized(languages(:italian)).all)
end

test "named_scope :latest(N) should return latest(N) bookmarks ordered by created_at DESC" do
  Video.delete_all
  videos = (0..3).map { |t| Factory(:video, :created_at => t.months.from_now) }
  assert_equal [videos[3], videos[2]], Video.latest(2)
end

test "named_scope :latest should return all bookmarks ordered by created_at DESC" do
  Video.delete_all
  videos = (0..3).map { |t| Factory(:video, :created_at => t.months.from_now) }
  assert_equal videos.reverse, Video.latest
end

You might be happy to know that there's a really wonderful method, named proxy_options, that returns the options set by a named_scope.

p Video.latest.proxy_options
# {:limit=>2, :order=>"videos.created_at DESC"}

p Video.latest(2).proxy_options
# {:limit=>nil, :order=>"videos.created_at DESC"}

Isn't that cool? Yeah, I know it is!

Now that we know how to get the query filters, we can use them to test our expectations.

test "named scope :localized" do
  expected = { :language_id => languages(:italian).id }
  assert_equal  expected,
                Video.localized(languages(:italian)).proxy_options
end

test "named_scope :latest(N) should return latest(N) bookmarks ordered by created_at DESC" do
  expected = { :limit => 2, :order => "videos.created_at DESC" }
  assert_equal  expected,
                Video.latest(2).proxy_options
end

test "named_scope :latest should return all bookmarks ordered by created_at DESC" do
  expected = { :limit => nil, :order => "videos.created_at DESC" }
  assert_equal  expected,
                Video.latest.proxy_options
end

If you want to make your test even cooler, I've found a nice addition reading the Thoughtbot Pacecar unit tests. You can add an initial respond_to? assertion to make sure you actually defined the named scope before testing it.

test "named scope :localized" do
  assert Video.respond_to?(:localized)
  expected = { :language_id => languages(:italian).id }
  assert_equal  expected,
                Video.localized(languages(:italian)).proxy_options
end

Now that you know how to get access to the named scope options, you should probably avoid wasting resources creating new records and running ActiveRecord queries. Just because you are writing tests it doesn't mean you don't need to care about performance or execution time.

So far, this is the best way I found to test ActiveRecord named scopes. Do you know a better one?