What is the role played by the `type` column in Doctrine class table inheritance?

General Tech Bugs & Fixes 2 years ago

1 1 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 28 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago

 

Using Symfony 4 / Doctrine 2.6. I have two entities Post and Comment. I want both to be taggable. So I create an entity Tag. I use Doctrine's class table inheritance to create the relationship:

/**
 * @ORM\Entity(repositoryClass="App\Repository\TagRepository")
 * @ORM\InheritanceType("JOINED")
 * @ORM\DiscriminatorColumn(name="type", type="string")
 * @ORM\DiscriminatorMap({"post" = "PostTag", "comment" = "CommentTag"})
 */
abstract class Tag
{
    /**
     * @ORM\Id()
     * @ORM\GeneratedValue()
     * @ORM\Column(type="integer")
     */
    private $id;

    /**
     * @ORM\Column(type="string", length=255)
     */
    private $title;

    // Getters and setters...
}

/** @ORM\Entity */
class PostTag extends Tag
{
    /**
     * @ORM\ManyToOne(targetEntity="App\Entity\Post", inversedBy="tags")
     */
    private $post;

    public function getPost(): ?Post
    {
        return $this->post;
    }
}

/** @ORM\Entity */
class CommentTag extends Tag
{
    /**
     * @ORM\ManyToOne(targetEntity="App\Entity\Comment", inversedBy="comments")
     */
    private $comment;

    public function getComment(): ?Comment
    {
        return $this->comment;
    }
}

This creates 3 tables: tagpost_tag, and comment_tag. The post_tag table structure looks like this:

id | post_id

The tag table structure looks like this:

id | title | type

How are e.g. posts and tags associated? If I want to associate post 13 with tag test, would the result be this:

post_tag table:

id | post_id
------------
1  | 13

tag table:

id | title | type
-----------------
1  | test  | post

?

If so, then what if I want to associate the same tag (test) with a comment. Would the tag table then look like this?

id | title | type
--------------------
1  | test  | post
2  | test  | comment

That seems a bit redundant. The same entity (the test tag) is then represented by 2 rows in the tag table. Am I getting this wrong?

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.