/** * @test */ public function itShouldWriteIntersectFromGenericBuilder() { $intersect = $this->writer->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->writer->write($intersect)); }
/** * @test */ public function itShouldCreateIntersectObject() { $className = '\\NilPortugues\\Sql\\QueryBuilder\\Manipulation\\Intersect'; $this->assertInstanceOf($className, $this->writer->intersect()); }