Database Interface Class

---

Documentation for package ‘rocker’ version 0.3.1

• DESCRIPTION file.
• User guides, package vignettes and other documentation.
• Package NEWS.

Help Pages

appendTable	Append data to table.
begin	Begin transaction.
canConnect	Test connection parameters.
clearResult	Clear query or statement result.
columnInfo	Information on query result columns.
commit	Commit transaction.
connect	Establish database connection using stored parameters.
createTable	Create empty formatted table.
disconnect	Disconnect database.
execute	Execute SQL statement in database. Combination of functions execute and clearResult. If required, database is automatically connected and disconnected.
existsTable	Check if table exists.
fetch	Fetch SQL query result from database.
getInfoCon	Information on connection object.
getInfoDrv	Information on driver object.
getInfoRes	Information on result object.
getQuery	Retrieve SQL query from database. Combination of functions sendQuery(), fetch() and clearResult(). If required, database is automatically connected and disconnected.
getRowCount	Information on number of retrieved rows.
getRowsAffected	Information on number of affected rows.
getStatement	Information on sent statement.
hasCompleted	Information whether all records were retrieved.
isValidCon	Check connection object.
isValidDrv	Check driver object.
isValidRes	Check result object.
listFields	List table column names.
listObjects	List database objects.
listTables	List database tables.
newDB	newDB
readTable	Read table.
removeTable	Remove table.
rocker	'rocker' Database Interface R6 Class
rocker-R6-class	'rocker' Database Interface R6 Class
rocker-README	README
rocker-S3-functions	'rocker' Database Interface R6 Class - S3 functions
rollback	Rollback transaction.
sendQuery	Send SQL query to database.
sendStatement	Send SQL statement to database.
setupDriver	Setup database driver and define connection parameters.
setupMariaDB	Setup database driver and define connection parameters for MariaDB using RMariaDB package. Wrapper for setupDriver() function.
setupPostgreSQL	Setup database driver and define connection parameters for PostgreSQL using RPostgres package. Wrapper for setupDriver() function.
setupSQLite	Setup database driver and define connection parameters for SQLite using RSQLite package. Wrapper for setupDriver() function.
unloadDriver	Reset database driver and connection parameters.
validateCon	Check if an earlier opened connection is still open.
writeTable	Write data to table.