category.orm.xml

<?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"
                  xmlns:gedmo="http://gediminasm.org/schemas/orm/doctrine-extensions-mapping"
                  xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
    <entity name="Luxodo\Bundle\ProductionBundle\Entity\Category" table="category" repository-class="Gedmo\Tree\Entity\Repository\NestedTreeRepository">
        <id name="id" type="integer" column="id">
            <generator strategy="IDENTITY"/>
        </id>
        
        <gedmo:translation entity="Luxodo\Bundle\ProductionBundle\Entity\CategoryTranslation">
        </gedmo:translation>
    
        <field name="name" type="string" length="128">
            <gedmo:translatable/>
        </field>
        <field name="left" column="lft" type="integer">
            <gedmo:tree-left/>
        </field>
        <field name="right" column="rgt" type="integer">
            <gedmo:tree-right/>
        </field>
        <field name="root" type="integer">
            <gedmo:tree-root/>
        </field>
        <field name="level" column="lvl" type="integer">
            <gedmo:tree-level/>
        </field>

        <many-to-one field="parent" target-entity="Luxodo\Bundle\ProductionBundle\Entity\Category" inversed-by="children">
            <join-column name="parent_id" referenced-column-name="id" on-delete="SET NULL"/>
            <gedmo:tree-parent/>
        </many-to-one>
        
        <one-to-many target-entity="Luxodo\Bundle\ProductionBundle\Entity\Category" mapped-by="parent" field="children">
             <order-by>
                <order-by-field name="left" direction="ASC" />
            </order-by>
        </one-to-many>
        

        <gedmo:tree type="nested"/>
        
        <one-to-many target-entity="Luxodo\Bundle\ProductionBundle\Entity\CategoryTranslation" mapped-by="object" field="translations">
         <cascade>
             <cascade-persist />
             <cascade-remove />
         </cascade>
        </one-to-many>
    
    </entity>
</doctrine-mapping>