[Rails] Self Reference, Almost There (I Hope!)

[Michael Satterwhite]

I'm still struggling with the self reference. I *THINK* I'm getting
close. I have the following tables:

class CreateCategories < ActiveRecord::Migration
  def self.up
    create_table :categories do |t|
    t.string :name, :limit => 40
      t.timestamps
    end
  end
end

class CreateRelationships < ActiveRecord::Migration
  def self.up
    create_table :relationships, :id => false do |t|
    t.integer :category_id
    t.integer :parent_id
    t.integer :sort_order
      t.timestamps
    end
  end
end

My models look like this:

class Relationship < ActiveRecord::Base
  belongs_to :category,  :class_name => 'Category',
       :foreign_key => 'category_id'
  belongs_to :parent,   :class_name => 'Category',
             :foreign_key => 'parent_id
end

class Category < ActiveRecord::Base
  has_many :relationships, :foreign_key => 'category_id'

  has_many :parents, :class_name => 'Category',
                     :through => 'relationships',
                     :source => :parent

  has_many :children, :class_name => 'Category',
                      :through => 'relationships',
                      :source => :category
end

I can create a category. When I try to add a parent to it (e.g.
c.parents << p) I get the error

ActiveRecord::HasManyThroughAssociationNotFoundError: Could not find the
association "relationships" in model Category

I'm sure that I'm missing something simple, but I don't see it. Can
anyone let me know what I'm missing?

Thanks much
---Michael
-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to rubyonrails-t...@googlegroups.com.
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.