Creating rails database model

Question

If I have table A with some fields i.e :

id
name
release_date

And I have table B which contains two table A entities i.e

id
from
to

(from and to are ids from table A)

How do I connect these two entities in model so I can use dot operator to access Bs from A?

About Design

From table A record another record A is created so I want to keep track of which was created from which record.

So this is why table B exists, so I know from which A was made from which A

Can you elaborate some more on this design? That's the relationship between A and B? — Mike Szyndel
– Mike Szyndel, Commented Jul 16, 2013 at 9:10
So you basically have a tree of records? Why not have an additional column in A like parent_id? — Mike Szyndel
– Mike Szyndel, Commented Jul 16, 2013 at 9:29
And for managing tree structure I tink most popular solution is Ancestry gem github.com/stefankroes/ancestry — Mike Szyndel
– Mike Szyndel, Commented Jul 16, 2013 at 9:31

Paulo Fidalgo · Accepted Answer · 2013-07-16 08:47:07Z

2

You can use a has_and_belongs_to_many relationship. There's more information about it in rails guide where you can check the migrations needed too.

answered Jul 16, 2013 at 8:47

Paulo Fidalgo

22.4k7 gold badges105 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mike Szyndel Over a year ago

HABTM is generally discouraged in favour of has_many :through and it is even more discouraged to give that answer to such a broad question.

Krishna Rani Sahoo · Accepted Answer · 2013-07-16 08:45:58Z

1

Try

in class B

has_many :froms, :foreign_key => "from" , :class_name=>"A"
has_many :tos, :foreign_key => "to" , :class_name=>"A"

answered Jul 16, 2013 at 8:45

Krishna Rani Sahoo

1,5391 gold badge15 silver badges26 bronze badges

4 Comments

Yevgeniy Anfilofyev Over a year ago

It could be has_one as well :)

Slicedpan Over a year ago

This doesn't allow you to access Bs from A, you need a belongs_to in class A, but you would need a separate field based on whether it was a 'from' A or a 'to' A

Gandalf StormCrow Over a year ago

When I try to access A.froms I get #<ActiveRecord::Associations::CollectionProxy:0x582f406>

Slicedpan Over a year ago

A collection proxy is just a fancy array that contains instances of ActiveRecord models. try Yevgeniy's suggestion, change the has_many to has_one (maybe change to 'from' and 'to' instead of the plural to keep things sane)

shrikant1712 · Accepted Answer · 2013-07-16 08:56:24Z

0

Try to use many to many relationship using through follow this link it will clear your all doubts regarding relationships

http://guides.rubyonrails.org/association_basics.html#the-has-many-through-association

answered Jul 16, 2013 at 8:56

shrikant1712

4,4341 gold badge26 silver badges43 bronze badges

Collectives™ on Stack Overflow

Creating rails database model

3 Answers 3

1 Comment

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Related