在Doctrine中，是否需要仅创建一个类以进行联接？ [英] In Doctrine, do I need do create a class only to make a join?

问题描述

我正在尝试加入我的存储库类（Symfony 3和Doctrine）。

I'm trying to make a join in my repository class (Symfony 3 with Doctrine).

它是这样的：

public function findByRole($roles){
        $qb = $this->createQueryBuilder('u')
            ->join('user_role', 'ur', Join::ON, 'ur.id = u.customerId');
        $q = $qb->getQuery();

        $users = $q->getArrayResult();
        dump($users);
    }

我有这个错误：

[语义错误]第0行，'user_role ur'附近的第49列：错误：类
'user_role'未定义。

[Semantical Error] line 0, col 49 near 'user_role ur': Error: Class 'user_role' is not defined.

定义了两个实体类-用户和角色。角色是User（ManyToMany）的属性。

There are two entity classes defined - User and Role. And Role is a property of User (ManyToMany).

还有一个联接表-user_role-即使我不这样做，是否也需要为每个联接表创建一个类吗？

There is also a joining table - user_role - do I need to create a class for every joining table even if I don't need it for my own purposes?

ps
我知道可以在Stackoverflow上找到此错误，但是遇到此问题的人可能会有不同的问题。

p.s. I know this error can be already found on Stackoverflow, but people having this issue probably have different problems.

更新：

以下是User实体类（缩短了）：

Here's the User entity class (shortened):

/**
 * @ORM\Table(name="user")
 * @ORM\Entity(repositoryClass="AppBundle\Repository\UserRepository")
 */
class User implements AdvancedUserInterface, \Serializable {

    /**
     * @ORM\Column(type="integer")
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     */
    private $id;

    //irrelevant code removed

    /**
     *
     * @ORM\ManyToMany(targetEntity="AppBundle\Entity\Role", cascade = {"persist"}, inversedBy="users")
    *  @ORM\JoinTable(name="user_role",
    *      joinColumns={@ORM\JoinColumn(name="user_id",
    * referencedColumnName="id")},
    *      inverseJoinColumns={@ORM\JoinColumn(name="role_id",
    * referencedColumnName="id")}
    *      )
     */
    private $roles;

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


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

    ////////////////////////////////
    //roles

    /**
     * Add role
     * @param \AppBundle\Entity\Role $role
     *
     * @return User
     */
    public function addRole(\AppBundle\Entity\Role $role) {
        $this->roles[] = $role;
        return $this;
    }

    public function setRoles(\AppBundle\Entity\Role $role){
        $this->addRole($role);
        return $this;
    }
    /**
     * Remove role
     * @param \AppBundle\Entity\Role $role
     */
    public function removeRole(\AppBundle\Entity\Role $role) {
        $this->roles->removeElement($role);
    }

    /**
     * I know it probably should return simply $this->roles, but the interface I'm implementing requires an array of strings... But everything works fine, except joining user+roles  
     * @return \Doctrine\Common\Collections\Collection
     */
    public function getRoles() {
        return $this->roles->toArray();
    }

    /**
     * Get roles
     * @return \Doctrine\Common\Collections\Collection
     */
    public function getRoleEntities() {
        return $this->roles;
    }



}

推荐答案

我的观点是，所有连接的对象必须是实体。

I doctrine, all joined objects must be entities.

但是您可以映射实体之间的多对多关系用户和角色，使用user_role作为链接表

But you can map a many-to-many relationship between the entities User and Role, using user_role as a linkage table

在用户表中，您可能具有属性 $ roles

In user table you might have a property $roles

/**
* @ManyToMany(targetEntity="Role", inversedBy="users")
* @JoinTable(name="user_role",
*      joinColumns={@JoinColumn(name="user_id",
* referencedColumnName="id")},
*      inverseJoinColumns={@JoinColumn(name="role_id",
* referencedColumnName="id")}
*      )
*/
private $roles;

和角色表中的属性 $ users

    /**
* @ManyToMany(targetEntity="User", inversedBy="roles")
* @JoinTable(name="user_role",
*      joinColumns={@JoinColumn(name="role_id",
* referencedColumnName="id")},
*      inverseJoinColumns={@JoinColumn(name="user_id",
* referencedColumnName="id")}
*      )
*/
private $users;

我尚未测试此代码。当然，这需要一些周游。
您还需要为这些属性创建getter和setter。

I've not tested this code. Surely It gonna need some tweeking. You also need to created the getters and setters for these properties.

这篇关于在Doctrine中，是否需要仅创建一个类以进行联接？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！