similar to: Representing relationships between model objects

I''ve got something that I''m not sure is actually doable. I have a very complex model relationship with a lot of parent/child/grandchild/ greatgrandchild etc stuff going on. Is there a way to do a route like this? tld.com/ projects/:project_name/:sequence_acronym/:shot_number/:department/:eleme nt_name/:version/ where: project is the parent of sequence sequence is the

Hi, I''m trying to figure the most efficient way to model the following. I can think of at least two ways to relate the tables but from a client/server perspective! I''m wondering how to best (and elegantly)relate them from an AR perspective. A project has many people, A person can work on many projects at any time, A project has many roles, A role is performed by a person, A

Hi everyone, I''ve tried posting the same question to the list last Friday but somehow did not see it being posted.. I''ve just started with Rails and Ruby. I just started to play one of those RPG and to get my feet wet I''m writing an app to keep track of item fusions. So the scoop is that item can be fused with another items to create a higher level item. The higher

Hello, I have table called ''listings.'' There are a certain combination of properties which make a listing viewable (e.g., it is confirmed, has been authorized, hasn''t expired, etc.). Each listing has one and only one category. I want to be able to do things like Listing.find_viewable(...) and Category.find(...).viewable_listings, but I see no way to do this

OK - I know this has been asked before, but I cannot find it in the archives. Forgive me if I''m creating more noise than I should. I want to know the easiest way to deal with this scenario: I have articles. I have categories for the articles. On the form where you write an article, there needs to be a free-form field to entire the category. The create() method will build the

I''ve just been bodyslammed by a problem with has_and_belongs_to_many - as far as I can tell, if it doesn''t appear at the top of other relationship definitions it doesn''t seem to work right. For example: class Artist < ActiveRecord::Base has_and_belongs_to_many :genres has_many :albums has_many :videos has_many :cds has_many :collections end ..works fine

Is it me or is my model getting the created_at from the wrong model! I have a HABTM relationship between Problems and Tags. In one of my controller I do the following: def view @tag = Tag.find_by_name @params[:id] end In my view I do this: <% @tag.problems.each do |problem| %> ... <%= problem.created_at %> ... <% end %> Now, how come the created_at

I have a HABTM relationship between 2 tables : companies and services. I want to find all the companies who provide a particular service so I''m using @companies = Service.find_by_name(''servicename'').companies. But in the development log, rails appears to be making 2 sql calls - one to find the id of the service and a 2nd to find the companies by that id. How can i

i better explain a little to get started. in my form for creating a Person, there''s a Company field. People belong to companies and companies have many people. in my person form i have: <%= text_field ''person'', ''Company'' %> in my controller i have def create params[''person''][''Company''] =

Hi, I have a many-to-many relationship between dishes and ingredients class Dish < ActiveRecord::Base has_and_belongs_to_many :ingredients end class Ingredient < ActiveRecord::Base has_and_belongs_to_many :dishes end I have a join table dishes_ingredients now when i access my_dish.ingredients, i get a list of what looks like Ingredient objects, but the but they don''t have

I am implementing a messaging system, which requires broadcast to group feature. Instead of a relatively clunky habtm group structure, I am using tags. Form a usability standpoint, it would be helpful to avoid redundant tags. Like, friend vs friends OR client vs. clients. Is it practical to filter tags, before entry, to avoid duplicate tags like plural vs. singular? -- Posted via

I have a model layer containing Movie, Person, Role, and RoleType, making it possible to express facts such as "Clint Easterbunny is director of the movie Gran Milano". The relevant model and associations look like this class Movie < ActiveRecord::Base has_many :roles, :include => :role_type, :dependent => :destroy has_many :participants, :through => :roles, :source

First of all, I love Ruby on Rails. I have an intermediate understanding of PHP, JavaScript, DOM and CSS, and that''s the extent of my programming experience. I''m developing an online game''s web presence with another colleague. We''re the only two technical guys on a team of +10 content developers. So, baring all that in mind, here are my questions with a

Hi, I''m trying to setup an application where users are interconnected. For example, each user will have multiple friends and each user can be friend of multiple people. Now, I just have one User table with fields ( id, name, information ). How do I use ActiveRecord in such a way that I get all friends of a perticular user by giving User.find(1).friends ? Thanks a lot, Pratik --

Hi All, I think Im having a mental block here. For some reason I just cant get my head round relationships. What I have is the following. 4 tables 1) Hosts 2) Software 3) OperatingSystem 4) Company In my terms (which are most likely wrong) a company can have lots of hosts, a host has lots of software, a host has one operating system. So should my models have the following relations in them?

Hi, I''m starting to build a simple (?!) FAQ system, and I''d like some advice on setting up the model relationships. I was going to go with a simple system of a Category table and a FAQ table (holding questions and answers) - where one FAQ belongs to one category. That''s all nice - a simple has_many / belongs_to relationship. Then I decided to add another level - Area.

I''m trying to ensure that I keep the number of queries down a bit. If I have two model (lets call them Foo and Bar). They have a many to many relationship. Now I want to get (and paginate) records from Bar that are related to a certain record in Foo. For example I want all records from Bar whose name starts with ''C'' and are related to record Foo whose name is

I''m attempting to wrestle an old DB into Rails. This relationship is giving me trouble: class Show < AR::Base has_many :segments end class Segment < AR::Base belongs_to :show has_one :media #this has no PK/FK relation end A Segment is "linked" to Media by Media.name, which is the result of concatenating Segment.name and Segment.part. As I said there are is no

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.

I''m a rails newb and have been Googling about this, but I''m still stumped. Not showing everything here, but basically it should be a pretty common setup so I''m sure others know what I''m doing wrong. - A meter can belong to many meter_groups - A meter_group can have many meters. - A user can ''subscribe'' to viewing a meter_group (Subscription)