Considering the following Symfony entities:
class Continent
{
/**
* @ORM\Id
* @ORM\Column(type="integer", name="id")
* @ORM\GeneratedValue(strategy="IDENTITY")
*/
private $id;
/**
* @ORM\Column(type="string", length=20, nullable=true, name="text")
*/
private $text;
/**
* @ORM\OneToMany(targetEntity="AppBundle\Entity\Country", mappedBy="continent")
*/
private $countries;
/**
* Constructor
*/
public function __construct()
{
$this->countries= new \Doctrine\Common\Collections\ArrayCollection();
}
class Country
{
/**
* @ORM\Id
* @ORM\Column(type="integer", name="id")
* @ORM\GeneratedValue(strategy="IDENTITY")
*/
private $id;
/**
* @ORM\Column(type="string", length=20, nullable=true, name="text")
*/
private $text;
/**
* @ORM\OneToMany(targetEntity="AppBundle\Entity\City", mappedBy="country")
*/
private $cities;
/**
* @ORM\ManyToOne(targetEntity="AppBundle\Entity\Continent", inversedBy="country")
* @ORM\JoinColumn(name="continentt_id", referencedColumnName="id")
*/
private $continent;
/**
* Constructor
*/
public function __construct()
{
$this->cities= new \Doctrine\Common\Collections\ArrayCollection();
}
class City
{
/**
* @ORM\Id
* @ORM\Column(type="integer", name="id")
* @ORM\GeneratedValue(strategy="IDENTITY")
*/
private $id;
/**
* @ORM\Column(type="string", length=30, nullable=true, name="text")
*/
private $text;
/**
* @ORM\ManyToOne(targetEntity="AppBundle\Entity\Country", inversedBy="city")
* @ORM\JoinColumn(name="country_id", referencedColumnName="id")
*/
private $country;
/**
* Constructor
*/
public function __construct()
{
}
My question is:
Is there a way, using annotation, to add a $continent member to the City Entity class that represents a step-behind/indirect relationship (i.e the continent of the country of the city)
If it is not possible using annotations, what would be a good practice to solve this (custom repository for example?)