Doctrine Object-XML Mapper

Mapped-superclass, indexes not gathered

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Critical Critical
  • Resolution: Unresolved
  • Labels:
    None
  • Environment:
    win7 xamp mysql

Description

GenericPositionPair XML:
<mapped-superclass name="GenericPositionPair">
<indexes>
<index columns="position" />
</indexes>
<field name="position" type="integer" column="position" />
</mapped-superclass>

GenericPrimaryPositionPair XML:
<mapped-superclass name="GenericPrimaryPositionPair">
<indexes>
<index columns="isPrimary" />
</indexes>
<field name="isPrimary" type="boolean" column="isPrimary" />
</mapped-superclass>

PrimaryPositionPair XML:
<entity name="PrimaryPositionPair" table="PrimaryPositionPair">
<id name="first" type="integer" column="first_id" association-key="true" />
<id name="second" type="integer" column="second_id" association-key="true" />
<many-to-one field="first" target-entity="First">
<join-column name="first_id" referenced-column-name="id" />
</many-to-one>
<many-to-one field="second" target-entity="Second">
<join-column name="second_id" referenced-column-name="id" />
</many-to-one>
</entity>

PHP:
PrimaryPositionPair exteds GenericPrimaryPositionPair
GenericPrimaryPositionPair extends GenericPositionPair

Finally - the resulting SQL statement contains no idexes on position and isPrimary fields.

Suggestion - wouldn't it be easier to just include attribute index="true" instead od <indexes> tag, since attribute unique="true" already works.

Activity

Ascending order - Click to sort in descending order
Lazar Otasevic made changes -
Field Original Value New Value
Description GenericPositionPair XML:
  <mapped-superclass name="GenericPositionPair">
    <indexes>
      <index columns="position" />
    </indexes>
    <field name="position" type="integer" column="position" />
  </mapped-superclass>

GenericPrimaryPositionPair XML:
  <mapped-superclass name="GenericPrimaryPositionPair">
    <indexes>
      <index columns="isPrimary" />
    </indexes>
    <field name="isPrimary" type="boolean" column="isPrimary" />
  </mapped-superclass>

PrimaryPositionPair XML:
  <entity name="PrimaryPositionPair" table="PrimaryPositionPair">
    <id name="first" type="integer" column="first_id" association-key="true" />
    <id name="second" type="integer" column="second_id" association-key="true" />
    <many-to-one field="first" target-entity="First">
      <join-column name="first_id" referenced-column-name="id" />
    </many-to-one>
    <many-to-one field="second" target-entity="Second">
      <join-column name="second_id" referenced-column-name="id" />
    </many-to-one>
  </entity>

PHP:
PrimaryPositionPair exteds GenericPrimaryPositionPair
GenericPrimaryPositionPair extends GenericPositionPair

Finally - the resulting SQL statement contains no idexes on position and isPrimary.

Suggestion - wouldn't it be easier to just include attribute index="true" instead od <indexes> tag, since attribute unique="true" already works.
 GenericPositionPair XML:
  <mapped-superclass name="GenericPositionPair">
    <indexes>
      <index columns="position" />
    </indexes>
    <field name="position" type="integer" column="position" />
  </mapped-superclass>

GenericPrimaryPositionPair XML:
  <mapped-superclass name="GenericPrimaryPositionPair">
    <indexes>
      <index columns="isPrimary" />
    </indexes>
    <field name="isPrimary" type="boolean" column="isPrimary" />
  </mapped-superclass>

PrimaryPositionPair XML:
  <entity name="PrimaryPositionPair" table="PrimaryPositionPair">
    <id name="first" type="integer" column="first_id" association-key="true" />
    <id name="second" type="integer" column="second_id" association-key="true" />
    <many-to-one field="first" target-entity="First">
      <join-column name="first_id" referenced-column-name="id" />
    </many-to-one>
    <many-to-one field="second" target-entity="Second">
      <join-column name="second_id" referenced-column-name="id" />
    </many-to-one>
  </entity>

PHP:
PrimaryPositionPair exteds GenericPrimaryPositionPair
GenericPrimaryPositionPair extends GenericPositionPair

Finally - the resulting SQL statement contains no idexes on position and isPrimary fields.

Suggestion - wouldn't it be easier to just include attribute index="true" instead od <indexes> tag, since attribute unique="true" already works.
Hide
Permalink
Lazar Otasevic added a comment -

As far as i can see, the shcema-tool gathers only fields and relations from xml and not <indexes> WHY?
Since it fetches unique attribute from a field and accordingly adds an unique index to the final statement, wouldnt it be natural to also gether indexes?
My suggestion remains about index attribute of a field.

Show
Lazar Otasevic added a comment - As far as i can see, the shcema-tool gathers only fields and relations from xml and not <indexes> WHY? Since it fetches unique attribute from a field and accordingly adds an unique index to the final statement, wouldnt it be natural to also gether indexes? My suggestion remains about index attribute of a field.
Lazar Otasevic made changes -
Summary Multiple level mapped-superclass, indexes not working Mapped-superclass, indexes not gathered
Hide
Permalink
Lazar Otasevic added a comment -

Anybody?

Show
Lazar Otasevic added a comment - Anybody?
Hide
Permalink
Lazar Otasevic added a comment -

HELLO?

Show
Lazar Otasevic added a comment - HELLO?
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
  • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=OXM-2, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Benjamin Eberlei
    Reporter:
    Lazar Otasevic
Vote (3)
Watch (0)

Dates

  • Created:
    Updated: