RMariaDB (version 1.0.10)

transactions: DBMS Transaction Management

Description

Commits or roll backs the current transaction in an MariaDB connection. Note that in MariaDB DDL statements (e.g. CREATE TABLE) cannot be rolled back.

Usage

# S4 method for MariaDBConnection
dbBegin(conn, ...)

# S4 method for MariaDBConnection dbCommit(conn, ...)

# S4 method for MariaDBConnection dbRollback(conn, ...)

Arguments

conn

a '>MariaDBConnection object, as produced by DBI::dbConnect().

...

Unused.

Examples

Run this code
# NOT RUN {
if (mariadbHasDefault()) {
con <- dbConnect(RMariaDB::MariaDB(), dbname = "test")
df <- data.frame(id = 1:5)

dbWriteTable(con, "df", df, temporary = TRUE)
dbBegin(con)
dbExecute(con, "UPDATE df SET id = id * 10")
dbGetQuery(con, "SELECT id FROM df")
dbRollback(con)

dbGetQuery(con, "SELECT id FROM df")

dbDisconnect(con)
}
# }

Run the code above in your browser using DataCamp Workspace