php - Doctrine2 级联实体创建

Question

我有两个实体 User 和 UserProfile。 UserProfile primaryKey 值不是 AUTO_INCREMENT，它是使用来自 User 的主键值的一对一关系。当我创建新用户时出现错误:

Entity of type App\PublicBundle\Entity\User\UserProfile is missing an assigned ID for field 'user'. The identifier generation strategy for this entity requires the ID field to be populated before EntityManager#persist() is called. If you want automatically generated identifiers instead you need to adjust the metadata mapping accordingly.

问题是如何用下一个数据库和实体结构保存实体:

用户 DDL:

CREATE TABLE `user` (
  `intUserID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`intUserID`),
)
CREATE TABLE `user_profile` (
  `intUserID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`intUserID`),
  CONSTRAINT `user_profile_ibfk_1` FOREIGN KEY (`intUserID`) REFERENCES `user` (`intUserID`) ON DELETE CASCADE ON UPDATE CASCADE
)

用户实体:

/**
 * @ORM\Table(name="user")
 * @ORM\Entity
 */
class User
{
    /**
     * @var integer
     *
     * @ORM\Id
     * @ORM\Column(name="intUserID", type="integer", nullable=false)
     * @ORM\GeneratedValue(strategy="IDENTITY")
     */
    protected $intuserid;

    /**
     * @var \App\PublicBundle\Entity\User\UserProfile
     *
     * @ORM\OneToOne(targetEntity="\App\PublicBundle\Entity\User\UserProfile",
     *      mappedBy="user",
     *      cascade={"persist", "remove"}
     * )
     */
    protected $profile;
}

用户配置文件实体:

/**
 * @ORM\Table(name="user_profile")
 * @ORM\Entity
 */
class UserProfile
{
    /**
     * @var \App\PublicBundle\Entity\User\User
     *
     * @ORM\Id
     * @ORM\OneToOne(targetEntity="\App\PublicBundle\Entity\User\User",
     *      inversedBy="profile"
     * )
     * @ORM\JoinColumns({
     *   @ORM\JoinColumn(name="intUserID", referencedColumnName="intUserID")
     * })
     */
    protected $user;
}

注册 Action

private function registration(Request $request, $tpl)
{
    $user = new User();
    $form = $this->$form($user, 'Create');
    $form->handleRequest($request);

    if ('POST' === $request->getMethod())
    {
        if ($form->isValid())
        {
            $em->getConnection()->beginTransaction();

            try
            {
                $em = $this->getManager();
                $em->persist($user);
                $em->flush();

                $this->sendSuccessEmail($user);
                $em->getConnection()->commit();
            }
            catch (\Exception $e)
            {
                $em->getConnection()->rollback();
                throw $e;
            }

            return $this->redirect($this->generateUrl('app_profile'));
        }
    }

    return $this->render($tpl, array(
        'entity' => $user,
        'form' => $form->createView()
    ));
}

Answer 1

正确的做法，在persist and flush之前设置为null profile，然后再次调用persist and flush:

注册 Action

private function registration(Request $request, $tpl)
{
    $user = new User();
    $form = $this->$form($user, 'Create');
    $form->handleRequest($request);

    if ('POST' === $request->getMethod())
    {
        if ($form->isValid())
        {
            $em->getConnection()->beginTransaction();

            try
            {
                $user->setProfile(null);

                $em = $this->getManager();
                $em->persist($user);
                $em->flush();

                $user->setProfile(new UserProfile);
                $user->getProfile()->setUser($user);

                $em = $this->getManager();
                $em->persist($user);
                $em->flush();

                $this->sendSuccessEmail($user);
                $em->getConnection()->commit();
            }
            catch (\Exception $e)
            {
                $em->getConnection()->rollback();
                throw $e;
            }

            return $this->redirect($this->generateUrl('app_profile'));
        }
    }

    return $this->render($tpl, array(
        'entity' => $user,
        'form' => $form->createView()
    ));
}