主键+具有重复输入错误的外键

Question

I have two models which are related to each other:

/** @Entity @Table(name="permissions") */
class Permissions {
    /**
     * @Id @GeneratedValue @Column(type="integer")
     * @var integer
     */
    protected $id;

    /**
     * @Column(type="string")
     * @var string
     */
    protected $name;

    public function getId() { return $this->id; }

    public function setName($name) { $this->name = $name; }
    public function getName() { return $this->name; }
}

and

/** @Entity @Table(name="permissions_types") */
class PermissionsTypes {
    /**
     * @Id
     * @OneToOne(targetEntity="Permissions")
     * @JoinColumn(name="perm_id", referencedColumnName="id")
     */
    protected $perm;

    /**
     * @Id
     * @Column(type="integer")
     * @var string
     */
    protected $type;

    /**
     * @Column(type="string")
     * @var string
     */
    protected $name;

    public function setType($type) { $this->type = $type; }
    public function getType() { return $this->type; }

    public function setName($name) { $this->name = $name; }
    public function getName() { return $this->name; }
}

When I want to add to PermissionsTypes two entities with values:

perm | type | name
-------------------
  1  |   0  | test1
  1  |   1  | test2

I get

Duplicate entry '1' for key 'UNIQ_12CF91AFFA6311EF'

error on the 1st column. What I do wrong?

Answer 1

Several problems here...

1. You can't use a related entity as another entity's primary key (@Id)
2. You're using a one-to-one relationship but want to add more than one PermissionTypes per Permissions. This requires a one-to-many association, preferably bi-directional.

Add types to Permissions with

/**
 * @OneToMany(targetEntity="PermissionTypes", mappedBy="perm")
 */
protected $types;

public function __construct()
{
    $this->types = new \Doctrine\Common\Collections\ArrayCollection;
    // see http://www.doctrine-project.org/docs/orm/2.1/en/reference/association-mapping.html#collections
}

and change PermissionTypes to

class PermissionsTypes {

    /**
     * @Id @GeneratedValue
     * @Column(type="integer")
     */
    protected $id;

    /**
     * @ManyToOne(targetEntity="Permissions", inversedBy="types")
     * @JoinColumn(name="perm_id", referencedColumnName="id")
     */
    protected $perm;

You should read the Association Mapping section of the manual carefully.