Access to Doctrine in Entity

Question

I have two Entity class: House and Car.

in Entity House class i have method:

<?php

namespace Acme\HouseBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * House
 */
class House {
//...
  public function getRandomCar()
  {
      $em = $this->getDoctrine()->getManager();
      $car = $em->getRepository('AcmeCarBundle:Car')->find(rand(0,100));

      return $car->getName();
  }
}

but i dont have access to Doctrine in my Entity House class. How can i make it?

I know, but how can i use Doctrine in Entity and others class? — Michael Roostig, Sep 18 '13 at 08:34

sf_tristanb · Accepted Answer · 2013-09-18T08:42:36.603

0

You need to write the function getRandomCar in your CarRepository (you'll have to create it)

A simple rule is to never, ever write queries inside an entity (car, house....)

Read more about Repositories

Car.php

/**
 * @ORM\Table(name="car")
 * @ORM\Entity(repositoryClass="Acme\CarBundle\Entity\CarRepository")
 */
class Car 
{
}

CarRepository.php

class CarRepository extends EntityRepository  
{
    public function getRandomCar() 
    {
        $qb = $this->createQuery('c');
        $qb->where('c.id = :id')
            ->setParameters(array('id' => rand(0,100)))
            ->getQuery();

        return $qb->execute();
    }
}

Then in your Controller,

$em = $this->getDoctrine()->getManager();
$car = $em->$em->getRepository('AcmeCarBundle:Car')->getRandomCar();
$car->getName();

edited Sep 18 '13 at 08:42

answered Sep 18 '13 at 08:34

sf_tristanb

8,725
17
74
118

ok, thanks but how can i use Doctrine in Entity and others class? this is not possible? – Michael Roostig Sep 18 '13 at 08:37
Read my response, you can't and should not use doctrine entity manager in your Entities. Therefore, you can use it in your Controllers, and all other classes (services...) but not in your Entity class – sf_tristanb Sep 18 '13 at 08:45
But i dont use Controller. I would like use this method in Sonata Admin – Michael Roostig Sep 18 '13 at 08:48

Access to Doctrine in Entity

1 Answers1