insertResultsToDatabase: Upload the results into a result database

In Characterization: Implement Descriptive Studies Using the Common Data Model

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()
)

Characterization documentation built on April 4, 2025, 2:02 a.m.