ARel table aliases

Pat_Allan · June 17, 2010, 4:22pm

Hi all

I’m battling a little with Rails 3 - trying to get Thinking Sphinx
working with it. What I need is some way to interrogate ARel joins to
find out table aliases, given a certain association hierarchy.

For example - a forum has a creator (User model), and many topics. Each
topic has a creator as well. So, this is a valid query:

Forum.joins(:creator).joins(:topics => :creator)

The resulting SQL has two references to the users table - how can I
interrogate the relation object to find out the users table alias for
the :topics => :creator association path?

A far more detailed analysis of what I want can be found as a gist:

gist.github.com

https://gist.github.com/pat/441625

gistfile1.textile

In Thinking Sphinx, you can define fields and attributes from associations. For example:

<pre><code>class Forum < ActiveRecord::Base
  define_index do
    indexes creator.name, :as => :creator
    indexes topics.name, :as => :topics
    indexes topics.creator.name, :as => :topic_creators
    indexes topics.posts.creator.name, :as => :post_creators
  end
end</code></pre>

This file has been truncated. show original

Any suggestions very much welcome.

Cheers

–
Pat
e: [email protected] || m: +614 1327 3337
w: http://freelancing-gods.com || t: twitter.com/pat
bounce: http://trampolineday.com || skype: patallan