PHP - Moved: Php Doctrine With Zend Framework

I don't think php is installed/enabled?!

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=354544.0

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=320893.0

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=330453.0

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=347443.0

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=345426.0

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=353397.0

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=327717.0

This topic has been moved to Application Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=317468.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=322256.0

This topic has been moved to Application Design.

http://www.phpfreaks.com/forums/index.php?topic=332538.0

I think I am close, but not sure if I am quite there.  Am I doing this correctly?

I have several entity classes which will use class type inheritance:

MyNamespace\MyApp\Vehicle\Vehicle
    MyNamespace\MyApp\Vehicle\AirVehicle\AirVehicle
        MyNamespace\MyApp\Vehicle\AirVehicle\Airplane\Airplane
        MyNamespace\MyApp\Vehicle\AirVehicle\Rocket\Rocket
    MyNamespace\MyApp\Vehicle\GroundVehicle\GroundVehicle
        MyNamespace\MyApp\Vehicle\GroundVehicle\Car\Car
        MyNamespace\MyApp\Vehicle\GroundVehicle\Train\Train
                
The entity meta data is as follows:

#MyNamespace.MyApp.Vehicle.Vehicle.dcm.yml
MyNamespace\MyApp\Vehicle\Vehicle:
    type: entity
    table: vehicle_table
    inheritanceType: JOINED
    discriminatorColumn:
        name: discriminator_column
        type: string
    discriminatorMap:
        vehicle: Vehicle
        groundVehicle: MyNamespace\MyApp\Vehicle\GroundVehicle\GroundVehicle
        airVehicle: MyNamespace\MyApp\Vehicle\AirVehicle\AirVehicle
    repositoryClass: Vehicle
    id:
        id:
            type: integer
            generator:
                strategy: AUTO
    fields:
        grandParentItem1:
            type: string
        grandParentItem2:
            type: string

#MyNamespace.MyApp.Vehicle.AirVehicle.AirVehicle.dcm.yml
MyNamespace\MyApp\Vehicle\AirVehicle\AirVehicle:
    type: entity
    table: air_vehicle
    extends: MyNamespace\MyApp\Vehicle\Vehicle
    inheritanceType: JOINED
    discriminatorMap:
        airVehicle: AirVehicle
        airplane: MyNamespace\MyApp\Vehicle\AirVehicle\Airplane\Airplane
        rocket: MyNamespace\MyApp\Vehicle\AirVehicle\Rocket\Rocket
    repositoryClass: AirVehicle
    id:
        id:
            associationKey: true
    fields:
        parentItem1:
            type: string
        parentItem2:
            type: string

#MyNamespace.MyApp.Vehicle.AirVehicle.Rocket.Rocket.dcm.yml
MyNamespace\MyApp\Vehicle\AirVehicle\Rocket\Rocket:
    extends: MyNamespace\MyApp\Vehicle\AirVehicle\AirVehicle
    type: entity
    table: rocket_table
    id:
        id:
            associationKey: true
    repositoryClass: Rocket
    fields:
        childItem1:
            type: string
        childItem2:
            type: string

I haven't shown GroundVehicle or Train, Car, and Airplane, but they are almost identical to AirVehicle and Rocket, respectively.

I've discovered that the barebone entities need to be manually created prior to using orm:generate-entities else I get class not found errors, and have created them as shown below.
        
inheritance_src/MyNamespace/MyApp/Vehicle/Vehicle.php
    inheritance_src/MyNamespace/MyApp/Vehicle/AirVehicle/AirVehicle.php
        inheritance_src/MyNamespace/MyApp/Vehicle/AirVehicle/Airplane/Airplane.php
        inheritance_src/MyNamespace/MyApp/Vehicle/AirVehicle/Rocket/Rocket.php
    inheritance_src/MyNamespace/MyApp/Vehicle/GroundVehicle/GroundVehicle.php
        inheritance_src/MyNamespace/MyApp/Vehicle/GroundVehicle/Car/Car.php
        inheritance_src/MyNamespace/MyApp/Vehicle/GroundVehicle/Train/Train.php

[michael@devserver doctrine]$ find inheritance_src -name "*.php" -exec cat {} \;
<?php
namespace MyNamespace\MyApp\Vehicle\AirVehicle\Airplane;
class Airplane extends \MyNamespace\MyApp\Vehicle\AirVehicle\AirVehicle{}
<?php
namespace MyNamespace\MyApp\Vehicle\AirVehicle\Rocket;
class Rocket extends \MyNamespace\MyApp\Vehicle\AirVehicle\AirVehicle{}
<?php
namespace MyNamespace\MyApp\Vehicle\AirVehicle;
abstract class AirVehicle extends \MyNamespace\MyApp\Vehicle\Vehicle{}
<?php
namespace MyNamespace\MyApp\Vehicle\GroundVehicle\Car;
class Car extends \MyNamespace\MyApp\Vehicle\GroundVehicle\GroundVehicle{}
<?php
namespace MyNamespace\MyApp\Vehicle\GroundVehicle\Train;
class Train extends \MyNamespace\MyApp\Vehicle\GroundVehicle\GroundVehicle{}
<?php
namespace MyNamespace\MyApp\Vehicle\GroundVehicle;
abstract class GroundVehicle extends \MyNamespace\MyApp\Vehicle\Vehicle{}
<?php
namespace MyNamespace\MyApp\Vehicle;
abstract class Vehicle{}

I then am able to successfully create the entities using orm:generate-entities, schema using orm:schema-tool:create, and repositories using orm:generate-repositories.

Does everything seem correct?

A couple of issues which I have my doubts:

Locating the classes in inheritance_src/MyNamespace/MyApp instead of inheritance_src/MyApp.  I tried to do the later and modify my psr-4 autoloader to use "MyNamespace\\": "inheritance_src/", but could not get it working without first creating the entities, editing them to add the "abstract" and "extend" portions, and then moving them to one directory lower. Needing to manually create the barebone classes in the first place.  My meta-data definitions includes "extends: MyNamespace\MyApp\Vehicle\Vehicle", so I would thought it would not be necessary. Locate both the entities and repositories in the same folder.  For that matter, I will probably be locating my service in the same folder as well.  It seems that most frameworks will locate all the entities in one folder (with of course subdirectories), repositories in another, services in another, etc.  The way I am doing seems to be organized domain modules as described by https://mnapoli.fr/organizing-code-into-domain-modules/.  Any compelling reasons to do it one way or the other?

Thank you
 

Hoping to get some thoughts on how Doctrine array collections should be used when the position of the items in the collection must be controlled.

For instance, I have a Chart object which has various primitive properties as well as a series property which is an array collection.  Each member in the series collection is a Serie object which has various primitive properties as well as a data property which is an array collection.  Each member in the data collection is a Datum object which includes various primitive properties.  The following just refers to the series collection, however, will be doing the same with the data collection.

Chart will have methods to add a Serie to the end of the series collection, modify a Serie for a given position, delete a Serie for a given position, swap the position of two Serie, and retrieve all Serie(s) in their designated position order. 

To implement this, my thought is to include a integer position property in Serie, and when retrieving the results will just ORDER BY this column if using DQL or maybe will use Criteria to filter the results.  I am not, however, sure how to implement some of the other methods.

When adding a new Serie to the end of the collection, should I do something like:

class Chart
{
    public function addSerie(array $params):Chart {
        $serie=new Serie();
        $serie->setName($params['name']);
        $position=$this->series->count();
        $serie->setPosition($position);
        $this->addSeries($serie);
    }
}

Also, ArrayCollection has various methods such as offsetGet(), but how does the collection know what to be ordered by?  Maybe using something like the following? 

class Chart
{
    public function __construct() {
        $this->series->getIterator()->uasort(function ($first, $second) {
            return (int) $first->getPosition() > (int) $second->getPosition() ? 1 : -1;
        });
    }
}

    
Also, any general thoughts on this topic would be appreciated.

PS.  Originally, I was using the name "Series" instead of "Serie", but the lack of separate forms for singular and plural was messing with me.  Was thinking of using SeriesNode instead, but didn't want to need to follow this same naming convention for other items...

I am trying to class type inheritance with Doctrine.  Eventually, I will be defining things using XML, but all the examples are done using doctags.  I found the following and it seems to work.

<?php
use Doctrine\ORM\Mapping as ORM;

/**
 * Inventory entity
 *
 * @ORM\Entity(repositoryClass="Inventory")
 * @ORM\Table(name="inventory")
 * @ORM\InheritanceType("JOINED")
 * @ORM\DiscriminatorColumn(name="discriminator_column", type="string")
 * @ORM\DiscriminatorMap({"inventory" = "AbstractItem", "inventory_room" = "Room"})
 */
abstract class AbstractItem
{
    /**
     * @ORM\Id @ORM\Column(name="inventory_id") @ORM\GeneratedValue
     * @var int
     */
    protected $inventory_id;

    /**
     * @ORM\Column(type="string")
     * @var string
     */
    protected $category;

    /**
     * @ORM\Column(type="string")
     * @var string
     */
    protected $part_number;
 }


use Doctrine\ORM\Mapping as ORM;

/**
 * Inventory Room entity
 * @ORM\Entity
 * @ORM\Table(name="inventory_room")
 */
class Room extends AbstractItem
{
    /**
     * @ORM\Column(type="string")
     * @var string
     */
    protected $room_type;

    /**
     * @ORM\Column(type="string")
     * @var string
     */
    protected $rack_limit;

 

But then I convert it to XML or YAML, and I get a Entity class 'Room' used in the discriminator map of class 'AbstractItem' does not exist error when trying to build the classes.  I've also tried changing the type to mappedSuperclass, but no success.

Any ideas?

Also, what is the purpose of the DiscriminatorColumn?

Thanks

 

AbstractItem:
    type: entity
    table: inventory
    inheritanceType: JOINED
    discriminatorColumn:
        name: discriminator_column
        type: string
    discriminatorMap:
        inventory: AbstractItem
        inventory_room: Room
    repositoryClass: Inventory
    id:
        inventory_id:
            type: string
    fields:
        category:
            type: string
        part_number:
            type: string


Room:
    type: entity
    table: inventory_room
    fields:
        room_type:
            type: string
        rack_limit:
            type: string

 

<?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 https://www.doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
  <entity repository-class="Inventory" name="AbstractItem" table="inventory" inheritance-type="JOINED">
    <discriminator-column name="discriminator_column" type="string" length="255"/>
    <discriminator-map>
      <discriminator-mapping value="inventory" class="AbstractItem"/>
      <discriminator-mapping value="inventory_room" class="Room"/>
    </discriminator-map>
    <id name="inventory_id" type="string" column="inventory_id">
      <generator strategy="IDENTITY"/>
    </id>
    <field name="category" type="string" column="category" precision="0" scale="0" nullable="false"/>
    <field name="part_number" type="string" column="part_number" precision="0" scale="0" nullable="false"/>
  </entity>
</doctrine-mapping>


<?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 https://www.doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
  <entity name="Room" table="inventory_room">
    <id name="inventory_id" type="string" column="inventory_id">
      <generator strategy="IDENTITY"/>
    </id>
    <field name="room_type" type="string" column="room_type" precision="0" scale="0" nullable="false"/>
    <field name="rack_limit" type="string" column="rack_limit" precision="0" scale="0" nullable="false"/>
    <field name="category" type="string" column="category" precision="0" scale="0" nullable="false"/>
    <field name="part_number" type="string" column="part_number" precision="0" scale="0" nullable="false"/>
  </entity>
</doctrine-mapping>

 

Trying to create a model where Parent1 and Parent2 extend Grandparent, and Child1_1 and Child1_2 extend Parent1 as well as Child2_1 and Child2_2 extend Parent2.

I set up my definitions:

Grandparent:
    type: entity
    table: grandparent_table
    inheritanceType: JOINED
    discriminatorColumn:
        name: discriminator_column_grandparent
        type: string
    repositoryClass: GrandParent
    id:
        id:
            type: integer
            generator:
                strategy: AUTO
    fields:
        GrandParent_Item1:
            type: string
        GrandParent_Item2:
            type: string
Parent1:
    type: entity
    table: parent_table1
    extends: Grandparent
    inheritanceType: JOINED
    discriminatorColumn:
        name: discriminator_column_parent1
        type: string
    id:
        id:
            associationKey: true
    fields:
        Parent1_Item1:
            type: string
        Parent1_Item2:
            type: string
Parent2:
    type: entity
    table: parent_table2
    extends: Grandparent
    inheritanceType: JOINED
    discriminatorColumn:
        name: discriminator_column_parent2
        type: string
    id:
        id:
            associationKey: true
    fields:
        Parent2_Item1:
            type: string
        Parent2_Item2:
            type: string
Child1_1:
    extends: Parent1
    type: entity
    table: child1_1_table
    id:
        id:
            associationKey: true
    fields:
        Child1_1_Item1:
            type: string
        Child1_1_Item2:
            type: string
Child1_2:
    extends: Parent1
    type: entity
    table: child1_2_table
    id:
        id:
            associationKey: true
    fields:
        Child1_2_Item1:
            type: string
        Child1_2_Item2:
            type: string
Child2_1:
    extends: Parent2
    type: entity
    table: child2_1_table
    id:
        id:
            associationKey: true
    fields:
        Child2_1_Item1:
            type: string
        Child2_1_Item2:
            type: string
Child2_2:
    extends: Parent2
    type: entity
    table: child2_2_table
    id:
        id:
            associationKey: true
    fields:
        Child2_2_Item1:
            type: string
        Child2_2_Item2:
            type: string

 And then generate my entities:       

$ vendor/bin/doctrine orm:generate-entities -vvv src

 Processing entity "Child1_1"
 Processing entity "Child1_2"
 Processing entity "Child2_1"
 Processing entity "Child2_2"
 Processing entity "Grandparent"
 Processing entity "Parent1"
 Processing entity "Parent2"


 [OK] Entity classes generated to "/var/www/doctrine/src"

Note that I needed to manually edit the Parent1 and 2 classes to extend Grandparent as well as the individual Child classes to extend their applicable Parent.

Next, I create the schema:

$ vendor/bin/doctrine orm:schema-tool:create --dump-sql

 The following SQL statements will be executed:

     CREATE TABLE child1_1_table (id INT NOT NULL, Child1_1_Item1 VARCHAR(255) NOT NULL, Child1_1_Item2 VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE child1_2_table (id INT NOT NULL, Child1_2_Item1 VARCHAR(255) NOT NULL, Child1_2_Item2 VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE child2_1_table (id INT NOT NULL, Child2_1_Item1 VARCHAR(255) NOT NULL, Child2_1_Item2 VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE child2_2_table (id INT NOT NULL, Child2_2_Item1 VARCHAR(255) NOT NULL, Child2_2_Item2 VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE grandparent_table (id INT AUTO_INCREMENT NOT NULL, GrandParent_Item1 VARCHAR(255) NOT NULL, GrandParent_Item2 VARCHAR(255) NOT NULL, discriminator_column_grandparent VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE parent_table1 (id INT NOT NULL, Parent1_Item1 VARCHAR(255) NOT NULL, Parent1_Item2 VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     CREATE TABLE parent_table2 (id INT NOT NULL, Parent2_Item1 VARCHAR(255) NOT NULL, Parent2_Item2 VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB;
     ALTER TABLE child1_1_table ADD CONSTRAINT FK_3445750EBF396750 FOREIGN KEY (id) REFERENCES grandparent_table (id) ON DELETE CASCADE;
     ALTER TABLE child1_2_table ADD CONSTRAINT FK_5AD6F93BF396750 FOREIGN KEY (id) REFERENCES grandparent_table (id) ON DELETE CASCADE;
     ALTER TABLE child2_1_table ADD CONSTRAINT FK_DC849CBBF396750 FOREIGN KEY (id) REFERENCES grandparent_table (id) ON DELETE CASCADE;
     ALTER TABLE child2_2_table ADD CONSTRAINT FK_3C205356BF396750 FOREIGN KEY (id) REFERENCES grandparent_table (id) ON DELETE CASCADE;
     ALTER TABLE parent_table1 ADD CONSTRAINT FK_5386E15BBF396750 FOREIGN KEY (id) REFERENCES grandparent_table (id) ON DELETE CASCADE;
     ALTER TABLE parent_table2 ADD CONSTRAINT FK_CA8FB0E1BF396750 FOREIGN KEY (id) REFERENCES grandparent_table (id) ON DELETE CASCADE;

I see how Grandparent has discriminatorColumn discriminator_column_grandparent as expected.

But why doesn't Parent1 and Parent2 have discriminatorColumn's discriminator_column_parent1 and discriminator_column_parent2?

Note that I've also tried making Grandparent, Parent1, and Parent2 abstract but get the same results.  I've also messed around with Mapped Superclasses, but I don't think they are applicable for my use (correct me if you think I am wrong).

Thanks!