2019/06/11/doctrine-inheritance

[romaricdrigon]

Please comment below! Comments will automatically be published on the blog, too.

[Aerendir]

There is also another useful tool in the Doctrine’s toolbox: embeddables.

They are really really powerful and are a perfect fit for things like pictures or videos like in your example: they are basically value objects and embeddables make use and persistence of value objects really a piece of cake!

[romaricdrigon]

Yes, they are a great and underused Doctrine feature!
Thank you for bringing those up.

Indeed they would make sense for my first example. They would be my first option when you have a value object, and traits being best when you want to add just a few properties without meaning on their own (ie, adding "createdAt" and "updatedAt" fields...).

[Aerendir]

Exactly: this is exactly the way I use both of them! :)
This is really a great article: it clarifies me some things that I knew but never though about much more: thank you!

[romaricdrigon]

Thank you, I appreciate :)
I wanted to start a serie about what I learnt from DDD this week, I will likely write about value objects soon, thank you for making me remember that.

[Aerendir]

Oh, great!

Maybe you will find interesting the post I wrote about value objects: https://io.serendipityhq.com/experience/php-and-doctrine-immutable-objects-value-objects-and-embeddables/

I also wrote a small library around the most common value objects from which you may find inspiration: https://github.com/Aerendir/PHPValueObjects

[marcosdipaolo]

I still don't understand how the database and entities would look like in a polymorphic many to many relationship, say:

class Tag {}
class PostTag extends Tag {}
class VideoTag extends Tag {}
class Post {}
class Video{}

What i would like to have is a many-to-many relationsihp between Post and Tag, and another one between Video and Tag and, if possible, all tags in the tags table with single inheritance.

Laravel's Eloquent works with a pivot with tag_id, taggable_type and taggable_id.
What would be the Doctrine's way?

[Aerendir]

@marcosdipaolo , exactly the same.

You will have a table post_tag, one video_tag (Many-to-Many, Bidirectional).

About single inheritance, are you speaking about a tree of tags?

It is possible through a self referencing relationship:

• One-to-one, self referencing
• One-to-Many, self referencing
• Many-to-Many, self referencing

[marcosdipaolo]

Yes, sorry, i forgot to write the Tag classes, now i've edited it. (no tree)
I'm working with Laravel-Doctrine and Fluent. So my question also goes for the Mapping side.

[romaricdrigon]

@marcosdipaolo I'm not sure to correctly get your scenario.

First of all, are VideoTag and PostTag really different? Ie., do they each have different properties?
If not, what are the benefits of having those in the same tag table?
The main point of my article was to avoid Doctrine inheritance as much as possible, so I would rather not push you to a suboptimal solution.

[cjhaas]

Thanks for that great post. Besides doing a great job explaining the different types (better than Doctrine's documentation, IMHO, too), your final word of maybe just using traits really simplified my project and my thought process!

[marcosdipaolo]

@marcosdipaolo I'm not sure to correctly get your scenario.

First of all, are VideoTag and PostTag really different? Ie., do they each have different properties?
If not, what are the benefits of having those in the same tag table?
The main point of my article was to avoid Doctrine inheritance as much as possible, so I would rather not push you to a suboptimal solution.

@romaricdrigon forget about the example, what i need is a manyToMany polymorphic relationship where an entity can have manyToMany relationships with more than one entity trying to avoid having multiple pivot tables. I just don't understand how you achieve that with doctrine.
The pivot table would be something like this:

tag_id	taggable_id	taggable_type
5	7	App\Video
3	5	App\Post

[parijke]

@marcosdipaolo that is what I am looking for as well....

[romaricdrigon]

@marcosdipaolo you will be hitting one of the limitations of Doctrine inheritance: Doctrine can not handle polymorphic relationships (as far I know. In database). In the database, the taggable_id column has to be a foreign key either of video either of post.

The best solution I can think of would be to have nullable fields, as such:

tag_id	video_id	post_id
5	7	NULL
3	NULL	5

PHP-side, you can have a getTagged getter in Tag class returning either a Video, either a Post, if you really need it. But DQL will be a little bit more verbose, as you have many fields.

[marcosdipaolo]

@marcosdipaolo you will be hitting one of the limitations of Doctrine inheritance: Doctrine can not handle polymorphic relationships (as far I know. In database). In the database, the taggable_id column has to be a foreign key either of video either of post.

The best solution I can think of would be to have nullable fields, as such:

tag_id video_id post_id
5 7 NULL
3 NULL 5
PHP-side, you can have a getTagged getter in Tag class returning either a Video, either a Post, if you really need it. But DQL will be a little bit more verbose, as you have many fields.

thanks for your answer @romaricdrigon
I've done before what you're showing me there. I was simply trying another approach. It turned down that it WORKED
I just created a Taggable entity which represents the relationship. It has

tag_id	taggable_id	taggable_type
5	7	App\Video
3	5	App\Post

I just have to create a 'two columns' index between taggable_id and taggable_type which the db use to search much quickly.
I'll probable will map the entity names to integers to make taggable_type and integer table.

Of course there isn't a queryBuilder method for that, something like this is necesary (I made the type a ValueObject):

public function getByEntityAndType(Taggable $entity, TaggableType $type)
{
        $qb = $this->createQueryBuilder('cc');
        $expr = $qb->expr();
        $qb->where($expr->andX(
            $expr->eq('taggableType.type', ':type'),
            $expr->eq('taggableId', ':id')
        ));
        $qb->setParameter('type', $type->getType());
        $qb->setParameter('id', $entity->getId());
        return $qb->getQuery()->getResult();
}

[parijke]

@marcosdipaolo if I am not misteaken you cannot use those querybuilder calls inside a Entity. So for example how do you handle inside the Video entity a getTags() call to retrieve an ArrayCollection?