transactions: Begin/commit/rollback SQL transactions
In acjackman/dbezr: Convenience wrapper for accessing SQL databases
Description
transactions require an open connection, so you will need to manually create the connection,
preform queries with gq and then and close the
connection.
Commiting an SQL transaction saves the actions made durreing the transaction to the database.
Rollback resets any transactions that might have happened durring the transaction.
Determine if there is an active transaction
Usage
1
2
3
4
5
6
7
trans_begin(.db = NULL)
trans_commit(force = FALSE, .db = NULL)
trans_rollback(force = FALSE, .db = NULL)
trans_active(force = FALSE, .db = NULL)
Arguments
.db
the connection to use throughout the transaction
force
force the action to take place
acjackman/dbezr documentation built on May 10, 2019, 5:11 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description
transactions require an open connection, so you will need to manually create the connection,
preform queries with gq and then and close the
connection.
Commiting an SQL transaction saves the actions made durreing the transaction to the database.
Rollback resets any transactions that might have happened durring the transaction.
Determine if there is an active transaction
Usage
1 2 3 4 5 6 7 | trans_begin(.db = NULL)
trans_commit(force = FALSE, .db = NULL)
trans_rollback(force = FALSE, .db = NULL)
trans_active(force = FALSE, .db = NULL)
|
Arguments
.db |
the connection to use throughout the transaction |
force |
force the action to take place |
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.