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

Exemple #1

Fichier : MinusWriterTest.php Projet : rudisimo/php-sql-query-builder

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

Exemple #2

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

 /**
  * @test
  */
 public function itShouldCreateMinusObject()
 {
     $className = '\\NilPortugues\\Sql\\QueryBuilder\\Manipulation\\Minus';
     $this->assertInstanceOf($className, $this->writer->minus(new Select('table1'), new Select('table2')));
 }