Symfony 一对一关系 [英] Symfony ONE-TO-ONE relation

问题描述

我是 symfony2 的新手，无法在 2 个实体之间进行左连接.我收到以下错误消息，不知道如何解决此问题:

I am new to symfony2 and have trouble to do a left join between 2 entities. I'm getting following error message, and don't know how to solve this problem:

[语义错误] 第 0 行，第 69 列靠近i":错误:类BundleEntityUsers 没有名为 user_id 的关联

[Semantical Error] line 0, col 69 near 'i': Error: Class BundleEntityUsers has no association named user_id

实体用户:

class Users
{
    /**
     * @ORMId
     * @ORMColumn(name="user_id", type="string", length="16")
     * @ORMOneToOne(targetEntity="UsersInformation", mappedBy="Users")
     */
    protected $user_id;

    /**
     * @ORMColumn(type="string", length="255")
     */
    protected $username;


    /**
     * @ORMColumn(type="string", length="32")
     */
    protected $password;

    ...

     /**
     * Set user_id
     *
     * @param string $userId
     */
    public function setUserId($userId)
    {
        $this->user_id = $userId;
    }

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

    ...
}

实体用户信息:

 class UsersInformation
  {
    /**
     * @ORMId
     * @ORMColumn(type="string", length="16")
     * @ORMOneToOne(targetEntity="Users", inversedBy="UsersInformation")
     * @ORMJoinColumn(name="user_id", referencedColumnName="user_id")
     */
    protected $user_id;

    /**
     * @ORMColumn(type="string", length="255")
     */
    public $email;

    /**
     * @ORMColumn(type="string", length="1")
     */
    public $gender;

    /**
     * @ORMColumn(type="string", length="255")
     */
    public $company;

    ....
  }

UsersRepository 如下所示:

The UsersRepository looks like this:

public function getAllUsers($limit = null)
  {
        $qb = $this->createQueryBuilder('u')
                   ->select('u, i')
                   ->leftJoin('u.user_id', 'i');


        if (false === is_null($limit))
            $qb->setMaxResults($limit);

        return $qb->getQuery()
                  ->getResult();
   }

我做错了什么?

推荐答案

我认为 querybuilder 看起来不错.您的问题可能出在数据结构中.

I think the querybuilder looks alright. Your problem is likely in the data structure.

您通常处理此问题的方式是为每个关系设置一个属性.例如，对于您的 Users 类，有一个 information 或 userInformation 是有意义的.

The way you normally approach this is by setting up a property per relation. For your Users class it'd make sense to have an information or userInformation one for example.

也许这样的事情有帮助?

Perhaps something like this helps?

class User
{
    /**
     * @ORMId
     */
    protected $id;

    /**
     * @ORMOneToOne(targetEntity="UserInformation")
     */
    protected $information;
}

class UserInformation
{
    /**
     * @ORMId
     */
    protected $id;

    /**
     * @ORMOneToOne(targetEntity="User", inversedBy="information")
     * @ORMJoinColumn(name="user_id", referencedColumnName="id")
     */
    protected $user;
}

这篇关于Symfony 一对一关系的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！