Changeset 4425 for trunk/tests/Orm
- Timestamp:
- 05/24/08 20:37:02 (8 months ago)
- Location:
- trunk/tests/Orm/Query
- Files:
-
- 2 modified
-
IdentifierRecognitionTest.php (modified) (6 diffs)
-
LanguageRecognitionTest.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/tests/Orm/Query/IdentifierRecognitionTest.php
r4422 r4425 56 56 { 57 57 $query = new Doctrine_Query; 58 $query->setDql('SELECT u.* FROM CmsUser u INDEX BY name');58 $query->setDql('SELECT u.* FROM CmsUser u INDEX BY id'); 59 59 $parserResult = $query->parse(); 60 60 … … 65 65 $this->assertEquals(null, $decl['parent']); 66 66 $this->assertEquals(null, $decl['agg']); 67 $this->assertEquals(' name', $decl['map']);67 $this->assertEquals('id', $decl['map']); 68 68 } 69 69 … … 71 71 { 72 72 $query = new Doctrine_Query; 73 $query->setDql('SELECT u.* FROM CmsUser u INDEX BY nameLEFT JOIN u.phonenumbers p');73 $query->setDql('SELECT u.* FROM CmsUser u INDEX BY id LEFT JOIN u.phonenumbers p'); 74 74 $parserResult = $query->parse(); 75 75 … … 80 80 $this->assertEquals(null, $decl['parent']); 81 81 $this->assertEquals(null, $decl['agg']); 82 $this->assertEquals(' name', $decl['map']);82 $this->assertEquals('id', $decl['map']); 83 83 84 84 $decl = $parserResult->getQueryComponent('p'); … … 95 95 { 96 96 $query = new Doctrine_Query; 97 $query->setDql('SELECT u.* FROM CmsUser u INDEX BY nameLEFT JOIN u.articles a INNER JOIN u.phonenumbers pn INDEX BY phonenumber');97 $query->setDql('SELECT u.* FROM CmsUser u INDEX BY id LEFT JOIN u.articles a INNER JOIN u.phonenumbers pn INDEX BY phonenumber'); 98 98 $parserResult = $query->parse(); 99 99 … … 104 104 $this->assertEquals(null, $decl['parent']); 105 105 $this->assertEquals(null, $decl['agg']); 106 $this->assertEquals(' name', $decl['map']);106 $this->assertEquals('id', $decl['map']); 107 107 108 108 $decl = $parserResult->getQueryComponent('a'); -
trunk/tests/Orm/Query/LanguageRecognitionTest.php
r4422 r4425 223 223 $this->assertValidDql('SELECT u.name, a.topic, p.phonenumber FROM CmsUser u INNER JOIN u.articles a LEFT JOIN u.phonenumbers p'); 224 224 } 225 225 /* 226 226 public function testMixingOfJoins2() 227 227 { 228 228 $this->assertValidDql('SELECT u.name, u.articles.topic, c.text FROM CmsUser u INNER JOIN u.articles.comments c'); 229 229 } 230 230 */ 231 231 public function testOrderBySingleColumn() 232 232 { … … 288 288 public function testIndexByClauseWithOneComponent() 289 289 { 290 $this->assertValidDql('SELECT * FROM CmsUser u INDEX BY name');290 $this->assertValidDql('SELECT * FROM CmsUser u INDEX BY id'); 291 291 } 292 292 293 293 public function testIndexBySupportsJoins() 294 294 { 295 $this->assertValidDql('SELECT * FROM CmsUser u LEFT JOIN u.articles INDEX BY topic');295 $this->assertValidDql('SELECT * FROM CmsUser u LEFT JOIN u.articles INDEX BY id'); // INDEX BY is now referring to articles 296 296 } 297 297 298 298 public function testIndexBySupportsJoins2() 299 299 { 300 $this->assertValidDql('SELECT * FROM CmsUser u INDEX BY nameLEFT JOIN u.phonenumbers p INDEX BY phonenumber');300 $this->assertValidDql('SELECT * FROM CmsUser u INDEX BY id LEFT JOIN u.phonenumbers p INDEX BY phonenumber'); 301 301 } 302 302