Ejemplo n.º 1
0
 public function testMergeWithWiths()
 {
     $c1 = new ModelCriteria('bookstore', 'Book', 'b');
     $c1->leftJoinWith('b.Author a');
     $c2 = new ModelCriteria('bookstore', 'Author');
     $c1->mergeWith($c2);
     $with = $c1->getWith();
     $this->assertEquals(1, count($with), 'mergeWith() does not remove an existing join');
     $this->assertEquals('modelName: Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() does not remove an existing join');
     $c1 = new ModelCriteria('bookstore', 'Book', 'b');
     $c2 = new ModelCriteria('bookstore', 'Book', 'b');
     $c2->leftJoinWith('b.Author a');
     $c1->mergeWith($c2);
     $with = $c1->getWith();
     $this->assertEquals(1, count($with), 'mergeWith() merge joins to an empty join');
     $this->assertEquals('modelName: Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() merge joins to an empty join');
     $c1 = new ModelCriteria('bookstore', 'Book', 'b');
     $c1->leftJoinWith('b.Author a');
     $c2 = new ModelCriteria('bookstore', 'Book', 'b');
     $c2->innerJoinWith('b.Publisher p');
     $c1->mergeWith($c2);
     $with = $c1->getWith();
     $this->assertEquals(2, count($with), 'mergeWith() merge joins to an existing join');
     $this->assertEquals('modelName: Author, relationName: Author, relationMethod: setAuthor, leftPhpName: , rightPhpName: a', $with['a']->__toString(), 'mergeWith() merge joins to an empty join');
     $this->assertEquals('modelName: Publisher, relationName: Publisher, relationMethod: setPublisher, leftPhpName: , rightPhpName: p', $with['p']->__toString(), 'mergeWith() merge joins to an empty join');
 }
Ejemplo n.º 2
0
 public function testMergeWithWiths()
 {
     $c1 = new ModelCriteria('bookstore', 'Book', 'b');
     $c1->leftJoinWith('b.Author a');
     $c2 = new ModelCriteria('bookstore', 'Author');
     $c1->mergeWith($c2);
     $with = $c1->getWith();
     $this->assertEquals(1, count($with), 'mergeWith() does not remove an existing join');
     $this->assertEquals('LEFT JOIN : book.AUTHOR_ID=a.ID(ignoreCase not considered) tableMap: AuthorTableMap relationMap: Author previousJoin: null relationAlias: a', $with['a']->__toString(), 'mergeWith() does not remove an existing join');
     $c1 = new ModelCriteria('bookstore', 'Book', 'b');
     $c2 = new ModelCriteria('bookstore', 'Book', 'b');
     $c2->leftJoinWith('b.Author a');
     $c1->mergeWith($c2);
     $with = $c1->getWith();
     $this->assertEquals(1, count($with), 'mergeWith() merge joins to an empty join');
     $this->assertEquals('LEFT JOIN : book.AUTHOR_ID=a.ID(ignoreCase not considered) tableMap: AuthorTableMap relationMap: Author previousJoin: null relationAlias: a', $with['a']->__toString(), 'mergeWith() merge joins to an empty join');
     $c1 = new ModelCriteria('bookstore', 'Book', 'b');
     $c1->leftJoinWith('b.Author a');
     $c2 = new ModelCriteria('bookstore', 'Book', 'b');
     $c2->innerJoinWith('b.Publisher p');
     $c1->mergeWith($c2);
     $with = $c1->getWith();
     $this->assertEquals(2, count($with), 'mergeWith() merge joins to an existing join');
     $this->assertEquals('LEFT JOIN : book.AUTHOR_ID=a.ID(ignoreCase not considered) tableMap: AuthorTableMap relationMap: Author previousJoin: null relationAlias: a', $with['a']->__toString(), 'mergeWith() merge joins to an empty join');
     $this->assertEquals('INNER JOIN : book.PUBLISHER_ID=p.ID(ignoreCase not considered) tableMap: PublisherTableMap relationMap: Publisher previousJoin: null relationAlias: p', $with['p']->__toString(), 'mergeWith() merge joins to an empty join');
 }