Doctrine complex entities

Question

Let's say i have two Doctrine entities:

Users and Messages

Every user can have 'n' messages.

Now I want to display the mailbox for a user so I fetch the user entity from the ORM and from this entity I get all messages. No problem so far.

But now i want to have some more complexe filtering of the messages. For example: Max age, Max count, blacklisting some words etc. So the default getter method of the entity for getting the messages isn't enough.

How can i solve this?

A entity repository is the first thing i found but then i have to ask this repoitory from outside of the user object which breaks the relationship of user and message (repository->getMessagesForUser(userId,...) instead of user->getMessages(...)) which doesn't look like a 'clean' OOP solution for me.

Another way i could think of is to ignore all this fancy ORM stuff and write my own models and getting the informations from the database on the lowest ORM or even DBAL layer. And ether wrap the entity or fill the fields of my own models manually. But then i ask myself: "Why did i use Doctrine?".

So what's the best practice for this case. By the way i use Symfony 2.

Christoph · Accepted Answer · 2012-07-12 07:43:30Z

2

In this specific case, I would definitely make the Message its own aggregate, and therefore would create a Repository for it, and remove the relationship from User to Message. The User can have many Messages anyway, so it would be very inefficient to use the other approach.

I would then create specific methods in the MessageRepository:

class MessageRepository { public function findByUser(User $user) { // ... } public function findReadMessagesByUser(User $user) { // ... } }

edited Jul 12, 2012 at 7:43

Christoph

51.4k22 gold badges103 silver badges129 bronze badges

answered Jul 10, 2012 at 21:38

BenMorel

37k52 gold badges208 silver badges339 bronze badges

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

4 Comments

Johni Over a year ago

Mhh yes it seems it's the only solution. But i think i have to write my own models since i need some more dependencies which i can't inject into a repository (if i understand them right).

timdev Over a year ago

Note that it appears the D2 developers are planning to provide a solution to this in 2.3, which is due to drop later this month: doctrine-project.org/jira/browse/DDC-1637

contrebis Over a year ago

Ha, I was thinking while reading this answer we need something like Linq to enable this.

Johni Over a year ago

Yes, this would be part of a solution.

Collectives™ on Stack Overflow

Doctrine complex entities

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related