DBIConnection-class {DBI}R Documentation

Class DBIConnection

Description

Base class for all DBMS connection classes. Individual drivers (ODBC, Oracle, PostgreSQL, MySQL, etc.) extend this class in a database-specific manner.

Objects from the Class

A virtual Class: No objects may be created from it.

Extends

Class "DBIObject", directly.

Generator

The main generator is dbConnect.

Methods

The following methods take objects from classes derived from DBIConnection:

Create and close connections:

dbConnect

signature(drv = "DBIConnection"): ...

dbDisconnect

signature(conn = "DBIConnection"): ...

Execute SQL commands:

dbSendQuery

signature(conn = "DBIConnection", statement = "character"): ...

dbGetQuery

signature(conn = "DBIConnection", statement = "character"): ...

dbCallProc

signature(conn = "DBIConnection"): ...

Transaction management:

dbCommit

signature(conn = "DBIConnection"): ...

dbRollback

signature(conn = "DBIConnection"): ...

Meta-data:

dbListResults

signature(conn = "DBIConnection"): ...

dbGetInfo

signature(dbObj = "DBIConnection"): ...

summary

signature(object = "DBIConnection"): ...

Exceptions:

dbGetException

signature(conn = "DBIConnection"): ...

dbListFields

signature(conn = "DBIConnection", name = "character"): ...

Convenience functions:

dbListTables

signature(conn = "DBIConnection"): ...

dbReadTable

signature(conn = "DBIConnection", name = "character"): ...

dbExistsTable

signature(conn = "DBIConnection", name = "character"): ...

dbRemoveTable

signature(conn = "DBIConnection", name = "character"): ...

dbWriteTable

signature(conn = "DBIConnection", name = "character", value = "data.frame"): ...

Author(s)

R-SIG-DB

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://developer.r-project.org/db.

See Also

DBI classes: DBIObject-class DBIDriver-class DBIConnection-class DBIResult-class

Examples

## Not run: 
ora <- dbDriver("Oracle")
con <- dbConnect(ora, "user/password@dbname")

pg <- dbDriver("PostgreSQL")
con <- dbConnect(pg, "user", "password")

## End(Not run)

[Package DBI version 0.2-5 Index]