/** * @test */ public function itShouldGetIntersectSelects() { $this->assertEquals(array(), $this->query->getIntersects()); $select1 = new Select('user'); $select2 = new Select('user_email'); $this->query->add($select1); $this->query->add($select2); $this->assertEquals(array($select1, $select2), $this->query->getIntersects()); }
/** * @test */ public function itShouldWriteIntersects() { $intersect = new Intersect(); $intersect->add(new Select('user')); $intersect->add(new Select('user_email')); $expected = <<<SQL SELECT user.* FROM user INTERSECT SELECT user_email.* FROM user_email SQL; $this->assertEquals($expected, $this->intersectWriter->write($intersect)); }