Rails - Aug 2009 - Associations Question

I have a three table construct.  A "Users" table.  Users have a
one-to-
one relationship with a "Carts" table for saving the contents of a
shopping cart to the DB.  I have a "Products" table for holding
product information.  The Carts have a many-to-many relationship with
the Products.  (One cart might have more than one product in it, and
one product might be represented in more than one user''s cart.)

What association would be best to describe this relationship?  And
what would the migrations and model statements look like?

Thanks,

Andrew

2009/8/1 Andrew Pace
<andrewppace-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>:
>
> I have a three table construct.  A "Users" table.  Users have a
one-to-
> one relationship with a "Carts" table for saving the contents of
a
> shopping cart to the DB.  I have a "Products" table for holding
> product information.  The Carts have a many-to-many relationship with
> the Products.  (One cart might have more than one product in it, and
> one product might be represented in more than one user''s cart.)
>
> What association would be best to describe this relationship?  And
> what would the migrations and model statements look like?
>
Possibly:
User has_one Cart
Cart belongs_to User, has_and_belongs_to_many Products
Product has_and_belongs_to_many Carts

See the rails guides Getting Started and ActiveRecord Relationships at
http://guides.rubyonrails.org/ for more details.

Colin