/** * 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(); }