createDdlFromFile: Create a DDL script from a two csv files that detail the OMOP...

Description Usage Arguments

View source: R/createDdlFromFile.R

Description

Create a DDL script from a two csv files that detail the OMOP CDM Specifications. These files also form the basis of the CDM documentation and the Data Quality Dashboard.

Usage

1
2
3
4
5
createDdlFromFile(cdmVersionNum = cdmVersion,
  cdmTableCsvLoc = "inst/csv/OMOP_CDMv5.3.1_Table_Level.csv",
  cdmFieldCsvLoc = "inst/csv/OMOP_CDMv5.3.1_Field_Level.csv",
  outputFile = paste0("inst/sql/sql_server/OMOP CDM ddl ", cdmVersion,
  " ", Sys.Date(), ".sql"))

Arguments

cdmVersionNum

The version of the CDM you are creating

cdmTableCsvLoc

The location of the csv file with the high-level CDM table information. This is defaulted to "inst/csv/OMOP_CDMv5.3.1_Table_Level.csv". If a new version of this file was committed to the CDM repository the package automatically will grab it and place it in "inst/csv/".

cdmFieldCsvLoc

The location of the csv file with the CDM field information. This is defaulted to "inst/csv/OMOP_CDMv5.3.1_Field_Level.csv". If a new version of this file was committed to the CDM repository the package automatically will grab it and place it in "inst/csv/".

outputFile

The name of the output ddl sql file. This is defaulted to a location in the inst/sql/sql server folder and named with today's date and the CDM version.


OHDSI/DDLgeneratr documentation built on March 10, 2021, 1:44 a.m.