Ask a Question Register Login

php - Symfony Doctrine One to Many does not insert foreign key

903

Solution:

Firstly, you have to understand that Doctrine and Symfony does not work with id's within your entities.In Einsatztag entity, your property should not be called $Buchung_id since it's an instance of buchung and not an id you will find out there.

Moreover, in your loop, you add the Einsatztag to Buchung. But do you process the reverse set ?

I do it this way to always reverse the set/add of entities.

Einsatztag

public function setBuchung(Buchung $pBuchung, $recurs = true){
     $this->buchung = $pBuchung;

     if($recurs){
        $buchung->addEinsatztag($this, false);
     }
}

Buchung

public function addEinsatztag(Einsatztag $pEinsatztag, $recurs = true){
     $this->einsatztages[] = $pEinsatztag;

     if($recurs){
        $pEinsatztag->setBuchung($this, false);
     }
}

Then, when you will call 

$buchung->addEinsatztag($einsatztag);

Or

$einsatztag->set($buchung);

The relation will be set on both side making your FK to be set. Take care of this, you'll have some behavior like double entries if you do not use them properly.

SImplier , you can use default getter/setters and call them on both sides of your relation, using what you already have, like following:

$einsatztag->set($buchung);
$buchung->addEinsatztag($einsatztag);

Hope it helped ;)

567

Answer

Solution:

First of all, don't use_id properties in your code. Let it be$buchung. If you want it in the database, do it in the annotation. And this also the reason, why it's not working. Your are mapping tobuchung, but your property is$Buchung_id

<?php
/** @ORM\Entity **/
class Buchung
{
    // ...

    /**
     * @ORM\OneToMany(targetEntity="Einsatztag", mappedBy="buchung")
     **/
    private $einsatztage;

    // ...
}

/** @ORM\Entity **/
class Einsatztag
{
    // ...

    /**
     * @ORM\ManyToOne(targetEntity="Product", inversedBy="einsatztage")
     * @JoinColumn(name="buchung_id", referencedColumnName="id")
     **/
    private $buchung;

    // ...
}

You don't have to write the@JoinColumn, because<propertyname>_id would the default column name.

612

Answer

Solution:

I'm going to ignore the naming issue and add a fix to the actual problem.

You need to have in the adder method a call to set the owner.

//Buchung entity 
public function addEinsatztage($einsatztag)
{
    $this->einsatztags->add($einsatztag);
    $ein->setBuchung($this);
}

And to have this adder called when the form is submitted you need to add to the form collection field theby_reference property set tofalse.

Here is the documentation:

Similarly, if you're using the CollectionType field where your underlying collection data is an object (like with Doctrine's ArrayCollection), then by_reference must be set to false if you need the adder and remover (e.g. addAuthor() and removeAuthor()) to be called.

http://symfony.com/doc/current/reference/forms/types/collection.html#by-reference

People are also looking for solutions to the problem: php - Apache2 ModSecurity2 does not work (Ubuntu 14.04)

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.