No idea?
Am Montag, 1. Dezember 2014 12:56:35 UTC+1 schrieb Petoria:
>
> Hi everyone,
>
> hopefully you can help us with this question.
>
> In our project we have several "model" entities which have a many-to-one
> association to a corresponding "visualization" entity, which describes the
> entity in some way (like sort-orders). Each model entity has its one
> visualization entity. The visualization entities are stored in a single
> table via discriminators. In short (only important attributes, etc are
> shown) this is how this looks like:
>
> /** @MappedSuperclass
> *
> **/
> class SortableEntity //<<<------ This class is just an attempt to have
> superclass which can be used in the entity "Visualization" as targetEntity.
> We actually don't need this entity.
> {
> /**
> * @OneToMany(targetEntity="Visualization", mappedBy="id",
> * cascade={"persist"})
> * @JoinColumn(name="key", referencedColumnName="descriptor_key")
> **/
> public $visualization;
> }
>
>
>
> /** @Entity
> * @Table(name="measure___milestone") **/
> class Milestone extends SortableEntity
> {
> /** @Id @GeneratedValue @Column(type="bigint", name="key") **/
> public $id;
>
> /**
> * @OneToMany(targetEntity="VisualizationMilestone", mappedBy="id",
> * cascade={"persist"})
> * @JoinColumn(name="key", referencedColumnName="descriptor_key")
> **/
> public $visualization;
>
> }
>
>
> /**
> * @Entity
> * @Table(name="ent___visualization")
> * @InheritanceType("SINGLE_TABLE")
> * @DiscriminatorColumn(name="object_type", type="string")
> * @DiscriminatorMap({"measure_milestone"="VisualizationMilestone",
> "measure_financial_kpi"="VisualizationFinancialKPI",
> "measure_measure_kpi"="VisualizationKPI", "unit"="VisualizationUnit",
> "country"="VisualizationCountry",
> "business_unit"="VisualizationBusinessUnit","sub_region"="VisualizationSubRegion","region"="VisualizationRegion","sales_line"="VisualizationSalesLine","process"="VisualizationProcess"})
> */
> class Visualization
> {
>
> /**
> * @Id @ManyToOne(targetEntity="SortableEntity")
> * @JoinColumn(name="descriptor_key", referencedColumnName="key")
> **/
> protected $id;
>
> }
>
>
> /** @Entity **/
> class VisualizationMilestone extends Visualization
> {
> /**
> * @Id @ManyToOne(targetEntity="Milestone")
> * @JoinColumn(name="descriptor_key", referencedColumnName="key")
> **/
> protected $id;
>
> }
>
> As you can see, the model entity has an association to the visualization
> entity and the visualization an association back to the model entity. And
> here lays our problem: It seems like doctrine is ignoring the targetEntity
> "Milestone" in the entity VisualizationMilestone (or our approach is wrong
> in the first place). When trying to create a new VisualizationMilestone
> entity we get an error.
>
> Code for creating new entity:
>
> $newMilestone = $this->getOrCreateCachedObject('Milestone',
> 'setMeasure', $measure);
> if($newMilestone instanceof Milestone) {
>
> if(is_null($newMilestone->getDescription())) {
> $newMilestone->setDescription(''); }
> if(is_null($newMilestone->getResult())) { $newMilestone->setResult(''); }
> $newMilestone->setTitle($value);
> $milestones = $measure->getMilestones();
> $milestones->add($newMilestone);
> $countMilestones = count($milestones);
> $milestoneVisualization = new VisualizationMilestone();
> $milestoneVisualization->setId($newMilestone);
> $milestoneVisualization->setOrder($countMilestones);
> $milestoneVisualization->setStyleClass('');
> if(!Guard::checkDemoUserAuth()) {
> $this->entityManager->flush();
> }
> $this->entityManager->persist($milestoneVisualization);
> }
>
>
> Error we get:
>
> "An exception occurred while executing 'INSERT INTO ent___visualization
> (`order`, `style_class`, `descriptor_key`, `object_type`) VALUES (?, ?, ?,
> ?)' with params
> {"1":43,"2":"","3":null,"4":"measure_milestone"}:SQLSTATE[23000]: Integrity
> constraint violation: 1048 Column 'descriptor_key' cannot be null"
>
> I found this pull request <https://github.com/doctrine/doctrine2/pull/633>
> which added the functionality to override the targetEntity. Unfortunately
> it was closed with the comment, that this situation should never come up
> with a correct inheritance. In our case, where is our problem?
>
> If anything is unclear, please just ask.
>
> Many thanks!
>
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
