Rajout de doctrine/orm

[zf2.biz/application_blanche.git] / vendor / doctrine / orm / tests / Doctrine / Tests / ORM / Functional / OrderedCollectionTest.php

diff --git a/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Functional/OrderedCollectionTest.php b/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Functional/OrderedCollectionTest.php
new file mode 100644 (file)
index 0000000..c2e131c
--- /dev/null
+++ b/vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Functional/OrderedCollectionTest.php
@@ -0,0 +1,113 @@
+<?php
+
+namespace Doctrine\Tests\ORM\Functional;
+
+use Doctrine\Tests\Models\Routing\RoutingRoute;
+use Doctrine\Tests\Models\Routing\RoutingLocation;
+use Doctrine\Tests\Models\Routing\RoutingLeg;
+use Doctrine\Tests\Models\Routing\RoutingRouteBooking;
+
+require_once __DIR__ . '/../../TestInit.php';
+
+class OrderedCollectionTest extends \Doctrine\Tests\OrmFunctionalTestCase
+{
+    protected $locations = array();
+
+    public function setUp()
+    {
+        $this->useModelSet('routing');
+        parent::setUp();
+
+        $locations = array("Berlin", "Bonn", "Brasilia", "Atlanta");
+
+        foreach ($locations AS $locationName) {
+            $location = new RoutingLocation();
+            $location->name = $locationName;
+            $this->_em->persist($location);
+            $this->locations[$locationName] = $location;
+        }
+        $this->_em->flush();
+    }
+
+    public function createPersistedRouteWithLegs()
+    {
+        $route = new RoutingRoute();
+
+        $leg1 = new RoutingLeg();
+        $leg1->fromLocation = $this->locations['Berlin'];
+        $leg1->toLocation   = $this->locations['Bonn'];
+        $leg1->departureDate = new \DateTime("now");
+        $leg1->arrivalDate = new \DateTime("now +5 hours");
+
+        $leg2 = new RoutingLeg();
+        $leg2->fromLocation = $this->locations['Bonn'];
+        $leg2->toLocation   = $this->locations['Brasilia'];
+        $leg2->departureDate = new \DateTime("now +6 hours");
+        $leg2->arrivalDate = new \DateTime("now +24 hours");
+
+        $route->legs[] = $leg2;
+        $route->legs[] = $leg1;
+
+        $this->_em->persist($route);
+        $this->_em->flush();
+        $routeId = $route->id;
+        $this->_em->clear();
+
+        return $routeId;
+    }
+
+    public function testLazyManyToManyCollection_IsRetrievedWithOrderByClause()
+    {
+        $routeId = $this->createPersistedRouteWithLegs();
+
+        $route = $this->_em->find('Doctrine\Tests\Models\Routing\RoutingRoute', $routeId);
+
+        $this->assertEquals(2, count($route->legs));
+        $this->assertEquals("Berlin", $route->legs[0]->fromLocation->getName());
+        $this->assertEquals("Bonn", $route->legs[1]->fromLocation->getName());
+    }
+
+    public function testLazyOneToManyCollection_IsRetrievedWithOrderByClause()
+    {
+        $route = new RoutingRoute();
+
+        $this->_em->persist($route);
+        $this->_em->flush();
+        $routeId = $route->id;
+
+        $booking1 = new RoutingRouteBooking();
+        $booking1->passengerName = "Guilherme";
+        $booking2 = new RoutingRouteBooking();
+        $booking2->passengerName = "Benjamin";
+
+        $route->bookings[] = $booking1;
+        $booking1->route = $route;
+        $route->bookings[] = $booking2;
+        $booking2->route = $route;
+
+        $this->_em->persist($booking1);
+        $this->_em->persist($booking2);
+
+        $this->_em->flush();
+        $this->_em->clear();
+
+        $route = $this->_em->find('Doctrine\Tests\Models\Routing\RoutingRoute', $routeId);
+
+        $this->assertEquals(2, count($route->bookings));
+        $this->assertEquals('Benjamin', $route->bookings[0]->getPassengerName());
+        $this->assertEquals('Guilherme', $route->bookings[1]->getPassengerName());
+    }
+
+    public function testOrderedResultFromDqlQuery()
+    {
+        $routeId = $this->createPersistedRouteWithLegs();
+
+        $route = $this->_em->createQuery("SELECT r, l FROM Doctrine\Tests\Models\Routing\RoutingRoute r JOIN r.legs l WHERE r.id = ?1")
+                           ->setParameter(1, $routeId)
+                           ->getSingleResult();
+
+        $this->assertEquals(2, count($route->legs));
+        $this->assertEquals("Berlin", $route->legs[0]->fromLocation->getName());
+        $this->assertEquals("Bonn", $route->legs[1]->fromLocation->getName());
+    }
+}
\ No newline at end of file