rocker0.3.1 package

Database Interface Class

getInfoRes

Information on result object.

getInfoDrv

Information on driver object.

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 an...

existsTable

Check if table exists.

fetch

Fetch SQL query result from database.

getInfoCon

Information on connection object.

getQuery

Retrieve SQL query from database. Combination of functions sendQuery()...

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-package

rocker: Database Interface 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 usi...

setupPostgreSQL

Setup database driver and define connection parameters for PostgreSQL ...

setupSQLite

Setup database driver and define connection parameters for SQLite usin...

unloadDriver

Reset database driver and connection parameters.

validateCon

Check if an earlier opened connection is still open.

writeTable

Write data to table.

'R6' class interface for handling relational database connections using 'DBI' package as backend. The class allows handling of connections to e.g. PostgreSQL, MariaDB and SQLite. The purpose is having an intuitive object allowing straightforward handling of SQL databases.

  • Maintainer: Nikolaus Pawlowski
  • License: MIT + file LICENSE
  • Last published: 2022-08-20