CODEWITHSUNDEEP
phpsymfonydoctrine-ormforeign-keys
Yoni Elyo
Yoni Elyo

Reputation: 517

How to set the id of a foreign key id #sf2 #doctrine2

I'm trying to manually set an foreign key id to an object, but didn't find how to do it

class Item
{
    /**
     * @ORM\ManyToOne(targetEntity="MyBundle\Entity\ItemType", inversedBy="itemTypes")
     * @ORM\JoinColumn(name="type_id", referencedColumnName="id")
     */
    protected $item_type;
}

Is there a way to do something link that?

$item = new Item();
$item->setItemTypeId(1); // This generate an error.

Or do i have to do like that ?

$item = new Item();
$type = Repository::RetrieveById(1);
$item->setItemType($type); // This generate an error.

Upvotes: 3

Views: 2020

Answers (2)

matthew
matthew

Reputation: 2254

This can be done using Reference Proxies, which let you obtain a reference to an entity for which the identifier is known, without loading that entity from the database.

$type = $em->getReference('MyBundle\Entity\ItemType', 1);
$item->setItemType($type);

Upvotes: 7

Max Małecki
Max Małecki

Reputation: 1702

  1. First of all(Do you have relation defined in ItemType Class?):

    inversedBy="item"

  2. So Second:

    Repository::RetrieveById(1); // Not valid code for the repository methods

  3. Replace this with:

    $type = $this->getDoctrine()->getRepository('ACMEBundle:ItemType')->find(1);

  4. And the second usage will be close to documentation.

Upvotes: 0

Related Questions