dbCommit-methods | R Documentation |
Transaction related commands.
Start a transaction, commit or roll back the current transaction
in an PostgreSQL connection.
dbBegin
starts a transaction.
dbCommit
and dbRollback
commit and rollback the
transaction, respectively.
a PostgreSQLConnection
object, as produced by the function
dbConnect
.
currently unused.
See the Database Interface definition document
DBI.pdf
in the base directory of this package
or
https://cran.r-project.org/package=DBI.
PostgreSQL
,
dbBegin
,
dbConnect
,
dbSendQuery
,
dbGetQuery
,
fetch
,
dbCommit
,
dbGetInfo
,
dbReadTable
.
## Not run: drv <- dbDriver("PostgreSQL") con <- dbConnect(drv, dbname="postgres") dbGetQuery(con, "select count(*) from sales") dbBegin(con) rs <- dbSendQuery(con, "Delete * from sales as p where p.cost>10") if(dbGetInfo(rs, what = "rowsAffected") > 250){ warning("Rolling back transaction") dbRollback(con) }else{ dbCommit(con) } dbGetQuery(con, "select count(*) from sales") dbDisconnect(con) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.