dbTransaction: Create, commit or abort a database transaction.

In MonetDB/MonetDB.R: R DBI interface to MonetDB

Description

is used to switch the data from the normal auto-commiting mode into transactional mode. Here, changes to the database will not be permanent until dbCommit is called. If the changes are not to be kept around, you can use dbRollback to undo all the changes since dbTransaction was called.

Usage

## S4 method for signature 'MonetDBConnection'
dbTransaction(conn, ...)

Arguments

conn	A MonetDB.R database connection, created using dbConnect with the MonetDB.R database driver.

Value

TRUE if the transaction was successful

Examples

conn <- dbConnect(MonetDB.R(), "monetdb://localhost/acs")
dbSendUpdate(conn, "CREATE TABLE foo(a INT,b VARCHAR(100))")
dbTransaction(conn)
dbSendUpdate(conn, "INSERT INTO foo VALUES(?,?)", 42, "bar")
dbCommit(conn)
dbTransaction(conn)
dbSendUpdate(conn, "INSERT INTO foo VALUES(?,?)", 43, "bar")
dbRollback(conn)

MonetDB/MonetDB.R documentation built on Dec. 31, 2020, 3:18 p.m.