saveDataDirectDatabase: Save data tables direct to database
In mcneilco/racas: R Package for ACAS
View source: R/directDatabaseSave.R
saveDataDirectDatabase R Documentation
Save data tables direct to database
Description
Saves whole sets of data for an experiment to the database, and rolls back
the transaction if anything fails (or deletes on Oracle).
Usage
saveDataDirectDatabase(agData, tgData, subjectData, lsTransactionId = NA,
experimentId = NULL)
Arguments
agData
data.frame or data.table of analysis group data
tgData
data.frame or data.table of treatment group data
subjectData
data.frame or data.table of subject data
lsTransactionId
integer id of transaction
experimentId
integer id of experiment
Details
This does not work through any roo service, so it will be faster,
but has fewer integrity checks along the way. Use with caution. For
required columns, see example with data(agData) or look in code of
prepareTableForDD. If you need to do updates as well as
saves, use saveAllViaTsv. The experimentId and
lsTransactionId will fill in if they are missing in the input data tables.
mcneilco/racas documentation built on Aug. 30, 2024, 9:27 p.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.
View source: R/directDatabaseSave.R
| saveDataDirectDatabase | R Documentation |
Save data tables direct to database
Description
Saves whole sets of data for an experiment to the database, and rolls back the transaction if anything fails (or deletes on Oracle).
Usage
saveDataDirectDatabase(agData, tgData, subjectData, lsTransactionId = NA,
experimentId = NULL)
Arguments
agData |
data.frame or data.table of analysis group data |
tgData |
data.frame or data.table of treatment group data |
subjectData |
data.frame or data.table of subject data |
lsTransactionId |
integer id of transaction |
experimentId |
integer id of experiment |
Details
This does not work through any roo service, so it will be faster,
but has fewer integrity checks along the way. Use with caution. For
required columns, see example with data(agData) or look in code of
prepareTableForDD. If you need to do updates as well as
saves, use saveAllViaTsv. The experimentId and
lsTransactionId will fill in if they are missing in the input data tables.
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.