PHP KVDdb_Criterion::notIn Exemples

Exemple #1

Fichier : KVDdb_CriterionTest.php Projet : Tjoosten/kvd

 public function testNotIn()
 {
     $criterion = KVDdb_Criterion::notIn('gemeente_id', array(40000, 40001, 40002));
     $this->assertInstanceOf('KVDdb_Criterion', $criterion);
     $this->assertEquals("( gemeente_id NOT IN ( 40000, 40001, 40002 ) )", $criterion->generateSql());
     $criterion = KVDdb_Criterion::notIn('gemeente', array('Knokke-Heist', 'Brugge', 'Dudzele'));
     $this->assertEquals("( gemeente NOT IN ( 'Knokke-Heist', 'Brugge', 'Dudzele' ) )", $criterion->generateSql());
 }