RSQLite (version 0.4-1)

dbCommit-methods: DBMS Transaction Management

Description

By default, SQLite is in auto-commit mode. dbBeginTransaction starts an SQLite transaction and turn auto-commit off. dbCommit and dbRollback commit and rollback the transaction, respectively and turn auto-commit on.

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

SQLite, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbReadTable.

Examples

drv <- dbDriver("SQLite")
con <- dbConnect(drv, dbname = "mySQLite.db")
dbBeginTransaction(con)
rs <- dbSendQuery(con, 
      "delete * from PURGE as p where p.wavelength<0.03")
if(dbGetInfo(rs, what = "rowsAffected") > 250){
  warning("dubious deletion -- rolling back transaction")
  dbRollback(con)
}