[Doctrine2] Klucz obcy w encji., Single id is not allowed on composite primary key in entity Opcje

[ghost1511]

Mam dwie encje:

[PHP] pobierz, plaintext 
<?php
 
namespace Album\Entity;
 
use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Collections\ArrayCollection;
use Album\Entity\Song;
use Doctrine\Common\Collections\Collection;
 
/**
 * Description of Album
 * 
 * @ORM\Entity
 * @ORM\Table(name="Album")
 */
class Album {
 
    /**
     * @ORM\Id
     * @ORM\Column(type="integer");
     * @ORM\GeneratedValue(strategy="AUTO")
     * @var integer 
     */
    protected $albumId;
 
    /**
     * @ORM\Column(type="string")
     */
    protected $artist;
 
    /**
     * @ORM\Column(type="string")
     */
    protected $title;
 
    /**
     *
     * @var ArrayCollection
     * 
     * @ORM\OneToMany(targetEntity="Song", mappedBy="album", cascade={"persist"})
     */
    protected $songs;
 
    function __construct() {
        $this->songs = new ArrayCollection();
    }
 
    function getAlbumId() {
        return $this->albumId;
    }
 
    function getArtist() {
        return $this->artist;
    }
 
    function getTitle() {
        return $this->title;
    }
 
    function setAlbumId($albumId) {
        $this->albumId = $albumId;
    }
 
    function setArtist($artist) {
        $this->artist = $artist;
    }
 
    function setTitle($title) {
        $this->title = $title;
    }
 
    public function addSongs(Collection $songs) {
        foreach ($songs as $song) {
            $song->setAlbum($this);
            $this->songs->add($song);
        }
    }
 
    public function removeSongs(Collection $songs) {
        foreach ($songs as $song) {
        $song->setAlbum(NULL);
        $this->songs->remove($song);
        }
    }
 
    function getSongs() {
        return $this->songs;
    }
 
}
[PHP] pobierz, plaintext 

oraz:

[PHP] pobierz, plaintext 
<?php
 
namespace Album\Entity;
 
use Doctrine\ORM\Mapping as ORM;
use Album\Entity\Album;
 
/**
 * Description of Song
 *
 * 
 * @ORM\Entity
 * @ORM\Table(name="Song")
 */
class Song {
 
    /**
     * @var string 
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     * @ORM\Column(type="string");
     */
    protected $title;
 
    /**
     *
     * @var Album
     * 
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="NONE")
     * @ORM\ManyToOne(targetEntity="Album", inversedBy="songs")
     * @ORM\JoinColumn(name="albumId", referencedColumnName="albumId")
     */
    protected $album;
 
    function getTitle() {
        return $this->title;
    }
 
    function getAlbum() {
        return $this->album;
    }
 
    function setTitle($title) {
        $this->title = $title;
    }
 
    function setAlbum(Album $album) {
        $this->album = $album;
    }
 
 
 
}
[PHP] pobierz, plaintext 

Oraz kontroler:

[PHP] pobierz, plaintext 
<?php
 
namespace Album\Controller;
 
use Zend\Mvc\Controller\AbstractActionController;
use Zend\View\Model\ViewModel;
use Doctrine\ORM\EntityManager;
use DoctrineModule\Stdlib\Hydrator\DoctrineObject as DoctrineHydrator;
use Album\Entity\Album;
 
class AlbumController extends AbstractActionController {
 
    protected $doctrineHydrator;
 
    public function indexAction() {
 
        $killEmAllData = array(
            'artist' => 'Metallica',
            'title' => 'Kill em All',
            'songs' => array(
                array('title' => 'Hit the Lights'),
                array('title' => 'The Four Horsemen'),
                array('title' => 'Motorbreath'),
                array('title' => 'Jump in the Fire'),
                array('title' => '(Anesthesia) Pulling Teeth'),
                array('title' => 'Whiplash'),
                array('title' => 'Phantom Lord'),
                array('title' => 'No Remorse'),
                array('title' => 'Seek & Destroy'),
                array('title' => 'Metal Militia'),
                array('title' => 'Am I Evil?'),
                array('title' => 'Blitzkrieg'),
            )
        );
 
        var_dump($killEmAllData);
 
        $killEmAll = new Album();
        $hydrator = $this->getDoctrineHydrator();
        $killEmAllHydrate = $hydrator->hydrate($killEmAllData, $killEmAll);
 
        $songsCollection = new \Doctrine\Common\Collections\ArrayCollection();
        foreach ($killEmAllData['songs'] as $songArray) {
            $song = $hydrator->hydrate($songArray, new \Album\Entity\Song());
            $songsCollection->add($song);
        }
        $killEmAll->addSongs($songsCollection);
 
        var_dump($killEmAllHydrate);
 
        return new ViewModel();
    }
 
    /**
     * @var DoctrineORMEntityManager
     */
    protected $entityManager;
 
    public function getEntityManager() {
        if (null === $this->entityManager) {
            $this->entityManager = $this->getServiceLocator()->get('doctrine.entitymanager.orm_default');
        }
        return $this->entityManager;
    }
 
    /**
     * @return DoctrineHydrator
     */
    private function getDoctrineHydrator() {
        if (!$this->doctrineHydrator instanceof DoctrineHydrator) {
            $this->doctrineHydrator = new DoctrineHydrator($this->getEntityManager());
        }
        return $this->doctrineHydrator;
    }
 
}
[PHP] pobierz, plaintext 

I otrzymuję błąd:

Kod

Fatal error: Uncaught exception 'Doctrine\ORM\Mapping\MappingException' with message 'Single id is not allowed on composite primary key in entity Album\Entity\Song' in D:\xampp1.8.2\htdocs\testy\DoctrineCompositeForeignKey\vendor\doctrine\orm\lib\Doctrine\ORM\Mapping\MappingException.php on line 414

Czy to ja robię coś źle? Czy to jakieś dziwne ograniczenie doctrine?

Ten post edytował ghost1511 5.11.2014, 14:15:44

[ghost1511]

Problemem nie są dane. Kontroler się nawet nie uruchamia. Doctrine podczas uruchamiania sprawdza powiązania encji i wtedy rzuca błędem, zresztą widać to na Call Stacku który wrzuciłem.

Przykład który podałeś jest bez @ID, które wszystko komplikuje. Spójrz jeszcze raz w dokumentację http://doctrine-orm.readthedocs.org/en/lat...oreign-entities.

The semantics of mapping identity through foreign entities are easy:

Only allowed on Many-To-One or One-To-One associations.

To chyba odpowiedz na moje pytanie.

Jest sposób obejścia tego problemu. Nie jest on może tak elegancki jak hydrator. Ale też zgrabny:

[PHP] pobierz, plaintext 
<?php
 
namespace Album\Entity;
 
use Doctrine\ORM\Mapping as ORM;
use Album\Entity\Album;
 
/**
 * Description of Song
 *
 * @author Bartosz Bartniczak <bbartniczak@zenex.pl>
 * 
 * @ORM\Entity
 * @ORM\Table(name="Song")
 */
class Song {
 
    /**
     * @var string 
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="AUTO")
     * @ORM\Column(type="string");
     */
    protected $title;
 
    /**
     *
     * @var integer
     * 
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="NONE")
     * @ORM\Column(type="integer");
     */
    protected $albumId;
 
    /**
     *
     * @var Album
     * 
     * @ORM\ManyToOne(targetEntity="Album", inversedBy="songs")
     * @ORM\JoinColumn(name="albumId", referencedColumnName="albumId")
     */
    protected $album;
 
    function __construct($title = NULL, Album $album = NULL) {
        $this->setTitle($title);
        if (!is_null($album)) {
            $this->setAlbum($album);
        }
    }
 
    function getTitle() {
        return $this->title;
    }
 
    function getAlbum() {
        return $this->album;
    }
 
    function setTitle($title) {
        $this->title = $title;
    }
 
    function setAlbum(Album $album) {
        $this->album = $album;
        $this->albumId = $album->getAlbumId();
    }
 
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
public function indexAction() {
 
        $killEmAllData = array(
            'artist' => 'Metallica',
            'title' => 'Kill em All',
            'songs' => array(
                array('title' => 'Hit the Lights'),
                array('title' => 'The Four Horsemen'),
                array('title' => 'Motorbreath'),
                array('title' => 'Jump in the Fire'),
                array('title' => '(Anesthesia) Pulling Teeth'),
                array('title' => 'Whiplash'),
                array('title' => 'Phantom Lord'),
                array('title' => 'No Remorse'),
                array('title' => 'Seek & Destroy'),
                array('title' => 'Metal Militia'),
                array('title' => 'Am I Evil?'),
                array('title' => 'Blitzkrieg'),
            )
        );
 
        $songs = $killEmAllData['songs'];
        unset($killEmAllData['songs']);
 
//        var_dump($killEmAllData);
//
        $hydrator = $this->getDoctrineHydrator();
        $killEmAll = $hydrator->hydrate($killEmAllData, new Album());
        $this->getEntityManager()->persist($killEmAll);
        $this->getEntityManager()->flush();
 
        $songsCollection = new \Doctrine\Common\Collections\ArrayCollection();
        foreach ($songs as $songArray) {
            $songArray['album'] = $killEmAll;
            $song = $hydrator->hydrate($songArray, new \Album\Entity\Song());
            $songsCollection->add($song);
        }
        $killEmAll->addSongs($songsCollection);
 
        $this->getEntityManager()->persist($killEmAll);
        $this->getEntityManager()->flush();
 
        return new ViewModel();
    }
[PHP] pobierz, plaintext 

Chyba, że ktoś jednak wie jak to ominąć. Wygląda na to, że Doctrine nie radzi sobie ze złożonymi kluczami obcymi.