How to manage Single Table Inheritance within Doctrine 2?

Question

I have comments and articles, both are votable.

So, basically I've three entities, Article, Comment and Vote.

After some reading on Single Table Inheritance in Doctrine2 reference manual, it seems that it's what I need, because my Vote remains the same over Article or Comment.

Over the ORM view, here is how I see my Vote table:

id | resource_id | resource_type | weight |

I guess the resource_type should be the "discriminator" column, but I don't really understand how to implement this within my entity.

What I'm trying to do is to avoid to have to Vote table for each of my entities since the vote entity remains the same for the both, except the "resource_type", so I'm trying to find a way within Doctrine2 to be able to have only one Vote entity to work with.

I don't fully understand what you are trying to achieve. Can you please explain a little more about how your domain should function, I'm thinking inheritance might not be the go here... — Cobby
– Cobby, Commented Apr 29, 2011 at 1:37
@Cobby, you may be right, I'm wondering if it's the proper way to implement such system.` — JohnT
– JohnT, Commented Apr 29, 2011 at 8:37
I still don't get when your objective is. IMO, I think you should have separate entities and separate tables even though they are the same. Write a MappedSuperclass containing all the logic, then empty Vote entities. Could you please explain your system? — Cobby
– Cobby, Commented Apr 30, 2011 at 21:43

Roy · Accepted Answer · 2022-02-23 14:33:50Z

8

Based on the example from the docs:

/**
 * @Entity
 * @InheritanceType("SINGLE_TABLE")
 * @DiscriminatorColumn(name="resource_type", type="string")
 * @DiscriminatorMap({"article_vote" = "ArticleVote", "comment_vote" = "CommentVote"})
 */
class Vote
{
    private $id;
    private $weight;
}

class ArticleVote extends Vote
{
    /** @ManyToOne(...) */
    private $article;
}

class CommentVote extends Vote
{
    /** @ManyToOne(...) */
    private $comment;
}

edited Feb 23, 2022 at 14:33

Roy

44.3k2 gold badges28 silver badges26 bronze badges

answered Apr 29, 2011 at 3:53

rojoca

11.2k4 gold badges48 silver badges47 bronze badges

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

2 Comments

JohnT Over a year ago

Hi, thank you for your example, I end up to a similar thing, but there is something I don't understand, in CommentVote you added a $vote property, shouldn't it be $comment as in ArticleVote?

hserge Over a year ago

Vote must be an abstract class or part of a discriminator map, to be properly mapped in the inheritance hierarchy.

David Lin · Accepted Answer · 2013-07-03 04:13:21Z

3

Just incase someone else needs it, here is an detailed example in using Table Inheritance with Doctrine. I found it more informative than the Doctrine documentation:

http://blog.liip.ch/archive/2012/03/27/table-inheritance-with-doctrine.html

answered Jul 3, 2013 at 4:13

David Lin

13.4k5 gold badges48 silver badges48 bronze badges

Collectives™ on Stack Overflow

How to manage Single Table Inheritance within Doctrine 2?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related