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)); }