public function testDeleteCriteria()
{
$this->prepareDB(true);
$oDriver = DBDriver::get_instance('sqlite', array('filename' => dirname(__FILE__) . '/unittest.db'));
$mRes = Person::delete('Person')->where('lastName', 'Piochet')->exec($oDriver);
$mRes = Person::select('Person')->where('lastName', 'Piochet')->exec($oDriver);
$this->assertEquals(0, $mRes->numRows());
}
public function testDeleteMultiple()
{
$oDriver = DBDriver::get_instance('mongo');
// Clean up database
Person::delete('Person')->where('firstName', 'Jerome')->exec($oDriver);
$iCount = 10;
for ($i = 0; $i < $iCount; $i++) {
$oPerson = new Person();
$oPerson->firstName = 'Jerome';
$oPerson->lastName = 'Poichet';
$mRes = $oPerson->insert()->exec($oDriver);
}
$oRes = Person::select('Person')->where('firstName', 'Jerome')->exec($oDriver);
$this->assertEquals($iCount, $oRes->numRows());
Person::delete('Person')->where('firstName', 'Jerome')->exec($oDriver);
$oRes = Person::select('Person')->where('firstName', 'Jerome')->exec($oDriver);
$this->assertEquals(0, $oRes->numRows());
}
