Doctrine - One-To-Many Relationship

Question

Good afternoon!

I’m in a relationship with Doctrine and I have a question. I have 2 tables in my database, the Log table and the Log details, where 1 log can contain multiple records referenced to it in the Log Details table. I would like to do the One-To-Many relationship between these tables, but I still have a doubt about that.

I understood the issue of Doctrine Annotations, where I will do the mooring between the entities and references between the key fields, but I could not understand how do I store a list of objects of log details inside the log.

I do not know if I could be clear in my explanation.

Answer 1

Suppose you have a table Log and a LogDetalhe. First of all you will create the entities that will be mapped to the corresponding tables:

Table Log:

<?php

namespace AppBundle\Entity;

use Doctrine\Common\Collections\ArrayCollection;
use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class Log
{
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @ORM\OneToMany(targetEntity="LogDetalhe", mappedBy="log")
     */
    protected $logDetalhes;

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

    public function getLogDetalhes()
    {
        return $this->logDetalhes;
    }

    public function addLogDetalhe(LogDetalhe $logDetalhe)
    {
        $this->logDetalhes->add($logDetalhe);

        return $this;
    }

    public function removeLogDetalhe(LogDetalhe $logDetalhe)
    {
        $this->logDetalhes->remove($logDetalhe);

        return $this;
    }
}

Table LogDetalhe:

<?php

namespace AppBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class LogDetalhe
{
    /**
     * @ORM\Id
     * @ORM\Column(type="integer")
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    protected $id;

    /**
     * @ORM\ManyToOne(targetEntity="Log", inversedBy="logDetalhes")
     * @ORM\JoinColumn(nullable=false)
     */
    protected $log;

    public function getLog()
    {
        return $this->log;
    }

    public function setLog(Log $log)
    {
        $this->log = $log;

        return $this;
    }
}

Note that the relationship is bidirectional because not only do I wish to pick up the details from the log, as I wish to pick up the log from a specific detail.

Then, to create a log and its corresponding details, just do as follows:

$log = new Log();
$this->manager->persist($log);

$logDetalhe1 = (new LogDetalhes())->setLog($log);
$this->manager->persist($logDetalhe1);

$logDetalhe2 = (new LogDetalhes())->setLog($log);
$this->manager->persist($logDetalhe2);

$logDetalhe3 = (new LogDetalhes())->setLog($log);
$this->manager->persist($logDetalhe3);

$this->manager->flush();

See that first the Log was created, and then I connected several entities of the type LogDetalhe to the first. Each of these entities shall be continued by EntityManager of Doctrine, to be saved in the bank by the method flush().