saveDataDirectDatabase: Save data tables direct to database

View source: R/directDatabaseSave.R

saveDataDirectDatabaseR 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.