Esempi in PHP per Oops_Sql_Selector::resetWhere

Esempio n. 1

File: Oops_Sql_SelectorTest.php Progetto: laiello/oops-project

 /**
  * Tests Oops_Sql_Selector->where()
  */
 public function testWhere()
 {
     // TODO Auto-generated Oops_Sql_SelectorTest->testWhere()
     //$this->markTestIncomplete("where test not implemented");
     $this->Oops_Sql_Selector->resetAll();
     $this->Oops_Sql_Selector->where('testField2', Oops_Sql_Selector::CMP_GE, 88.2);
     $expected = "SELECT COUNT(*) FROM `testDatabase`.`testTable` WHERE `testField2` >= '88.2'";
     $this->assertEquals($expected, $this->Oops_Sql_Selector->count(true));
     $this->Oops_Sql_Selector->where('testField3', Oops_Sql_Selector::CMP_LT, 5);
     $expected = "SELECT COUNT(*) FROM `testDatabase`.`testTable` WHERE `testField2` >= '88.2' AND `testField3` < 5";
     $this->assertEquals($expected, $this->Oops_Sql_Selector->count(true));
     $this->Oops_Sql_Selector->resetWhere();
     $this->Oops_Sql_Selector->where('testField3', Oops_Sql_Selector::CMP_LT, 5);
     $expected = "SELECT COUNT(*) FROM `testDatabase`.`testTable` WHERE `testField3` < 5";
     $this->assertEquals($expected, $this->Oops_Sql_Selector->count(true));
 }