SQLite interface for R


[Up] [Top]

Documentation for package ‘RSQLite’ version 0.11.1

Help Pages

C D F I L M P S misc

-- C --

coerce-method Summarize an SQLite object
coerce-methods Summarize an SQLite object

-- D --

dbBeginTransaction DBMS Transaction Management
dbBeginTransaction-method DBMS Transaction Management
dbBeginTransaction-methods DBMS Transaction Management
dbBuildTableDefinition Build the SQL CREATE TABLE definition as a string
dbCallProc-method Call an SQL stored procedure
dbCallProc-methods Call an SQL stored procedure
dbClearResult-method Execute a SQL statement on a database connection
dbColumnInfo-method Database interface meta-data
dbColumnInfo-methods Database interface meta-data
dbCommit-method DBMS Transaction Management
dbCommit-methods DBMS Transaction Management
dbConnect-method Create a connection object to an SQLite DBMS
dbConnect-methods Create a connection object to an SQLite DBMS
dbDataType-method Determine the SQL Data Type of an S object
dbDataType-methods Determine the SQL Data Type of an S object
dbDisconnect-method Create a connection object to an SQLite DBMS
dbDisconnect-methods Create a connection object to an SQLite DBMS
dbDriver-method SQLite implementation of the Database Interface (DBI) classes and drivers
dbDriver-methods SQLite implementation of the Database Interface (DBI) classes and drivers
dbExistsTable-method Convenience functions for Importing/Exporting DBMS tables
dbExistsTable-methods Convenience functions for Importing/Exporting DBMS tables
dbGetDBIVersion-methods Database interface meta-data
dbGetException-method Execute a SQL statement on a database connection
dbGetException-methods Execute a SQL statement on a database connection
dbGetInfo Database interface meta-data
dbGetInfo-method Database interface meta-data
dbGetPreparedQuery Execute a SQL statement on a database connection
dbGetPreparedQuery-method Execute a SQL statement on a database connection
dbGetPreparedQuery-methods Execute a SQL statement on a database connection
dbGetQuery-method Execute a SQL statement on a database connection
dbGetQuery-methods Execute a SQL statement on a database connection
dbGetRowCount-method Database interface meta-data
dbGetRowCount-methods Database interface meta-data
dbGetRowsAffected-method Database interface meta-data
dbGetRowsAffected-methods Database interface meta-data
dbGetStatement-method Database interface meta-data
dbGetStatement-methods Database interface meta-data
dbHasCompleted-method Database interface meta-data
dbHasCompleted-methods Database interface meta-data
dbListConnections-method List items from an SQLite DBMS and from objects
dbListConnections-methods List items from an SQLite DBMS and from objects
dbListFields-method List items from an SQLite DBMS and from objects
dbListFields-methods List items from an SQLite DBMS and from objects
dbListResults-method List items from an SQLite DBMS and from objects
dbListResults-methods List items from an SQLite DBMS and from objects
dbListTables-method List items from an SQLite DBMS and from objects
dbListTables-methods List items from an SQLite DBMS and from objects
dbObjectId-class Class dbObjectId
dbReadTable-method Convenience functions for Importing/Exporting DBMS tables
dbReadTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-method Convenience functions for Importing/Exporting DBMS tables
dbRemoveTable-methods Convenience functions for Importing/Exporting DBMS tables
dbRollback-method DBMS Transaction Management
dbRollback-methods DBMS Transaction Management
dbSendPreparedQuery Execute a SQL statement on a database connection
dbSendPreparedQuery-method Execute a SQL statement on a database connection
dbSendPreparedQuery-methods Execute a SQL statement on a database connection
dbSendQuery-method Execute a SQL statement on a database connection
dbSendQuery-methods Execute a SQL statement on a database connection
dbSetDataMappings-method Set data mappings between SQLite and R/S-Plus
dbSetDataMappings-methods Set data mappings between SQLite and R/S-Plus
dbUnloadDriver-method SQLite implementation of the Database Interface (DBI) classes and drivers
dbUnloadDriver-methods SQLite implementation of the Database Interface (DBI) classes and drivers
dbWriteTable-method Convenience functions for Importing/Exporting DBMS tables
dbWriteTable-methods Convenience functions for Importing/Exporting DBMS tables

-- F --

fetch-method Fetch records from a previously executed query
fetch-methods Fetch records from a previously executed query
format-method Summarize an SQLite object
format-methods Summarize an SQLite object

-- I --

isIdCurrent Check whether an dbObjectId handle object is valid or not
isSQLKeyword-method Make R/S-Plus identifiers into legal SQL identifiers
isSQLKeyword-methods Make R/S-Plus identifiers into legal SQL identifiers

-- L --

last.warning Support Functions

-- M --

make.db.names-method Make R/S-Plus identifiers into legal SQL identifiers

-- P --

print-method Summarize an SQLite object

-- S --

show-method Summarize an SQLite object
show-methods Summarize an SQLite object
SQLite Initialize the SQLite engine for the current R session.
sqliteCloseConnection Support Functions
sqliteCloseDriver Support Functions
sqliteCloseResult Support Functions
SQLiteConnection-class Class SQLiteConnection
sqliteConnectionInfo Support Functions
sqliteCopyDatabase Copy a SQLite database
sqliteDataType Support Functions
sqliteDescribeConnection Support Functions
sqliteDescribeDriver Support Functions
sqliteDescribeResult Support Functions
SQLiteDriver Initialize the SQLite engine for the current R session.
SQLiteDriver-class Class SQLiteDriver
sqliteDriverInfo Support Functions
sqliteExecStatement Support Functions
sqliteFetch Support Functions
sqliteFetchOneColumn Support Functions
sqliteImportFile Support Functions
sqliteInitDriver Support Functions
sqliteNewConnection Support Functions
SQLiteObject-class Class SQLiteObject
sqliteQuickColumn Return an entire column from a SQLite database
sqliteQuickSQL Support Functions
sqliteReadTable Support Functions
SQLiteResult-class Class SQLiteResult
sqliteResultInfo Support Functions
sqliteTableFields Support Functions
sqliteTransactionStatement Support Functions
sqliteWriteTable Support Functions
SQLITE_RO Support Functions
SQLITE_RW Support Functions
SQLITE_RWC Support Functions
SQLKeywords-method Make R/S-Plus identifiers into legal SQL identifiers
SQLKeywords-methods Make R/S-Plus identifiers into legal SQL identifiers
summary-method Summarize an SQLite object
summary-methods Summarize an SQLite object

-- misc --

.conflicts.OK Support Functions
.SQLite.NA.string Support Functions
.SQLitePkgName Support Functions
.SQLitePkgRCS Support Functions
.SQLitePkgVersion Support Functions