Symfony中的多对一关系2

I have a problem related to Doctrine2:

我有一个与Doctrine2相关的问题:

1- I have two tables joining on a many-to-one relation:

1-我有两个表加入多对一关系:

Table 1 - Activity

表1 - 活动

The Schema:

Backend\adminBundle\Entity\Activity:
type: entity
table: activity
indexes:
    result_id:
        columns:
            - result_id
id:
    id:
        type: integer
        nullable: false
        unsigned: false
        comment: ''
        id: true
        generator:
            strategy: IDENTITY
fields:
    ......
manyToOne:
    result:
        targetEntity: Actionresult
        cascade: {  }
        mappedBy: null
        inversedBy: null
        joinColumns:
            result_id:
                referencedColumnName: id
        orphanRemoval: false

The Entity

<?php

namespace Backend\adminBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

class Activity {
/**
 * @var \Backend\adminBundle\Entity\Actionresult
 *
 * @ORM\ManyToOne(targetEntity="Backend\adminBundle\Entity\Actionresult")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="result_id", referencedColumnName="id")
 * })
 */

private $result;

/**
 * @var \Backend\adminBundle\Entity\SfGuardUser
 *
 * @ORM\ManyToOne(targetEntity="Backend\adminBundle\Entity\SfGuardUser")
 * @ORM\JoinColumns({
 *   @ORM\JoinColumn(name="user_id", referencedColumnName="id")
 * })
 */

/* There are other Properties */



/**
 * Set result
 *
 * @param \Backend\adminBundle\Entity\Actionresult $result
 * @return Activity
 */
public function setResult(\Backend\adminBundle\Entity\Actionresult $result = null)
{
    $this->result = $result;

    return $this;
}

/**
 * Get result
 *
 * @return \Backend\adminBundle\Entity\Actionresult 
 */
public function getResult()
{
    return $this->result;
}

}

Table 2 - Actionresult Related to Activity Table by Id:

表2 - 与Id相关的活动表的Actionresult:

The schema:

Backend\adminBundle\Entity\Actionresult:
type: entity
table: actionresult
id:
    id:
        type: integer
        nullable: false
        unsigned: false
        comment: ''
        id: true
        generator:
            strategy: IDENTITY
fields:
    name:
        type: string
        nullable: false
        length: 255
        fixed: false
        comment: ''
lifecycleCallbacks: {  }

The Entity:

<?php

namespace Backend\adminBundle\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * Actionresult
 *
 * @ORM\Table(name="actionresult")
 * @ORM\Entity
 */
class Actionresult
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    private $id;

    /**
     * @var string
     *
     * @ORM\Column(name="name", type="string", length=255, nullable=false)
     */
    private $name;

    /**
     * Get id
     *
     * @return integer 
     */
    public function getId()
    {
        return $this->id;
    }

    /**
     * Set name
     *
     * @param string $name
     * @return Actionresult
     */
    public function setName($name)
    {
        $this->name = $name;

        return $this;
    }

    /**
     * Get name
     *
     * @return string 
     */
    public function getName()
    {
        return $this->name;
    }
}

The Question:

With doctrine i can refer from table Activity to Actionresult with the name result.

使用doctrine,我可以将表Activity从Actionresult引用到名称result。

How can i refer with doctrine from table Actionresult to Activity??

我怎样才能将表格从Actionresult引用到Activity?

Thank you in advance.

先感谢您。

1 个解决方案

#1

To be thorough, you should try and stick to one type of entity mapping in Symfony whenever possible. The @ORM* annotations are redundant if you use YAML config, and vice-versa. I'll provide the answer using YAML, and I believe you'll be able to convert to annotations if need be.

要彻底,您应尽可能坚持在Symfony中使用一种类型的实体映射。如果使用YAML配置,@ ORM *注释是多余的,反之亦然。我将使用YAML提供答案,我相信如果需要,您将能够转换为注释。

# Activity.yml

Activity:
    type: entity
    ...
    manyToOne:
        result:
            targetEntity: ActionResult
            inversedBy: activities

# ActionResult.yml

Result:
    type: entity
    oneToMany:
        activities:
            targetEntity: Activity
            mappedBy: result


# ActionResult.php

class Result {
  protected $activities;

  public function __construct()
  {
    $this->activities = new Doctrine\Common\Collections\ArrayCollection();
  }

  public function getActivities()
  {
    return $this->activities;
  }

  public function addActivity(Activity $activity)
  {
    $activity->setResult($this);
    $this->activities->add($activity);
  }

  public function removeActivity(Activity $activity)
  {
    $activity->setResult(null);
    $this->activities->removeElement($activity);
  }
}

# Activity.php
class Activity {
  protected $result;

  public function getResult()
  {
    return $this->result;
  }

  public function setResult(ActionResult $result = null)
  {
    $this->result = $result;
  }
}

Reference:

Bidirectional one to many: http://doctrine-orm.readthedocs.org/en/latest/reference/association-mapping.html#one-to-many-bidirectional

双向一对多:http://doctrine-orm.readthedocs.org/en/latest/reference/association-mapping.html#one-to-many-bidirectional