similar to: making friend request, many to many relationship

Hey everyone, I''m working on allow users to follow other users in my app so they can receive updates to what all their friends are doing (like Facebook/ Twitter). I''m wondering on how the relationship would be for the model. Sounds like a HABTM type of association, but how would I go about doing it for only one model? Thanks, Tony

Trying to model a bunch of users that have friends that are other users. clearly a job for has_and_belongs_to_many, but the trick is, they have ratings for their friends. I have gone through the Rails Recipes book, and it seems like I''m trying to combine the self-referential many-to-many recipe (12) and the many to many relationships where the relationship itself has data recipe (16). So

whats the best way to either add or remove entries for a one-to-many relationship. Should I just put all the entries associated with a record into form fields, and than on submit delete all the entries, and then reenter all of the ones on the current form. This would take into account addition and deletions to the database. whats the best way to do this with many-to-many assuming you want

Hi, I am having issues with a one to many relationship(it never works :-)). Jokes aside, I am getting an error: Mysql::Error: #23000Cannot add or update a child row: a foreign key constraint fails: INSERT INTO adverts (`image_url`, `price`, `title`, `website_url`, `description`, `user_id`) VALUES(''bb'', 22.0, ''aa'',

Hey guys, Maybe someone could point out what wrong here. I''ve simplified the issue to this: Both User.find(6) and Sport.find(1) exist, Im just trying to setup the relationship between them. My controller looks like this def tester @c = User.find(6) @c.sports = Sport.find(1) end And I keep getting this error: undefined method `each'' for #<Sport:0x36a3488

Hello! I have been working on making a self-referential habtm relationship that uses a join model because I want to store info about the relationship. I have been using two sections from Chad Fowler''s "Rails Recipes" as a guide, "Self-referential Many-to-Many Relationships" and "Many to Many Relationships Where the Relationship Itself has Data". So far I

Im trying to establish relationships in a many to many table. When I create a user, I do this to insert the different relationships between the user and sports: c.sports<<Sport.find_all_by_name(params[:sports]) where c is the user. The problem is, when I edit this user, and lets say he adds a sport, I can''t use this because I get an error saying that some records already

Hi, I have a self-referential has_many :through relationship setup to track relationships between users. Basically relationships are modeled as a join table with an extra column ''relation''. create table relationships ( user_id integer unsigned not null, friend_id integer unsigned not null, relation char(1) not null, ) --- relations --- f = friend r = request to

I have the following model structure setup. class User < ActiveRecord::Base end class Parent < User has_many :relationships has_many :children, :class_name => "Student", :through => :relationships, :conditions => "related_as = ''parent''" end class Student < User has_many :relationships

Hi Team! Just having a bit of trouble with the many-to-many relationship of the same type. Im trying to build a buddy list. So I have a users table and want to allow each user to have a buddlist of users. Ive tried having a User model and a Buddy model where the buddy model has 2 fields user_id and a buddy_id but i cant get the buddy.name methods to resolve when getting a list of buddies.

Hi i am getting following error ActiveRecord::StatementInvalid in Blog#index Showing app/views/blog/index.rhtml where line #10 raised: Mysql::Error: #42S22Unknown column ''posts.user_id'' in ''where clause'': SELECT * FROM posts WHERE (posts.user_id = 4) Extracted source (around line #10): 7: <div class="separator">&nbsp;</div> 8:

userstable: |id|name|password| userdetailstable: |id|col1|col2|col3|user_id| this is my code: [code] def create @user = User.new(@params[''user'']) @userdetail = Userdetail.new(@params[''userdetail'']) if @user.save and @userdetail.save flash[:notice] = "Save succeeded..." redirect_to :action => ''list''

All: I have been working on making a self-referential habtm relationship that uses a join model because I want to store info about the relationship. I have been using two sections from Chad Fowler''s "Rails Recipes" as a guide, "Self-referential Many-to-Many Relationships" and "Many to Many Relationships Where the Relationship Itself has Data". So far I have

Hello, I''m not sure if I''m missing something blindingly obvious here. All the relationships that Rails comes with assume 0..n, yes? It''s not a strict 1 to 1 or 1 to n because it''s optional. My question is this - What is the best way to implement a required relationship? For example, if I require that a comment is made by a user (a user has many

Three tables: users: id clients: id admin_contacts: user_id, client_id class Client has_many :admin_contacts has_many :contacts, :through => :admin_contacts, :foreign_key => :user_id, :class_name => ''User'' end I added the :contacts for ease of use of grabbing the user objects associated with the admin_contact. This all works great, I can grab the Users that

Please can someone help with the following problem - I''m using LoginEngine and have a Users table linked many to many to a Plants table. The joining table is plants_users with plant_id and user_id (there are extra fields, so I''m avoiding has_and_belongs_to_many - plus it didn''t work :(). ::user.rb starts:- class User < ActiveRecord::Base has_many :Plants, :through

I''m a little stumped on how to approach the subject of representing relationships between a single model object. Basically, I want a User to be able to mark others as Friends, Contacts, etc. The caveat is that User A can mark User B as a Friend but that doesn''t mean User A is marked as a friend by User B. It can either be a one-way relationship or two-way relationship. Right

Hi folks, I am in the process of converting an existing non-rails application to rails, and am not sure what the best approach would be for specifying the relationship between the two sets of data. I''ll describe the existing table structures first. Table 1: Urls Each url has a unique id and two lists of Phrases, these are currently setup as varchars with "," delimitation -

I have a bit of code in a controller that looks like this: @current_festival.monitor_preferences.each do |pref| if pref.user_id == @me.id pref.preference = params[:monitor_pref] #pref.save end end @current_festival.save_with_validation(false) the Festival class has_many :monitor_preferences the MonitorPreference class belongs_to :festival In the configuration above, the

So I''ve worked through Agile Web Development with Rails and I''m now trying my first little app to get into the swing of things. Its a task tracking app where people can create tasks and assign them to others, and also log time against the tasks. I''m having trouble working out the model relationships. This is what I''ve got so far, but its not right as