filehashSQLite (version 0.2-7)

filehashSQLite-class: Class "filehashSQLite"

Description

Create a 'filehash' database using SQLite as the backend

Objects from the Class

Objects can be created by calls of the form new("filehashSQLite", ...). More likely, one will use the functions dbCreate and dbInit from the filehash package.

Slots

datafile

character, full path to the file in which the database should be stored

dbcon

Object of class “SQLiteConnection”, a SQLite connection

drv

‘SQLite’ driver

name

character, the name of the database

Extends

Class "filehash", directly.

Methods

dbDelete

signature(db = "filehashSQLite", key = "character"): delete a key-value pair from the database

dbExists

signature(db = "filehashSQLite", key = "character"): check the existence of a specific key or vector of keys

dbFetch

signature(db = "filehashSQLite", key = "character"): retrieve the value associated with a specific key

dbInsert

signature(db = "filehashSQLite", key = "character"): insert a key-value pair

dbList

signature(db = "filehashSQLite"): return character vector of keys currently stored in the database

dbUnlink

signature(db = "filehashSQLite"): delete the entire database

dbMultiFetch

signature(db = "filehashSQLite", key = "character"): return (as a named list) the values associated with a vector of keys

Author

Roger D. Peng

Details

The “filehashSQLite” class represents a “filehash” key-value database using the SQLite DBM as the backend. Objects are stored in a single SQLite database table along with their keys.

Examples

library(filehashSQLite)

dbCreate("myTestDB", type = "SQLite")
db <- dbInit("myTestDB", type = "SQLite")

set.seed(100)
db$a <- rnorm(100)
db$b <- "a character element"

with(db, mean(a))

cat(db$b, "\n")

dbUnlink(db)