/**
* Tests to ensure DELETE queries are built properly.
*/
public function testDeleteQuery()
{
$query = Query::delete()->from('mytable')->where('user_id > 3')->orderBy('user_id DESC')->limit(100);
$result = MysqlDriver::generateQuery($query->getOptions());
$this->assertEquals('
DELETE FROM mytable
WHERE user_id > 3
ORDER BY user_id DESC
LIMIT 100', $result);
}
/**
* Tests deleting data.
*/
public function testDelete()
{
$this->insertFakeData(5);
$result = Query::delete()->from('users')->where('user_id < {int:lt}')->replace(array('lt' => 3))->execute();
$this->assertTrue($result->success());
$this->assertEquals(2, $result->getAffectedRows());
}
/**
* Sets up the DeleteQuery instance.
*/
public function setUp()
{
$this->deleteQuery = Query::delete();
}
