habtm

Rails Habtm with a field

Hello, Is that possible to have a field in a has and belongs to many table? Just like favorite: create_table :messages_users, :id => false, :force => true do |t| t.integer :message_id, :null => false t.integer :user_id, :null => false t.boolean :favorite, :null => false t.timestamps end I saw timestamps works well, thanks ...

join same rails models twice, eg people has_many clubs through membership AND people has_many clubs through committee

Models: * Person * Club Relationships * Membership * Committee People should be able to join a club (Membership) People should be able to be on the board of a club (Committee) For my application these involve vastly different features, so I would prefer not to use a flag to set (is_board_member) or similar. I find myself wanting ...

Does CakePHP treat all INT fields as ID's for join tables?

I am trying to save a User, their Profile, and some tags and my join table that links the profile and the tags keeps getting messed up. The profile model is called Instructor, the tag model is called Subject. The Instructor has a phone number and a zip code and for some reason CakePHP thinks these are the fields it should use when creat...

nested form & habtm

so i am trying to save to a join table in a habtm relationship, but i am having problems. from my view, i pass in a group id with: = link_to "Create New User", new_user_url(:group => 1) User model (user.rb) class User < ActiveRecord::Base has_and_belongs_to_many :user_groups accepts_nested_attributes_for :user_groups end ...

Accessing individual HABTM records in a form

I'm building a form in my CakePHP project that lets you edit a company's information. Among all other things, every company has at least one geographical area in which the company operates, but it may have more. The areas are selected individually using select dropdowns. The relationship between companies and areas is HABTM, because I n...

CakePHP and David Persson Media Plugin with HABTM

Hi everyone! I wonder if it's possible to use David Persson's media plugin with a many to many (HABTM) relationship. With the hasMany relationship i made it work thanks to this tutorial (see the "advanced" section): http://www.slideshare.net/real34/the-cakephp-media-plugin ...

using searchlogic with habtm associations

Hi guys, I have the following issue: I have two classes in my rails app, joined by a HABTM association, like so: #ad.rb has_and_belongs_to_many :specs #spec.rb has_and_belongs_to_many :ads joined by an ads_specs table. I'm trying to perform a search on the Ad class using the excellent searchlogic gem. Everything went fine until I wan...

find() on has_and_belongs_to_many not returning associations

I have a has_and_belongs_to_many relationship: class Staff < ActiveRecord::Base has_and_belongs_to_many :services class Service < ActiveRecord::Base has_and_belongs_to_many :staffs and I have a table called 'services_staffs' with columns service_id and staff_id But when I do Services.find(:all) it's not returning the staffs (I ca...

has_and_belongs_to_many query works in one direction, fails in the other

I have: class Service < ActiveRecord::Base has_and_belongs_to_many :staffs and class Staff < ActiveRecord::Base has_and_belongs_to_many :services With the intermediate table services_staffs with columns services_id and staffs_id The following query succeeds: Staff.find( :all, :conditions => "service_id = #{service_id}" ) B...

Rails: UI to add children from large record set to parent model in HABTM relationship

Given the parent / child HABTM relationship: class List < ActiveRecord::Base has_and_belongs_to_many :items end class Item < ActiveRecord::Base has_and_belongs_to_many :lists end I need to set up a UI to add Items (children) to a List (parent) from the List create / edit form. The wrinkle is that there are far too many Items reco...

Use button_to to create habtm join?

G'day all. In a Rails app I have 2 models: users and spots, with a habtm relationship and join table. In the spot/show action I can create a form to ask the current user if they have visited this current spot (checkbox) and click save to create a record in the join table. This works well (so I know my models and relationships are all g...

In Rails how does one find disassociated records in a HABTM relationship?

I have a HABTM relationship between Videos and Campaigns in Rails which means the association is stored in a join table. I want to find all the Videos that do NOT have an associated campaign. What would be the most efficient way of doing this? Thank you for looking =) ...

Newbie Rails HABTM association not working

I'm new to Rails and trying to create a has_and_belongs_to_many relationship between orders and items. class Order < ActiveRecord::Base has_and_belongs_to_many :items end class Item < ActiveRecord::Base has_and_belongs_to_many :orders end Migration for Orders (not shown. very basic) Migration for OrderItems: class CreateItems ...

Has_and_belongs_to_many accepts_nested_attributes_for problem

I am working on some code today but for some reason I can't seem to get it to work. Some explanation: I have a system that contains feeds, that consist of feed_entries. There are also some categories with sub_categories. Between the sub_categories and feed_entries there is a has_and_belongs_to_many relationship, which I can not seem to ...

Problem with HABTM and join table in Rails

I have a simple model: class User < ActiveRecord::Base has_and_belongs_to_many :roles end class Role < ActiveRecord::Base has_and_belongs_to_many :users end I have created a simple join table: class CreateUsersRoles < ActiveRecord::Migration def self.up create_table :users_roles, :id => false do |t| t.integer :user...

CakePHP - Caching HABTM while (un)publishing children

Hi, I'm caching an HABTM relation in CakePHP. Some children (Showcases) of the root model (Client) get updated once in a while because they get published or unpublished. That means that the Cached query should expire. But... it doesn't. It only expires when one of the children is added or removed. How do I properly make the update actio...

Associating users and articles

So I just started with Rails and right now looking over HABTM. I am reading the DHH book and I see that he has two models namely article and user. They have HABTM relationships. I am wondering however whether I need to create a separate migration for the articles_users model by myself or will Rails do it for me? If so, what happen if I ...

Why doesn't include? respect eager loading for habtm associations?

I have two models, with a habtm relationship. When I create new instance and call include? on the association, rails hits the database each time. That doesn't seem very good for performance. Eg.: class Foo < ActiveRecord::Base has_and_belongs_to_many :bars default_scope :include => [:bars] end class Bar < ActiveRecord::Base has_...

Rails - deleting a single record in a intersection table habtm

hey, I have a habtm relationship (assignments < assignments_candidates > candidates) I want to be able to delete one candidate off an assignment. here is my code so far @assignment = Assignment.find(:first, :joins => :candidates, :select => "assignments_candidates.*", :conditions => ["assignments_candidates.candidate_id = ? AN...

Simulating has_and_belongs_to_many nested through behavior in Rails 3

So Rails doesn't have support for :through associations through a habtm relationship. There are plugins out there that will add this in for Rails 2.x, but I'm using Rails 3 / Edge, and only need the association for one particular model. So I thought I'd stump it out myself with the beauty that is Arel. First, the models: class CardSet ...