3 namespace Doctrine\Tests\ORM\Functional;
5 use Doctrine\ORM\UnitOfWork;
7 require_once __DIR__ . '/../../TestInit.php';
12 class OneToOneEagerLoadingTest extends \Doctrine\Tests\OrmFunctionalTestCase
14 protected function setUp()
17 $schemaTool = new \Doctrine\ORM\Tools\SchemaTool($this->_em);
19 $schemaTool->createSchema(array(
20 $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\Train'),
21 $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\TrainDriver'),
22 $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\TrainOwner'),
23 $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\Waggon'),
24 $this->_em->getClassMetadata('Doctrine\Tests\ORM\Functional\TrainOrder'),
26 } catch(\Exception $e) {}
29 public function testEagerLoadOneToOneOwningSide()
31 $train = new Train(new TrainOwner("Alexander"));
32 $driver = new TrainDriver("Benjamin");
33 $waggon = new Waggon();
35 $train->setDriver($driver);
36 $train->addWaggon($waggon);
38 $this->_em->persist($train); // cascades
42 $sqlCount = count($this->_sqlLoggerStack->queries);
44 $train = $this->_em->find(get_class($train), $train->id);
45 $this->assertNotInstanceOf('Doctrine\ORM\Proxy\Proxy', $train->driver);
46 $this->assertEquals("Benjamin", $train->driver->name);
48 $this->assertEquals($sqlCount + 1, count($this->_sqlLoggerStack->queries));
51 public function testEagerLoadOneToOneNullOwningSide()
53 $train = new Train(new TrainOwner("Alexander"));
55 $this->_em->persist($train); // cascades
59 $sqlCount = count($this->_sqlLoggerStack->queries);
61 $train = $this->_em->find(get_class($train), $train->id);
62 $this->assertNotInstanceOf('Doctrine\ORM\Proxy\Proxy', $train->driver);
63 $this->assertNull($train->driver);
65 $this->assertEquals($sqlCount + 1, count($this->_sqlLoggerStack->queries));
68 public function testEagerLoadOneToOneInverseSide()
70 $owner = new TrainOwner("Alexander");
71 $train = new Train($owner);
73 $this->_em->persist($train); // cascades
77 $sqlCount = count($this->_sqlLoggerStack->queries);
79 $driver = $this->_em->find(get_class($owner), $owner->id);
80 $this->assertNotInstanceOf('Doctrine\ORM\Proxy\Proxy', $owner->train);
81 $this->assertNotNull($owner->train);
83 $this->assertEquals($sqlCount + 1, count($this->_sqlLoggerStack->queries));
86 public function testEagerLoadOneToOneNullInverseSide()
88 $driver = new TrainDriver("Dagny Taggert");
90 $this->_em->persist($driver);
94 $this->assertNull($driver->train);
96 $sqlCount = count($this->_sqlLoggerStack->queries);
98 $driver = $this->_em->find(get_class($driver), $driver->id);
99 $this->assertNotInstanceOf('Doctrine\ORM\Proxy\Proxy', $driver->train);
100 $this->assertNull($driver->train);
102 $this->assertEquals($sqlCount + 1, count($this->_sqlLoggerStack->queries));
105 public function testEagerLoadManyToOne()
107 $train = new Train(new TrainOwner("Alexander"));
108 $waggon = new Waggon();
109 $train->addWaggon($waggon);
111 $this->_em->persist($train); // cascades
115 $waggon = $this->_em->find(get_class($waggon), $waggon->id);
116 $this->assertNotInstanceOf('Doctrine\ORM\Proxy\Proxy', $waggon->train);
117 $this->assertNotNull($waggon->train);
120 public function testEagerLoadWithNullableColumnsGeneratesLeftJoinOnBothSides()
122 $train = new Train(new TrainOwner("Alexander"));
123 $driver = new TrainDriver("Benjamin");
124 $train->setDriver($driver);
126 $this->_em->persist($train);
130 $train = $this->_em->find(get_class($train), $train->id);
132 "SELECT t0.id AS id1, t0.driver_id AS driver_id2, t3.id AS id4, t3.name AS name5, t0.owner_id AS owner_id6, t7.id AS id8, t7.name AS name9 FROM Train t0 LEFT JOIN TrainDriver t3 ON t0.driver_id = t3.id INNER JOIN TrainOwner t7 ON t0.owner_id = t7.id WHERE t0.id = ?",
133 $this->_sqlLoggerStack->queries[$this->_sqlLoggerStack->currentQuery]['sql']
137 $driver = $this->_em->find(get_class($driver), $driver->id);
139 "SELECT t0.id AS id1, t0.name AS name2, t3.id AS id4, t3.driver_id AS driver_id5, t3.owner_id AS owner_id6 FROM TrainOwner t0 LEFT JOIN Train t3 ON t3.owner_id = t0.id WHERE t0.id IN (?)",
140 $this->_sqlLoggerStack->queries[$this->_sqlLoggerStack->currentQuery]['sql']
144 public function testEagerLoadWithNonNullableColumnsGeneratesInnerJoinOnOwningSide()
146 $waggon = new Waggon();
148 // It should have a train
149 $train = new Train(new TrainOwner("Alexander"));
150 $train->addWaggon($waggon);
152 $this->_em->persist($train);
156 $waggon = $this->_em->find(get_class($waggon), $waggon->id);
158 // The last query is the eager loading of the owner of the train
160 "SELECT t0.id AS id1, t0.name AS name2, t3.id AS id4, t3.driver_id AS driver_id5, t3.owner_id AS owner_id6 FROM TrainOwner t0 LEFT JOIN Train t3 ON t3.owner_id = t0.id WHERE t0.id IN (?)",
161 $this->_sqlLoggerStack->queries[$this->_sqlLoggerStack->currentQuery]['sql']
164 // The one before is the fetching of the waggon and train
166 "SELECT t0.id AS id1, t0.train_id AS train_id2, t3.id AS id4, t3.driver_id AS driver_id5, t3.owner_id AS owner_id6 FROM Waggon t0 INNER JOIN Train t3 ON t0.train_id = t3.id WHERE t0.id = ?",
167 $this->_sqlLoggerStack->queries[$this->_sqlLoggerStack->currentQuery - 1]['sql']
171 public function testEagerLoadWithNonNullableColumnsGeneratesLeftJoinOnNonOwningSide()
173 $owner = new TrainOwner('Alexander');
174 $train = new Train($owner);
175 $this->_em->persist($train);
179 $waggon = $this->_em->find(get_class($owner), $owner->id);
181 "SELECT t0.id AS id1, t0.name AS name2, t3.id AS id4, t3.driver_id AS driver_id5, t3.owner_id AS owner_id6 FROM TrainOwner t0 LEFT JOIN Train t3 ON t3.owner_id = t0.id WHERE t0.id = ?",
182 $this->_sqlLoggerStack->queries[$this->_sqlLoggerStack->currentQuery]['sql']
189 public function testEagerLoadingDoesNotBreakRefresh()
191 $train = new Train(new TrainOwner('Johannes'));
192 $order = new TrainOrder($train);
193 $this->_em->persist($train);
194 $this->_em->persist($order);
197 $this->_em->getConnection()->exec("UPDATE TrainOrder SET train_id = NULL");
199 $this->assertSame($train, $order->train);
200 $this->_em->refresh($order);
201 $this->assertTrue($order->train === null, "Train reference was not refreshed to NULL.");
211 * @id @column(type="integer") @generatedValue
217 * @OneToOne(targetEntity="TrainDriver", inversedBy="train", fetch="EAGER", cascade={"persist"})
218 * @JoinColumn(nullable=true)
223 * @OneToOne(targetEntity="TrainOwner", inversedBy="train", fetch="EAGER", cascade={"persist"})
224 * @JoinColumn(nullable=false)
228 * @oneToMany(targetEntity="Waggon", mappedBy="train", cascade={"persist"})
232 public function __construct(TrainOwner $owner)
234 $this->waggons = new \Doctrine\Common\Collections\ArrayCollection();
235 $this->setOwner($owner);
238 public function setDriver(TrainDriver $driver)
240 $this->driver = $driver;
241 $driver->setTrain($this);
244 public function setOwner(TrainOwner $owner)
246 $this->owner = $owner;
247 $owner->setTrain($this);
250 public function addWaggon(Waggon $w)
253 $this->waggons[] = $w;
262 /** @Id @Column(type="integer") @GeneratedValue */
264 /** @column(type="string") */
268 * @OneToOne(targetEntity="Train", mappedBy="driver", fetch="EAGER")
272 public function __construct($name)
277 public function setTrain(Train $t)
288 /** @Id @Column(type="integer") @GeneratedValue */
290 /** @column(type="string") */
294 * @OneToOne(targetEntity="Train", mappedBy="owner", fetch="EAGER")
298 public function __construct($name)
303 public function setTrain(Train $t)
314 /** @id @generatedValue @column(type="integer") */
317 * @ManyToOne(targetEntity="Train", inversedBy="waggons", fetch="EAGER")
318 * @JoinColumn(nullable=false)
322 public function setTrain($train)
324 $this->train = $train;
333 /** @id @generatedValue @column(type="integer") */
336 /** @OneToOne(targetEntity = "Train", fetch = "EAGER") */
339 public function __construct(Train $train)
341 $this->train = $train;