public function testMergeWithJoins() { $c1 = new ModelCriteria('bookstore', 'Book', 'b'); $c1->leftJoin('b.Author a'); $c2 = new ModelCriteria('bookstore', 'Author'); $c1->mergeWith($c2); $joins = $c1->getJoins(); $this->assertEquals(1, count($joins), 'mergeWith() does not remove an existing join'); $this->assertEquals('LEFT JOIN author a ON (book.AUTHOR_ID=a.ID)', $joins['a']->toString(), 'mergeWith() does not remove an existing join'); $c1 = new ModelCriteria('bookstore', 'Book', 'b'); $c2 = new ModelCriteria('bookstore', 'Book', 'b'); $c2->leftJoin('b.Author a'); $c1->mergeWith($c2); $joins = $c1->getJoins(); $this->assertEquals(1, count($joins), 'mergeWith() merge joins to an empty join'); $this->assertEquals('LEFT JOIN author a ON (book.AUTHOR_ID=a.ID)', $joins['a']->toString(), 'mergeWith() merge joins to an empty join'); $c1 = new ModelCriteria('bookstore', 'Book', 'b'); $c1->leftJoin('b.Author a'); $c2 = new ModelCriteria('bookstore', 'Book', 'b'); $c2->innerJoin('b.Publisher p'); $c1->mergeWith($c2); $joins = $c1->getJoins(); $this->assertEquals(2, count($joins), 'mergeWith() merge joins to an existing join'); $this->assertEquals('LEFT JOIN author a ON (book.AUTHOR_ID=a.ID)', $joins['a']->toString(), 'mergeWith() merge joins to an empty join'); $this->assertEquals('INNER JOIN publisher p ON (book.PUBLISHER_ID=p.ID)', $joins['p']->toString(), 'mergeWith() merge joins to an empty join'); }