Description Details Methods Public fields Active bindings Methods Examples
connect to database using either DBI or pool
dbConnection class
connect using DBI or pool
connect to database
close connection to database
send query (statement) to connection
send query to connection
DBIconn
- connection using DBI (NULL if not connected)
poolconn
- connection using pool (NULL is not connected)
conn()
- connection using whichever connection is available
conn()
- connection using whichever connection is available
connect()
dbConnection$connect(drv, ..., usepool = TRUE)
close()
dbConnection$close()
is_open()
dbConnection$is_open()
finalize()
dbConnection$finalize()
conn()
dbConnection$conn(value)
dbSendQuery()
dbConnection$dbSendQuery(query, data_for_sql)
dbSendGlueQuery()
dbConnection$dbSendGlueQuery(query, ...)
dbGetQuery()
dbConnection$dbGetQuery(query)
open_log_db()
dbConnection$open_log_db(filename, tag)
write_log_db()
dbConnection$write_log_db(query = "", data = "")
duration_log_db()
dbConnection$duration_log_db(log_detail)
close_log_db()
dbConnection$close_log_db()
clone()
The objects of this class are cloneable with this method.
dbConnection$clone(deep = FALSE)
deep
Whether to make a deep clone.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | dbConnection$new() # creates new object
dbConnection$connect(
drv = RSQLite::SQLite(),
dbname = "mydatabase.sqlite",
usepool = FALSE
)
# sets $DBIconn or $poolcon to connection
# both set to NULL if fail/warn
# by default 'usepool' is TRUE and attempts
# to use 'pool' package (if available)
# if 'usepool' is FALSE, then do not use
# the 'pool' package, so use 'DBI' instead
dbConnection$close() # closes all connections
query <- "UPDATE Users SET Name = ? WHERE id = ?"
data_for_sql <- list(c("John"), id)
dbConnection$dbSendQuery(query, data_for_sql)
# send parametized 'SQL query'
# with 'data_for_sql'
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.