John Wulff

class Person < ActiveRecord::Base
  has_one :latest_article,
          :class_name => 'Article',
          :order => 'articles.published_at DESC'
end

has_many :articles,
         :order => 'articles.published_at DESC'

person.articles.first

class Person < ActiveRecord::Base
  def latest_article
    articles.find :first,
                  :conditions => 'articles.published_at DESC'
  end
end

That’d be a lot better than grabbing all the Articles but it still wouldn’t be great. Multiple calls to person.latest_article would execute multiple calls to the database. Slow.

Using associations is sexier than a simple finder method because you get caching for free. After the first person.latest_article call subsequent calls hit the cache. Very nice.

Now, for the impetus of this post. I was implementing just what I’ve outlined here, only slightly more complex. Instead of Articles simply belonging to People, in my application Articles belong to People through Mentions.

In this scenario, the latest_article association shown above doesn’t work because you cannot (yet) have has_one_through associations. You can do has_many_through to your hearts content, just no has_one_through.

I’m not the first to want this feature.

Much like my ticket regarding the lame behavior of validates_presence_of, it looks like this won’t be resolved soon.

Oh well, I guess I’ll have to write a dreaded finder method.