doctrine entity with foreign key to this entity

Question

I have a simple table for recursive categories:

id name parent_id - is a link to id, NULL - for root categories

I need to create a table with foreign key. My class doesn't create this key. How can I change this class to create table with foreign key using "doctrine:schema:create"? What I have tried:

<?php namespace Test\BackEndBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity * @ORM\Table(name="category") */ class Category { /** * @ORM\Id * @ORM\Column(type="bigint", length=20) * @ORM\GeneratedValue(strategy="AUTO") * @var int */ protected $id; /** * @ORM\Column(type="string", length="255") * @var string */ protected $name; /** * @ORM\Column(name="parent_id", type="bigint", length=20, nullable="true") * @ORM\OneToMany(targetEntity="Category") * @ORM\JoinColumn(name="id", onDelete="CASCADE", onUpdate="CASCADE") * @var int */ protected $parentId; /** * Get id * * @return int */ public function getId() { return $this->id; } /** * Set name * * @param string $name */ public function setName($name) { $this->name = $name; } /** * Get name * * @return string */ public function getName() { return $this->name; } }

@Sybio, thanks boss. See my changes.

Alex Pliutau
– Alex Pliutau

2012-09-04 11:28:09 +00:00
Commented Sep 4, 2012 at 11:28 — Alex Pliutau
– Alex Pliutau, Commented Sep 4, 2012 at 11:28

Sybio · Accepted Answer · 2012-09-04 11:32:49Z

You reversed OneToMany with ManyToOne !

See here: http://docs.doctrine-project.org/en/2.0.x/reference/association-mapping.html#one-to-many-self-referencing

In fact, you want that plural subcategories can have one parent cat !

What you need:

/** * @OneToMany(targetEntity="Category", mappedBy="parent") */ private $children; /** * @ManyToOne(targetEntity="Category", inversedBy="children") * @JoinColumn(name="parent_id", referencedColumnName="id") */ private $parent; // ... public function __construct() { $this->children = new \Doctrine\Common\Collections\ArrayCollection(); }

You can replace $parent for $parentId (and mappedBy="parent" for mappedBy="parentId"), but this is not a good coding convention ^^

the link is down.. here is the updated link: doctrine-orm.readthedocs.org/en/latest/reference/…

Collectives™ on Stack Overflow

doctrine entity with foreign key to this entity

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related