R/dbBegin_MariaDBConnection.R
, R/dbCommit_MariaDBConnection.R
, R/dbRollback_MariaDBConnection.R
, and 1 more
transactions.Rd
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.
# S4 method for MariaDBConnection
dbBegin(conn, ...)
# S4 method for MariaDBConnection
dbCommit(conn, ...)
# S4 method for MariaDBConnection
dbRollback(conn, ...)
a MariaDBConnection object, as produced by
DBI::dbConnect()
.
Unused.
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)
}