Create Comment

[ping86]

How I can create a comment?

       $postManager = $this->get('ekino.wordpress.manager.post');
       $userManager = $this->get('ekino.wordpress.manager.user');

       $post = $postManager->find(1);
       $user = $userManager->find(1);


        $commentManager = $this->get('ekino.wordpress.manager.comment');
        $comment = new Comment();
        $comment->setAuthor("username");
        $comment->setContent("My comment");
        $comment->setAuthorEmail("mail@example.com");
        $comment->setApproved("1");
        $comment->setAgent("");
        $comment->setAuthorUrl("");
        $comment->setAuthorIp("");
        $comment->setDate(new \Datetime());
        $comment->setDateGmt(new \Datetime());
        $comment->setKarma(1);
        $comment->setType("1");
        $comment->setUser($user);
        $comment->setPost($post);

If I use this code, doctrine return:

ContextErrorException: Catchable Fatal Error: Object of class Proxies\__CG__\Ekino\WordpressBundle\Entity\User could not be converted to string in /var/www/opos/current/vendor/doctrine/dbal/lib/Doctrine/DBAL/Statement.php line 120

I need create in the user entity (Ekino\WordpressBundle\Entity\User) the next method:

    public function __toString()
    {
        return $this->getUsername();
    }

Then I have this error.

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'comment_parent' cannot be null

In summary, when I want create a comment. Are all fields are required? In wordpress the parent field is not required. This also happens in the fields, agent, authorUrl, user....

[eko]

Hi @ping86,

Thank you for reporting this issue.

I think this is because the user field here should be mapped with a relation to the User entity: https://github.com/ekino/EkinoWordpressBundle/blob/master/Resources/config/doctrine/model/Comment.orm.xml#L51

About mandatory fields, I think all fields are not required indeed but the mapping looks wrong if so.

I will have a look at this as soon as possible.

Feel free to submit a PR if you have some time for fixing it.

[eko]

@ping86 Can we close this issue then? Thank you