How to store a document inside another document, with Doctrine ODM?

Question

I don't see an Array or Json type in the documentation.

I would like to be able to do something like this:

class Post {

    /**
     * @MongoDB\String
     */
    protected $body;

    /**
     * @MongoDB\Array
     */
    protected $comments = array();

}

I don't want to have a separate collection for comments. I want them saved inside each post.

Elnur Abdurrakhimov · Answer 1 · 2011-11-28T19:21:37.247

2

/**
 * @MongoDB\Document
 */
class Post
{
    /**
     * @MongoDB\Id
     */
    private $id;

    /**
     * @MongoDB\String
     */
    private $body;

    /**
     * @MongoDB\EmbedMany(targetDocument="Comment")
     */
    private $comments;

    public function __construct()
    {
        $this->comments = new ArrayCollection();
    }
}

/**
 * @MongoDB\EmbeddedDocument
 */
class Comment
{
    /**
     * @MongoDB\String
     */
    private $body;
}

But note that comments are not good candidates for embedding — contrary to probably the most popular example of embeds in MongoDB. I started with comments as embeds too, but then run into some problems and decided to store them in a separate collection. I don't remember all the problems, but the main one was the inability to sort comments on the database side. The quick solution was to sort them on the client side, but when it comes to pagination, it just doesn't scale.

edited Nov 28 '11 at 19:21

answered Nov 28 '11 at 19:08

Elnur Abdurrakhimov

44,533
10
148
133

I had tried this before asking, but it said that ArrayCollection() was not valid or something. Lemme check – HappyDeveloper Nov 28 '11 at 20:10
Class Doctrine\Common\Collections\ArrayCollection is not a valid document or mapped super class. – HappyDeveloper Nov 28 '11 at 20:12
Have you tried clearing the cache? There are some cache problems with MongoDBBundle, so sometimes you need to clear it even when in the dev env. – Elnur Abdurrakhimov Nov 28 '11 at 20:39
Btw, I hope the Comment class is fully qualified in this annotiation `@MongoDB\EmbedMany(targetDocument="Comment")` in your code. It should be something like `@MongoDB\EmbedMany(targetDocument="VendorName\BundleName\Document\Comment")`. – Elnur Abdurrakhimov Nov 28 '11 at 20:41
Yes I noted that I had to use fully qualified class names. – HappyDeveloper Nov 28 '11 at 20:44
I'm thinking about moving to propel or mandango. Have you tried them? – HappyDeveloper Nov 28 '11 at 20:44
I haven't heard anything about mandango, but personally I don't like Propel because it's still in the ActiveRecord era. – Elnur Abdurrakhimov Nov 28 '11 at 20:46
Yea, I don't like it either, for the same reason. =( – HappyDeveloper Nov 28 '11 at 22:33

score 0 · Answer 2 · answered Nov 28 '11 at 11:42

0

I think this is what you're looking for: http://www.doctrine-project.org/docs/mongodb_odm/1.0/en/reference/embedded-mapping.html

answered Nov 28 '11 at 11:42

GGGforce

634
1
8
19

score -2 · Answer 3 · answered Feb 06 '12 at 12:35

-2

In my __construct() I need

new \Doctrine\Common\Collections\ArrayCollection();

where you just have

new ArrayCollection();

answered Feb 06 '12 at 12:35

Adam Knowles

492
5
14

How to store a document inside another document, with Doctrine ODM?

3 Answers3