createPlpResultTables: Create the results tables to store PatientLevelPrediction...

In OHDSI/PatientLevelPrediction: Developing patient level prediction using data in the OMOP Common Data Model

Create the results tables to store PatientLevelPrediction models and results into a database

Description

This function executes a large set of SQL statements to create tables that can store models and results

Usage

createPlpResultTables(
  connectionDetails,
  targetDialect = "postgresql",
  resultSchema,
  deleteTables = T,
  createTables = T,
  tablePrefix = "",
  tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"),
  testFile = NULL
)

Arguments

connectionDetails	The database connection details
targetDialect	The database management system being used
resultSchema	The name of the database schema that the result tables will be created.
deleteTables	If true any existing tables matching the PatientLevelPrediction result tables names will be deleted
createTables	If true the PatientLevelPrediction result tables will be created
tablePrefix	A string that appends to the PatientLevelPrediction result tables
tempEmulationSchema	The temp schema used when the database management system is oracle
testFile	(used for testing) The location of an sql file with the table creation code

Details

This function can be used to create (or delete) PatientLevelPrediction result tables

Value

Returns NULL but creates the required tables into the specified database schema(s).

OHDSI/PatientLevelPrediction documentation built on Sept. 15, 2024, 6:38 a.m.