Skip to contents

Rollback a transaction

Source: R/transactions.R
rollback_transaction.Rd

Rolls back the current transaction, discarding all changes made since the transaction began.

Usage

rollback_transaction(conn = NULL)

Arguments

conn

Optional DuckDB connection object. If not provided, uses the default ducklake connection.

Value

Invisibly returns TRUE on success

Details

This function discards all changes made since begin_transaction() was called, reverting the database to its state before the transaction began.

See also

Other transactions: begin_transaction(), commit_transaction(), set_ducklake_retry(), set_snapshot_metadata(), with_transaction()

Examples

lake_dir <- tempfile("rollback_lake_")
dir.create(lake_dir)
attach_ducklake("rollback_lake", lake_path = lake_dir)
create_table(mtcars, "cars")

begin_transaction()
rows_delete(
  get_ducklake_table("cars"),
  data.frame(gear = 3),
  by = "gear"
)

# Something went wrong, rollback
rollback_transaction()
#> Transaction rolled back.

detach_ducklake("rollback_lake", shutdown = TRUE)
unlink(lake_dir, recursive = TRUE)