CreateSQL_nephroWP4: Create SQL for Nephropathy from DM1 for WP4 extraction for...

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

Create SQL for Nephropathy from DM1 for WP4 extraction for Outcome

Description

Create SQL for Nephropathy from DM1 for WP4 extraction for Outcome

Usage

CreateSQL_nephroWP4(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_nephro(cdm_bbdd, cdm_schema, results_sc, cohortTable)

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