We have some problems querying an entity with embedded sub entities. First
let me sketch the context:
- We have a table with *Offer* entities
- Each *Offer* consists of *multiple* *Offerlines*
- Each *Offerline* has *one* related *Generalassuranceline*
- Each *Generalassuranceline* has *one* related *Possession*
- This *Possession* has a discriminator column defined to distinguish
two possession subtypes: *Vehicle* and *Misc*
In the mapping of *Generalassuranceline* the *Possession* is defined as a
many-to-one relation (named 'object') to the generic *Possession* type,
because at the *Generalassuranceline* level the 'object' can be either a
*Vehicle* or a *Misc* entity.
The detailed mappings of the entities are listed below.
The DQL query we execute is the following:
SELECT
offer,
offerline,
generalassuranceline
FROM
Entity\Offer\Offer offer
INNER JOIN offer.offerlines offerline
INNER JOIN offerline.generalassuranceline generalassuranceline
WHERE
offer.id = 6749
*Problem: *
In the database, the *offer* we query has two *offerlines*. In the
following situations, the output is generated by:
\Doctrine\Common\Util\Debug::dump($query->getResult(), 3);
Situation 1:
If we specify the "object" relation in *Generalassuranceline* as type
*Possession*, we only get one *offerline* entity in our result.
array(1) {
[0]=>
object(stdClass)#27 (5) {
["__CLASS__"]=>
string(18) "Entity\Offer\Offer"
["id"]=>
int(6749)
["offernumber"]=>
string(8) "98037192"
["description"]=>
string(13) "auto 29-KQB-3"
["offerlines"]=>
* array*
*(1) { [0]=> string(22) "Entity\Offer\Offerline" }*
}
}
Situation 2:
If we specify the "object" relation in *Generalassuranceline* as type
*Vehicle*, we get both the *offerline* entities as expected.
array(1) {
[0]=>
object(stdClass)#27 (5) {
["__CLASS__"]=>
string(18) "Entity\Offer\Offer"
["id"]=>
int(6749)
["offernumber"]=>
string(8) "98037192"
["description"]=>
string(13) "auto 29-KQB-3"
["offerlines"]=>
* array*
*(2) { [0]=> string(22) "Entity\Offer\Offerline" [1]=>
string(22) "Entity\Offer\Offerline" }*
}
}
Can someone explain to us the reason why we get only one *offerline* entity
in the *offer* result in situation 1 and what we can change to retrieve
more reliable results?
*Mappings:*
*Offer*
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping
xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd";>
<entity name="Entity\Offer\Offer" table="accountingoffer">
<id name="id" type="integer" column="id">
<generator strategy="IDENTITY"/>
</id>
<field name="offernumber" type="string" column="offernumber" length=
"255" nullable="true" />
<field name="description" type="string" column="description" length=
"255" nullable="true" />
<one-to-many field="offerlines" target-entity="Entity\Offer\Offerline"
mapped-by="offer" fetch="LAZY" />
</entity>
</doctrine-mapping>
*Offerline*
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping
xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd";>
<entity name="Entity\Offer\Offerline" table="accountingofferline">
<id name="id" type="integer" column="id">
<generator strategy="IDENTITY"/>
</id>
<field name="offernumber" type="string" column="offernumber" length=
"255" nullable="true" />
<many-to-one field="offer" target-entity="Entity\Offer\Offer"
inversed-by="offerlines">
<join-column name="accountingoffer_id" referenced-column-name="id"/>
</many-to-one>
<one-to-one field="generalassuranceline" target-entity=
"Entity\Offer\Generalassuranceline" mapped-by="offerline" />
</entity>
</doctrine-mapping>
*Generalassuranceline*
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping
xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd";>
<entity name="Entity\Offer\Generalassuranceline" table=
"accountingofferline_generalassurance">
<id name="offerlineId" type="integer" column="accountingofferline_id">
<generator strategy="IDENTITY"/>
</id>
<one-to-one field="offerline" target-entity="Entity\Offer\Offerline"
inversed-by="generalassuranceline">
<join-column name="accountingofferline_id" referenced-column-name=
"id"/>
</one-to-one>
<many-to-one field="object" target-entity="Entity\Possession\Possession"
fetch="LAZY">
<join-column name="crmpossession_id" referenced-column-name="id"/>
</many-to-one>
</entity>
</doctrine-mapping>
*Possession*
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping
xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd";>
<entity name="Entity\Possession\Possession" table="crmpossession"
inheritance-type="SINGLE_TABLE">
<id name="id" type="integer" column="id">
<generator strategy="IDENTITY"/>
</id>
<discriminator-column name="crmpossessiontypecategory_id" type="integer"
/>
<discriminator-map>
<discriminator-mapping value="1" class="Entity\Possession\Vehicle"
/>
<discriminator-mapping value="2" class="Entity\Possession\Misc" />
</discriminator-map>
<field name="description" type="string" column="description" length=
"255" nullable="true" />
</entity>
</doctrine-mapping>
*Vehicle*
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping
xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd";>
<entity name="Entity\Possession\Vehicle" />
</doctrine-mapping>
*Misc*
<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping
xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping
http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd";>
<entity name="Entity\Possession\Misc" />
</doctrine-mapping>
--
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 https://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
