insertResultsToDatabase {Characterization} | R Documentation |
Upload the results into a result database
Description
This function uploads results in csv format into a result database
Usage
insertResultsToDatabase(
connectionDetails,
schema,
resultsFolder,
tablePrefix = "",
csvTablePrefix = "c_"
)
Arguments
connectionDetails |
The connection details to the result database |
schema |
The schema for the result database |
resultsFolder |
The folder containing the csv results |
tablePrefix |
A prefix to append to the result tables for the characterization results |
csvTablePrefix |
The prefix added to the csv results - default is 'c_' |
Details
Calls ResultModelManager uploadResults function to upload the csv files
Value
Returns the connection to the sqlite database
See Also
Other Database:
createCharacterizationTables()
,
createSqliteDatabase()
Examples
# generate results into resultsFolder
conDet <- exampleOmopConnectionDetails()
drSet <- createDechallengeRechallengeSettings(
targetIds = c(1,2),
outcomeIds = 3
)
cSet <- createCharacterizationSettings(
dechallengeRechallengeSettings = drSet
)
runCharacterizationAnalyses(
connectionDetails = conDet,
targetDatabaseSchema = 'main',
targetTable = 'cohort',
outcomeDatabaseSchema = 'main',
outcomeTable = 'cohort',
cdmDatabaseSchema = 'main',
characterizationSettings = cSet,
outputDirectory = tempdir()
)
# create sqlite database
charResultDbCD <- createSqliteDatabase()
# create database results tables
createCharacterizationTables(
connectionDetails = charResultDbCD,
resultSchema = 'main'
)
# insert results
insertResultsToDatabase(
connectionDetails = charResultDbCD,
schema = 'main',
resultsFolder = tempdir()
)
[Package Characterization version 2.1.3 Index]