Symfony2, Doctrine2, Entity Repository

Question

We have such repository

class CronInfoCharacterInfoRepository extends EntityRepository
{
    /**
     * @param string|integer $characterID
     * @return void
     */
    public function add($characterID)
    {
        if (!$this->find($characterID)) {

            $oEntry = new CronInfoCharacterInfo();
            $oEntry->setCharacterID($characterID);

            $this->getEntityManager()->persist($oEntry);
            $this->getEntityManager()->flush();
        }
    }
}

But I want insert new entry by DQL. How can I do this through $this->createQueryBuilder()... ? And is it normal to use 'entity manager' inside repository?

Sethunath K M · Accepted Answer · 2013-12-27 05:08:30Z

3

You cant insert using DQL the very documentation says about that

INSERT statements are not allowed in DQL, because entities and their relations have to be introduced into the persistence context through EntityManager#persist() to ensure consistency of your object model.

http://docs.doctrine-project.org/en/latest/reference/dql-doctrine-query-language.html

And it is perfectly ok to use enitity manager inside Repo. What you are doing now is correct !

answered Dec 27, 2013 at 5:08

Sethunath K M

4,7694 gold badges31 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Symfony2, Doctrine2, Entity Repository

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related