PHP KVDdb_Criterion::notMatches Exemples

Exemple #1

Fichier : KVDdb_CriterionTest.php Projet : Tjoosten/kvd

 public function testNotMatch()
 {
     $criterion = KVDdb_Criterion::notMatches('provincie', 'West-Vlaanderen');
     $this->assertInstanceOf('KVDdb_NotMatchCriterion', $criterion);
     $this->assertEquals("( UPPER( provincie ) NOT LIKE UPPER( 'West-Vlaanderen' ) )", $criterion->generateSql());
     $criterion = KVDdb_Criterion::notMatches('provincie', '%West-Vlaanderen');
     $this->assertInstanceOf('KVDdb_NotMatchCriterion', $criterion);
     $this->assertEquals("( UPPER( provincie ) NOT LIKE UPPER( '%West-Vlaanderen' ) )", $criterion->generateSql());
     $criterion = KVDdb_Criterion::notMatches('provincie', '__st-Vlaanderen');
     $this->assertInstanceOf('KVDdb_NotMatchCriterion', $criterion);
     $this->assertEquals("( UPPER( provincie ) NOT LIKE UPPER( '__st-Vlaanderen' ) )", $criterion->generateSql());
 }