tcl: Transaction Control Language (TCL)

In tjpalanca/dbtools: Database Tools for R

Description

Transaction control allows changes in the data via dml or ddl to be batched together in an "all-or-nothing" fashion.

Usage

transact(object, ...)

begin(object, ...)

commit(object, ...)

rollback(object, ...)

in_transaction(object, ...)

Arguments

object	(obj) whose transactions are to be controlled.
...	(arg) passed to underlying functions

Functions

• transact: Ensures that a transaction is in place; no-op if already in a transaction

• begin: Starts a transaction; throws error if already in transaction

• commit: Commits the changes into the database

• rollback: Rolls back the transaction and cancels changes to the data

• in_transaction: Checks if the connection is in a transaction

See Also

Other Database Operations: connect(), dml, execute()

tjpalanca/dbtools documentation built on Oct. 7, 2021, 6:43 a.m.