## SQLiteDriver-related
sqliteInitDriver(max.con=10, fetch.default.rec = 500, force.reload=FALSE)
sqliteDriverInfo(obj, what)
sqliteDescribeDriver(obj, verbose = FALSE, ...)
sqliteCloseDriver(drv, ...) ## SQLiteConnection-related
sqliteNewConnection(drv, dbname, mode = 0)
sqliteCloneConnection(drv, ...)
sqliteConnectionInfo(obj, what)
sqliteDescribeConnection(obj, verbose = FALSE, ...)
sqliteCloseConnection(con, ..., force = FALSE)
## SQLiteResult-related
sqliteExecStatement(con, statement)
sqliteFetch(res, n=0, ...)
sqliteQuickSQL(con, statement, ...)
sqliteResultInfo(obj, what)
sqliteDescribeResult(obj, verbose = FALSE, ...)
sqliteCloseResult(res, ...)
## data mappings and convenience functions
sqliteDataType(obj, ...)
sqliteReadTable(con, name, row.names = "row.names", check.names = TRUE, ...)
sqliteWriteTable(con, name, value, field.types, row.names = TRUE,
overwrite=FALSE, append=FALSE, ...)
sqliteTableFields(con, name, ...)
sqliteFetch
.
The default is 500.fetch.default.rec
).
Note that the driver is a singleton (subsequent inits just returned the
previously initialized SQLiteConnection
,
SQLiteResult
).FALSE
.SQLiteDriver
object as produced by sqliteInit
.SQLiteConnection
object as produced by sqliteNewConnection
and sqliteCloneConnection
.SQLiteResult
object as produced by by sqliteExecStatement
.FALSE
.fetch.default.rec
was specified
during driver initialization sqliteInit
value
to SQL data types. The default is
sapply(value,SQLDataType)
, see SQLiteSQLType
.value
data.frame
row names or not. The default is TRUE
.TRUE
.name
with
the contents of the data.frame value
.
The defauls is FALSE
.value
to the existing
table name
.sqliteInitDriver
returns an SQLiteDriver
object. sqliteDriverInfo
returns a list of name-value metadata pairs.
sqliteDescribeDriver
returns NULL
(displays the object's
metadata).
sqliteCloseDriver
returns a logical indicating whether the
operation succeeded or not.
sqliteNewConnection
returns an SQLiteConnection
object.
sqliteCloneConnection
returns an SQLiteConnection
object.
sqliteConnectionInfo
returns a list of name-value metadata pairs.
sqliteDescribeConnection
returns NULL
(displays the
object's metadata).
sqliteCloseConnection
returns a logical indicating whether the
operation succeeded or not.
sqliteExecStatement
returns an SQLiteResult
object.
sqliteFetch
returns a data.frame.
sqliteQuickSQL
returns either a data.frame if the statement
is
a select
-like or NULL otherwise.
sqliteDescribeResult
returns NULL
(displays the object's
metadata).
sqliteCloseResult
returns a logical indicating whether the
operation succeeded or not.
sqliteReadTable
returns a data.frame with the contents of the
DBMS table.
sqliteWriteTable
returns a logical indicating whether the
operation succeeded or not.
sqliteTableFields
returns a character vector with the
table name
field names.
sqliteDataType
retuns a character string with the closest
SQL data type. Note that SQLite is typeless, so this is mostly for
creating table that are compatible across RDBMS.
sqliteResultInfo
returns a list of name-value metadata pairs.
.SQLitePkgName
(currently "RSQLite"
),
.SQLitePkgVersion
(the R package version),
.SQLitePkgRCS
(the RCS revision),
.SQLitecle.NA.string
(character that SQLite uses to
denote NULL
on input),.conflicts.OK
.