uploadResults: Upload results to the database server.

In SelfControlledCohort: Self-Controlled Cohort Population-Level Estimation

Upload results to the database server.

Description

Requires the results data model tables have been created using the createResultsDataModel function.

Usage

uploadResults(
  connectionDetails,
  schema,
  resultsFolder,
  forceOverWriteOfSpecifications = FALSE,
  purgeSiteDataBeforeUploading = FALSE,
  tablePrefix = "",
  ...
)

Arguments

connectionDetails	An object of type connectionDetails as created using the createConnectionDetails function in the DatabaseConnector package.
schema	The schema on the server where the tables have been created.
resultsFolder	Path to result files
forceOverWriteOfSpecifications	If TRUE, specifications of the phenotypes, cohort definitions, and analysis will be overwritten if they already exist on the database. Only use this if these specifications have changed since the last upload.
purgeSiteDataBeforeUploading	If TRUE, before inserting data for a specific databaseId all the data for that site will be dropped. This assumes the input zip file contains the full data for that data site.
tablePrefix	(Optional) string to insert before table names for database table names
...	See ResultModelManager::uploadResults

Value

Invisibly returns NULL. Uploads results to the database as a side effect.

Examples

if (interactive()) {
connectionDetails <- DatabaseConnector::createDonnectionDetails(
  dbms = "sqlite",
  server = "myResults.db"
)
uploadResults(
  connectionDetails = connectionDetails,
  schema = "main",
  resultsFolder = tempdir()
)
}

SelfControlledCohort documentation built on June 17, 2026, 5:07 p.m.