PHP NilPortugues\Sql\QueryBuilder\Builder GenericBuilder::unionAll 예제들

예제 #1

파일: UnionAllWriterTest.php 프로젝트: masnathan/sql-query-builder

    /**
     * @test
     */
    public function itShouldWriteUnionAllFromGenericBuilder()
    {
        $unionAll = $this->writer->unionAll();
        $unionAll->add(new Select('user'));
        $unionAll->add(new Select('user_email'));
        $expected = <<<SQL
SELECT user.* FROM user
UNION ALL
SELECT user_email.* FROM user_email
SQL;
        $this->assertEquals($expected, $this->writer->write($unionAll));
    }

예제 #2

파일: GenericBuilderTest.php 프로젝트: svgaman/sql-query-builder

 /**
  * @test
  */
 public function itShouldCreateUnionAllObject()
 {
     $className = '\\NilPortugues\\Sql\\QueryBuilder\\Manipulation\\UnionAll';
     $this->assertInstanceOf($className, $this->writer->unionAll());
 }