PHP NilPortugues\Sql\QueryBuilder\Builder GenericBuilder::unionAll Exemples

Exemple #1

Fichier : UnionAllWriterTest.php Projet : 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));
    }

Exemple #2

Fichier : GenericBuilderTest.php Projet : svgaman/sql-query-builder

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