CreateSQL_AMI: Create SQL for AMI extraction for Outcome

In Blanch-Font/SOPHIA: What the Package Does (One Line, Title Case)

Create SQL for AMI extraction for Outcome

Description

Create SQL for AMI extraction for Outcome

Usage

CreateSQL_AMI(cdm_bbdd, cdm_schema, results_sc, cohortTable)

Arguments

cdm_bbdd	A connection for a OMOP database via DatabaseConnector
cdm_schema	A name for OMOP schema
results_sc	A name for result schema
cohortTable	A name of the result cohort

Value

A SQL syntax

Examples

# Sys.setenv("DATABASECONNECTOR_JAR_FOLDER" = "~idiap/projects/SOPHIA_codi/data/jdbcDrivers/")
# dbms = Sys.getenv("DBMS")
# user <- if (Sys.getenv("DB_USER") == "") NULL else Sys.getenv("DB_USER")
# password <- if (Sys.getenv("DB_PASSWORD") == "") NULL else Sys.getenv("DB_PASSWORD")
# server = Sys.getenv("DB_SERVER")
# port = Sys.getenv("DB_PORT")
# connectionDetails <- DatabaseConnector::createConnectionDetails(dbms = dbms,
#                                                                 server = server,
#                                                                 user = user,
#                                                                 password = password,
#                                                                 port = port)
# cdm_bbdd <- DatabaseConnector::connect(connectionDetails = connectionDetails)
# cdm_schema <- 'omop21t2_test'
# results_sc <- 'sophia_test'
# cohortTable <- 'prova_Capr'
# outcomeInfo <- CreateSQL_AMI(cdm_bbdd, cdm_schema, results_sc, cohortTable)

Blanch-Font/SOPHIA documentation built on May 12, 2023, 1:09 a.m.