Adding relationship (and foreign key) between entities

Hi,

Following the guide here, I chose Doctrine Relations and below is my code:

PHP

// src/AppBundle/Entity/Product.php /** * @ORM\ManyToOne(targetEntity="Category", inversedBy="products") * @ORM\JoinColumn(name="category_id", referencedColumnName="category_id") */ private $category; /** * @return Category|null $category */ public function getCategory() { if (null !== $this->category) { return $this->category; } return null; } /** * @param Category|null $category */ public function setCategory($category) { if (null === $category) { $this->category= null; } elseif ($category instanceof Category) { $this->category = $category; }else { throw new \InvalidArgumentException('Category is not valid'); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

// src/AppBundle/Entity/Product.php        /**      * @ORM\ManyToOne(targetEntity="Category", inversedBy="products")      * @ORM\JoinColumn(name="category_id", referencedColumnName="category_id")      */     private $category;       /**      * @return Category|null $category      */     public function getCategory()     {         if (null !== $this->category) {             return $this->category;         }           return null;     }       /**      * @param Category|null $category      */     public function setCategory($category)     {         if (null === $category) {             $this->category= null;         } elseif ($category instanceof Category) {             $this->category = $category;         }else {             throw new \InvalidArgumentException('Category is not valid');         }     }

Now when I get an existing object of product, $prod_obj->getCategory() should be giving me the category of the product but it’s null. The foreign key relation in the DB isn’t made either. Should I be running any commands after this?

How exactly can I get the category name (let’s say category_name from Category entity) using the $prod_obj? The common link between them is the column – category_id (assume same name in both tables).

Thanks.

Topic

[Mike KudelyaParticipant]

Hi,

I have tested your case, on my side it is working, but i think it is a bit incorrect, because general entity should be Product, but now vice versa. I advise you read these acticles: first and second. They will help you better understand doctrine relations.

Product entity:

PHP

<?php namespace Custom\Bundle\OroBundle\Entity; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity * @ORM\Table(name="custom_oro_product") */ class Product { /** * @var integer * * @ORM\Column(type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @ORM\ManyToOne(targetEntity="Category", inversedBy="products") * @ORM\JoinColumn(name="category_id", referencedColumnName="id") */ protected $category; /** * @return Category|null $category */ public function getCategory() { if (null !== $this->category) { return $this->category; } return null; } /** * @param Category|null $category */ public function setCategory($category) { if (null === $category) { $this->category= null; } elseif ($category instanceof Category) { $this->category = $category; }else { throw new \InvalidArgumentException('Category is not valid'); } } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54

<?php   namespace Custom\Bundle\OroBundle\Entity;   use Doctrine\ORM\Mapping as ORM;   /** * @ORM\Entity * @ORM\Table(name="custom_oro_product") */   class Product {     /**      * @var integer      *      * @ORM\Column(type="integer")      * @ORM\Id      * @ORM\GeneratedValue(strategy="AUTO")      */     protected $id;       /**      * @ORM\ManyToOne(targetEntity="Category", inversedBy="products")      * @ORM\JoinColumn(name="category_id", referencedColumnName="id")      */     protected $category;       /**      * @return Category|null $category      */     public function getCategory()     {         if (null !== $this->category) {             return $this->category;         }           return null;     }       /**      * @param Category|null $category      */     public function setCategory($category)     {         if (null === $category) {             $this->category= null;         } elseif ($category instanceof Category) {             $this->category = $category;         }else {             throw new \InvalidArgumentException('Category is not valid');         }     } }

Category entity:

PHP

<?php namespace Custom\Bundle\OroBundle\Entity; use Doctrine\Common\Collections\ArrayCollection; use Doctrine\ORM\Mapping as ORM; /** * @ORM\Entity * @ORM\Table(name="custom_oro_category") */ class Category { /** * @var integer * * @ORM\Column(type="integer") * @ORM\Id * @ORM\GeneratedValue(strategy="AUTO") */ protected $id; /** * @var string * * @ORM\Column(name="name", type="string", length=255) */ protected $name; /** * @ORM\OneToMany(targetEntity="Product", mappedBy="category") */ protected $products; public function __construct() { $this->products = new ArrayCollection(); } public function setName($name) { $this->name = $name; } public function getName() { return $this->name; } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

<?php   namespace Custom\Bundle\OroBundle\Entity;   use Doctrine\Common\Collections\ArrayCollection; use Doctrine\ORM\Mapping as ORM;   /** * @ORM\Entity * @ORM\Table(name="custom_oro_category") */   class Category {     /**      * @var integer      *      * @ORM\Column(type="integer")      * @ORM\Id      * @ORM\GeneratedValue(strategy="AUTO")      */     protected $id;       /**      * @var string      *      * @ORM\Column(name="name", type="string", length=255)      */     protected $name;       /**      * @ORM\OneToMany(targetEntity="Product", mappedBy="category")      */     protected $products;       public function __construct() {         $this->products = new ArrayCollection();     }       public function setName($name)     {         $this->name = $name;     }       public function getName()     {         return $this->name;     } }

Migration:

PHP

<?php namespace Custom\Bundle\OroBundle\Migrations\Schema\v1_0; use Doctrine\DBAL\Schema\Schema; use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag; class Custom implements Migration { /** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { $table = $schema->createTable('custom_oro_product'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('category_id', 'integer', []); $table->setPrimaryKey(['id']); $table = $schema->createTable('custom_oro_category'); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('name', 'string', ['length' => 255]); $table->setPrimaryKey(['id']); } }

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

<?php   namespace Custom\Bundle\OroBundle\Migrations\Schema\v1_0;   use Doctrine\DBAL\Schema\Schema;   use Oro\Bundle\MigrationBundle\Migration\Migration; use Oro\Bundle\MigrationBundle\Migration\QueryBag;   class Custom implements Migration {     /**      * {@inheritdoc}      */     public function up(Schema $schema, QueryBag $queries)     {         $table = $schema->createTable('custom_oro_product');         $table->addColumn('id', 'integer', ['autoincrement' => true]);         $table->addColumn('category_id', 'integer', []);         $table->setPrimaryKey(['id']);           $table = $schema->createTable('custom_oro_category');         $table->addColumn('id', 'integer', ['autoincrement' => true]);         $table->addColumn('name', 'string', ['length' => 255]);         $table->setPrimaryKey(['id']);     } }

Create category:

PHP

$manager = $this->getDoctrine()->getManager(); $category = new Category(); $category->setName('First Category'); $manager->persist($category); $manager->flush();

1 2 3 4 5 6 7

$manager = $this->getDoctrine()->getManager();   $category = new Category(); $category->setName('First Category');   $manager->persist($category); $manager->flush();

Create product:

PHP

$manager = $this->getDoctrine()->getManager(); $category = $manager->getRepository('CustomOroBundle:Category')->find(1); $product = new Product(); $product->setCategory($category); $manager->persist($product); $manager->flush();

1 2 3 4 5 6 7 8 9

$manager = $this->getDoctrine()->getManager();   $category = $manager->getRepository('CustomOroBundle:Category')->find(1);   $product = new Product(); $product->setCategory($category);   $manager->persist($product); $manager->flush();

And finally got category name:

PHP

$manager = $this->getDoctrine()->getManager(); $product = $manager->getRepository('CustomOroBundle:Product')->find(1); $category = $product->getCategory(); $categoryName = $category->getName();

1 2 3 4 5 6

$manager = $this->getDoctrine()->getManager();   $product = $manager->getRepository('CustomOroBundle:Product')->find(1); $category = $product->getCategory();   $categoryName = $category->getName();

[oro_newbieParticipant]

Hi Mike,

The 2 articles that you linked really helped. I was able to identify what’s wrong with the relationship I was trying to create between my entities.

Thank you! Marking this problem as resolved.

[Author]

Replies