X-Git-Url: http://git.inspyration.org/?a=blobdiff_plain;f=vendor%2Fdoctrine%2Form%2Ftests%2FDoctrine%2FTests%2FORM%2FFunctional%2FOrderedJoinedTableInheritanceCollectionTest.php;fp=vendor%2Fdoctrine%2Form%2Ftests%2FDoctrine%2FTests%2FORM%2FFunctional%2FOrderedJoinedTableInheritanceCollectionTest.php;h=8c0d37b98f69cfa365bdb0169beee6776b0ae7ca;hb=8b04b2d11798dee4f3e1358e4f43e97a6df851f6;hp=0000000000000000000000000000000000000000;hpb=73568cf05a785a45f94ca3f2351d9e07bf917958;p=zf2.biz%2Fapplication_blanche.git

diff --git a/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Functional/OrderedJoinedTableInheritanceCollectionTest.php b/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Functional/OrderedJoinedTableInheritanceCollectionTest.php
new file mode 100644
index 0000000..8c0d37b
--- /dev/null
+++ b/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Functional/OrderedJoinedTableInheritanceCollectionTest.php
@@ -0,0 +1,133 @@
+<?php
+
+namespace Doctrine\Tests\ORM\Functional;
+
+use Doctrine\ORM\Query;
+
+require_once __DIR__ . '/../../TestInit.php';
+
+/**
+ * Functional tests for the Single Table Inheritance mapping strategy.
+ *
+ * @author Benjamin Eberlei <kontakt@beberlei.de>
+ */
+class OrderedJoinedTableInheritanceCollectionTest extends \Doctrine\Tests\OrmFunctionalTestCase
+{
+    protected function setUp() {
+        parent::setUp();
+        try {
+            $this->_schemaTool->createSchema(array(
+                $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\OJTIC_Pet'),
+                $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\OJTIC_Cat'),
+                $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\OJTIC_Dog'),
+            ));
+        } catch (\Exception $e) {
+            // Swallow all exceptions. We do not test the schema tool here.
+        }
+
+        $dog = new OJTIC_Dog();
+        $dog->name = "Poofy";
+
+        $dog1 = new OJTIC_Dog();
+        $dog1->name = "Zampa";
+        $dog2 = new OJTIC_Dog();
+        $dog2->name = "Aari";
+
+        $dog1->mother = $dog;
+        $dog2->mother = $dog;
+
+        $dog->children[] = $dog1;
+        $dog->children[] = $dog2;
+
+        $this->_em->persist($dog);
+        $this->_em->persist($dog1);
+        $this->_em->persist($dog2);
+        $this->_em->flush();
+        $this->_em->clear();
+    }
+
+    public function testOrderdOneToManyCollection()
+    {
+        $poofy = $this->_em->createQuery("SELECT p FROM Doctrine\Tests\ORM\Functional\OJTIC_Pet p WHERE p.name = 'Poofy'")->getSingleResult();
+
+        $this->assertEquals('Aari', $poofy->children[0]->getName());
+        $this->assertEquals('Zampa', $poofy->children[1]->getName());
+
+        $this->_em->clear();
+
+        $result = $this->_em->createQuery(
+            "SELECT p, c FROM Doctrine\Tests\ORM\Functional\OJTIC_Pet p JOIN p.children c WHERE p.name = 'Poofy'")
+                ->getResult();
+
+        $this->assertEquals(1, count($result));
+        $poofy = $result[0];
+
+        $this->assertEquals('Aari', $poofy->children[0]->getName());
+        $this->assertEquals('Zampa', $poofy->children[1]->getName());
+    }
+}
+
+/**
+ * @Entity
+ * @InheritanceType("JOINED")
+ * @DiscriminatorColumn(name="discr", type="string")
+ * @DiscriminatorMap({
+ *      "cat" = "OJTIC_Cat",
+ *      "dog" = "OJTIC_Dog"})
+ */
+abstract class OJTIC_Pet
+{
+    /**
+     * @Id
+     * @column(type="integer")
+     * @generatedValue(strategy="AUTO")
+     */
+    public $id;
+
+    /**
+     *
+     * @Column
+     */
+    public $name;
+
+    /**
+     * @ManyToOne(targetEntity="OJTIC_PET")
+     */
+    public $mother;
+
+    /**
+     * @OneToMany(targetEntity="OJTIC_Pet", mappedBy="mother")
+     * @OrderBy({"name" = "ASC"})
+     */
+    public $children;
+
+    /**
+     * @ManyToMany(targetEntity="OJTIC_Pet")
+     * @JoinTable(name="OTJIC_Pet_Friends",
+     *     joinColumns={@JoinColumn(name="pet_id", referencedColumnName="id")},
+     *     inverseJoinColumns={@JoinColumn(name="friend_id", referencedColumnName="id")})
+     * @OrderBy({"name" = "ASC"})
+     */
+    public $friends;
+
+    public function getName()
+    {
+        return $this->name;
+    }
+}
+
+/**
+ * @Entity
+ */
+class OJTIC_Cat extends OJTIC_Pet
+{
+
+}
+
+/**
+ * @Entity
+ */
+class OJTIC_Dog extends OJTIC_Pet
+{
+
+}
\ No newline at end of file