problems with habtm

rubyonrails-talk
1

hi, i'm having some problems with habtm association, when i try to list Empresas form a Category, i get the association ID instead of the Empresa ID, i'm using sqlite3

paulo-geyers-macbook:100empresas paulo$ ./script/console

Loading development environment (Rails 2.3.4)

Category.find(:first).empresas.each {|e| puts e.id}

608 609 => [#<Empresa id: 608, name: "Fast Shop", description: nil, created_at: "2009-09-09 17:55:49", updated_at: "2009-09-09 17:55:49">, #<Empresa id: 609, name: "Livraria Cultura", description: nil, created_at: "2009-09-09 17:55:49", updated_at: "2009-09-09 17:55:49">]

Empresa.find(:all).each {|e| puts e.id}

54276017 1387109338 => [#<Empresa id: 54276017, name: "Livraria Cultura", description: nil, created_at: "2009-09-09 17:55:49", updated_at: "2009-09-09 17:55:49">, #<Empresa id: 1387109338, name: "Fast Shop", description: nil, created_at: "2009-09-09 17:55:49", updated_at: "2009-09-09 17:55:49">]

here follows the model codes empresa.rb class Empresa < ActiveRecord::Base   has_and_belongs_to_many :categories, :foreign_key => 'empresa_id', :association_foreign_key => 'category_id'   validates_presence_of :name   acts_as_voteable end

category.rb class Category < ActiveRecord::Base   has_and_belongs_to_many :empresas, :foreign_key => 'category_id', :association_foreign_key => 'empresa_id'   validates_presence_of :name end

i've tried to set the keys manually, but didn't work too

thanks, Paulo

2

it looks all wrong to me, and overconfigured too. check some tutorials.

Category habtm :empresas Empresa habtm :categories

CategoryEmpresa   belongs_to :category   belongs_to :empresa

http://api.rubyonrails.org/classes/ActiveRecord/Associations/ClassMethods.html#M001836

3

i didn't create the model CategoriesEmpresas, and the table had the "id" field, that was the problem just another case of someone trying to use the framework without reading carefully the documentation

thanks Eric!