## SQLiteDriver-related
sqliteInitDriver(max.con=16, fetch.default.rec = 500, force.reload=FALSE,
shared.cache=FALSE)
sqliteDriverInfo(obj, what, ...)
sqliteDescribeDriver(obj, verbose = FALSE, ...)
sqliteCloseDriver(drv, ...) ## SQLiteConnection-related
sqliteNewConnection(drv, dbname, loadable.extensions=FALSE, cache_size=NULL,
synchronous=0, flags = NULL, vfs = NULL)
sqliteConnectionInfo(obj, what, ...)
sqliteDescribeConnection(obj, verbose = FALSE, ...)
sqliteCloseConnection(con, ...)
## SQLiteResult-related
sqliteExecStatement(con, statement, bind.data=NULL)
sqliteTransactionStatement(con, statement)
sqliteFetch(res, n=0, ...)
sqliteQuickSQL(con, statement, bind.data=NULL, ...)
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, ...)
sqliteImportFile(con, name, value, field.types, overwrite=FALSE,
append=FALSE, header, row.names, nrows=50, sep=",", eol="
",
skip = 0, ...)
sqliteWriteTable(con, name, value, row.names = TRUE,
overwrite = FALSE, append = FALSE,
field.types = NULL, ...)
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
.SQLiteResult
object as produced by by sqliteExecStatement
.NULL
, the flags will default to
SQLITE_RWC
which will open the file in read/write mode and
create the file if it does not exist. You cPRAGMA cache_size
; this
changes the maximum number of disk pages that SQLite will hold in
memory (SQLite's default is 2000 pages).PRAGMA synchronous
flag, possible values are
0, 1, or 2 or the corresponding strings "OFF", "NORMAL", or "FULL".
The RSQLite
package uses a default of 0 (OFF), although
SQLite's default is 2 (FULL) as of version NULL
, the default module will be used. Module availability
depends on your operating as summarized by the following table: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
.read.table
, i.e., TRUE if the first
line has one fewer column that the second line.read.table
from the
input file to create the proper table definition. Default is 50.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.
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.
sqliteImportFile
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.