public function testDelete()
{
$s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
$s->delete()->orderBy('id')->limit(1);
$this->assertEquals('DELETE FROM "users" ORDER BY "id" ASC LIMIT 1', $s->render(true));
}
/**
* Method to delete a value in cache.
*
* @param string $id
* @return void
*/
public function remove($id)
{
$this->sqlite->delete()->where()->equalTo('id', $this->sqlite->adapter()->escape(sha1($id)));
$this->sqlite->adapter()->query($this->sqlite->render(true));
}
