Doctrine2映射：映射到一个字段的2个字段（ManyToOne） [英] Doctrine2 Mapping: 2 fields mapped to one field (ManyToOne)

问题描述

我有2个实体，即Match和Team。一队可以有一对多的比赛。但是，我的Match实体consts是引用同一个实体Team的2个字段。他们是$ homeTeam和$ awayTeam。我如何在Team，$ matches中作为双向关系引用相同的字段？

我目前的非工作代码如下：

我的匹配实体：

  / ** 
 * @ ORM\Entity 
 * @ ORM\Table（name =match）
 ** / 
 class Match {
 
 / ** 
 * @ ORM\ManyToOne （targetEntity =Team，inversedBy =matches）
 * @ ORM\JoinColumn（name =home_team_id，referencedColumnName =id）
 * ** / 
 protected $ homeTeam; 
 
 / ** 
 * @ ORM\ManyToOne（targetEntity =Team，inversedBy =matches）
 * @ ORM\JoinColumn（name =away_team_id ，referencedColumnName =id）
 * ** / 
 protected $ awayTeam; 
  

我的团队实体（我不会假定？）：

  / ** 
 * @ ORM\Entity 
 * @ ORM\Table（name =team）
 * * * / 
 class Team {
 
 / ** @ ORM\OneToMany（targetEntity =Match，mappedBy =homeTeam，mappedBy =awayTeam）** / 
保护$ match; 
  

解决方案

探索 Doctrine的官方文档：您不能添加多个 mappedBy 列。而不是这样，您可以选择：

1. 为匹配创建自定义存储库并定义方法 getAllMatchesForTeam（$ team）


2. 定义适当的关系 $ homeMatches 和 $ awayMatches +方法 getAllMatches（）在团队和 $ homeMatches 和 $ awayMatches 有

在此阅读更多：

1. https://stackoverflow.com/questions/13922047/symfony2-doctrine2-how-to-implement-methods- on-entity-to-retrieve-related-ent


2. 自定义存储库类Symfony2


3. Fetchin g数据通过Twig扩展名中的自定义存储库


4. 如何使用Symfony2访问控制器之外的服务？

I have 2 entities, namely Match and Team. A Team can have one to many Matches. However, my Match entity consts of 2 fields which reference the same entity, Team. They are $homeTeam and $awayTeam. How do I reference the same field in Team, $matches, as a Bidirectional relationship?

My current non-working code is below:

My Match Entity:

/**
 * @ORM\Entity
 * @ORM\Table(name="match")
 **/
class Match {

    /**
     * @ORM\ManyToOne(targetEntity="Team", inversedBy="matches")
     * @ORM\JoinColumn(name="home_team_id", referencedColumnName="id")
     * **/
    protected $homeTeam;

    /**
     * @ORM\ManyToOne(targetEntity="Team", inversedBy="matches")
     * @ORM\JoinColumn(name="away_team_id", referencedColumnName="id")
     * **/
    protected $awayTeam;

My Team Entity (incorrect I would presume?):

/**
 * @ORM\Entity
 * @ORM\Table(name="team")
 * **/
class Team {

    /** @ORM\OneToMany(targetEntity="Match", mappedBy="homeTeam", mappedBy="awayTeam") **/
    protected $matches;

解决方案

After exploring Doctrine's official docs: you can't add multiple mappedBy columns. Instead of this, you can choose between:

1. Create a custom repository for Match and define method getAllMatchesForTeam($team)
2. Define appropriate relations $homeMatches and $awayMatches + method getAllMatches() on Team and union results of $homeMatches and $awayMatches there

Read more here:

1. https://stackoverflow.com/questions/13922047/symfony2-doctrine2-how-to-implement-methods-on-entity-to-retrieve-related-ent
2. Custom repository class in Symfony2
3. Fetching data through a custom repository in a Twig extension
4. How can I access a service outside of a controller with Symfony2?

这篇关于Doctrine2映射：映射到一个字段的2个字段（ManyToOne）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！