DBI v0.3.0
0
Monthly downloads
R Database Interface
A database interface (DBI) definition for communication
between R and relational database management systems. All
classes in this package are virtual and need to be extended by
the various R/DBMS implementations.
Functions in DBI
Name | Description | |
DBIConnection-class | DBIConnection class. | |
dbGetRowCount | The number of rows fetched so far. | |
dbGetDBIVersion | Determine the current version of the package. | |
dbDisconnect | Disconnect (close) a connection | |
SQL | SQL quoting. | |
dbListTables | List remote tables. | |
dbReadTable | Copy data frames to and from database tables. | |
DBIDriver-class | DBIDriver class. | |
dbExistsTable | Does a table exist? | |
dbColumnInfo | Information about result types. | |
dbConnect | Create a connection to a DBMS. | |
dbDriver | Load and unload database drivers. | |
dbGetRowsAffected | The number of rows affected by data modifying query. | |
dbIsValid | Is this DBMS object still valid? | |
dbHasCompleted | Has the operation completed? | |
dbGetInfo | Get DBMS metadata. | |
DBIObject-class | DBIObject class. | |
dbCallProc | Call an SQL stored procedure | |
dbRemoveTable | Remove a table from the database. | |
transactions | Begin/commit/rollback SQL transactions | |
dbDataType | Determine the SQL data type of an object. | |
dbSendQuery | Execute a statement on a given database connection. | |
dbGetQuery | Send query, retrieve results and then clear result set. | |
print.list.pairs | Print a list of pairs. | |
dbSetDataMappings | Set data mappings between an DBMS and R. | |
dbGetStatement | Get the statement associated with a result set | |
dbListFields | List field names of a remote table. | |
dbFetch | Fetch records from a previously executed query. | |
DBIResult-class | DBIResult class. | |
dbClearResult | Clear a result set. | |
dbListConnections | List currently open connections. | |
dbListResults | A list of all pending results. | |
dbGetException | Get DBMS exceptions. | |
make.db.names | Make R identifiers into legal SQL identifiers. | |
dbiCheckCompliance | Check a driver for compliance with DBI. | |
No Results! |
Last month downloads
Details
License | LGPL (>= 2) |
URL | https://github.com/rstats-db/DBI |
BugReports | https://github.com/rstats-db/DBI/issues |
Collate | 'DBObject.R' 'DBConnection.R' 'DBDriver.R' 'DBResult.R' 'compliance.R' 'keywords.R' 'quote.R' 'util.R' |
NeedsCompilation | no |
Packaged | 2014-09-02 23:05:32 UTC; ligges |
Repository | CRAN |
Date/Publication | 2014-09-03 01:05:44 |
depends | base (>= 2.15.0) , methods , R (>= 2.15.0) |
suggests | RSQLite , testthat |
Contributors | R Interest Group on Databases |
Include our badge in your README
[](http://www.rdocumentation.org/packages/DBI)