Create OMOP CDM SQL files

Description

Writes DDL, ForeignKey, PrimaryKey and index SQL files for given cdmVersion and targetDialect to the 'ddl' folder in specified output folder.

Usage

buildRelease(
  cdmVersions = listSupportedVersions(),
  targetDialects = listSupportedDialects(),
  outputfolder = file.path(tempdir(), "inst", "ddl")
)

Arguments

Value

Writes DDL, ForeignKey, PrimaryKey and index SQL files for given cdmVersion and targetDialect to the 'ddl' folder in specified output folder.

Create OMOP CDM release zip

Description

First calls buildReleaseZips for given cdmVersions and targetDialects. This writes the ddl sql files to the ddl folder. Then zips all written ddl files into a release zip to given output folder.

Usage

buildReleaseZip(
  cdmVersion,
  targetDialect = listSupportedDialects(),
  outputfolder = file.path(tempdir(), "output")
)

Arguments

Details

If no (or multiple) targetDialect is given, then one zip is written with the files of all supported dialects.

Value

A character string containing the OHDSQL DDL

Examples

## Not run: 
buildReleaseZip(cdmVersion='5.3', targetDialect='sql server', outputfolder='.')

## End(Not run)

Create the OHDSI-SQL Common Data Model DDL code

Description

The createDdl, createForeignKeys, and createPrimaryKeys functions each return a character string containing their respective DDL SQL code in OHDSQL dialect for a specific CDM version. The SQL they generate needs to be rendered and translated before it can be executed.

Usage

createDdl(cdmVersion)

createPrimaryKeys(cdmVersion)

createForeignKeys(cdmVersion)

Arguments

Details

The DDL SQL code is created 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.

Value

A character string containing the OHDSQL DDL

A string containing the OHDSQL for creation of primary keys in the OMOP CDM.

A string containing the OHDSQL for creation of foreign keys in the OMOP CDM.

Functions

• createPrimaryKeys(): createPrimaryKeys Returns a string containing the OHDSQL for creation of primary keys in the OMOP CDM.

• createForeignKeys(): createForeignKeys Returns a string containing the OHDSQL for creation of foreign keys in the OMOP CDM.

Examples

## Not run: 
ddl <- createDdl("5.4")
pk <- createPrimaryKeys("5.4")
fk <- createForeignKeys("5.4")

## End(Not run)

Get current DDL sitting on the main branch

Description

Get current DDL sitting on the main branch

Usage

downloadCurrentDdl(
  githubPath = "OHDSI/CommonDataModel",
  pathToCsv = "Sql%20Server/OMOP%20CDM%20sql%20server%20ddl.txt",
  outputFile = paste0("inst/sql/sql_server/OMOP CDM ddl ", Sys.Date(), ".sql")
)

Arguments

Details

This function gets the current ddl on the CDM main branch. It will be taken from the Sql Server folder. The default location is inst/settings/currentOmopDdl.sql.

Value

The current DDL sitting on the main branch of the CommonDataModel repository.

Examples

## Not run: 
downloadCurrentDdl("OHDSI/CommonDataModel",
 pathToCsv="Sql%20Server/OMOP%20CDM%20sql%20server%20ddl.txt")

## End(Not run)

Generate and execute the DDL on a database

Description

This function will generate the DDL for a specific dbms and CDM version and then execute the DDL on a database.

Usage

executeDdl(
  connectionDetails,
  cdmVersion,
  cdmDatabaseSchema,
  executeDdl = TRUE,
  executePrimaryKey = TRUE,
  executeForeignKey = TRUE,
  ...
)

Arguments

Value

Writes the fully specified DDLs, primary keys, foreign keys, and indices to a file and then executes on a database.

Examples

## Not run: 
executeDdl(connectionDetails = connectionDetails,
           cdmVersion = "5.4",
           cdmDatabaseSchema = "myCdm")

## End(Not run)

List RDBMS dialects supported by this package

Description

List RDBMS dialects supported by this package

Usage

listSupportedDialects()

Value

A list containing the supported Structured Query Language (SQL) dialects.

List CDM versions supported by this package

Description

List CDM versions supported by this package

Usage

listSupportedVersions()

Value

A character vector containing the supported Common Data Model (CDM) versions in major.minor format.

Parse Wiki files

Description

Parses all .md files in the specified location (or any subfolders), extracting definitions of the Common Data Model.

Usage

parseWiki(mdFilesLocation, output_file)

Arguments

Value

CSV files with the OMOP CDM specifications.

Write DDL script

Description

Write the DDL to a SQL file. The SQL will be rendered (parameters replaced) and translated to the target SQL dialect. By default the @cdmDatabaseSchema parameter is kept in the SQL file and needs to be replaced before execution.

Usage

writeDdl(
  targetDialect,
  cdmVersion,
  outputfolder,
  cdmDatabaseSchema = "@cdmDatabaseSchema"
)

writePrimaryKeys(
  targetDialect,
  cdmVersion,
  outputfolder,
  cdmDatabaseSchema = "@cdmDatabaseSchema"
)

writeForeignKeys(
  targetDialect,
  cdmVersion,
  outputfolder,
  cdmDatabaseSchema = "@cdmDatabaseSchema"
)

writeIndex(
  targetDialect,
  cdmVersion,
  outputfolder,
  cdmDatabaseSchema = "@cdmDatabaseSchema"
)

Arguments

Value

Writes SQL file with the OMOP CDM DDL for the specified CDM version and target dialect in the output folder.

Writes a SQL file with the primary keys for the OMOP CDM based on the specified target dialect and CDM version.

Writes a SQL file with the foreign keys for the OMOP CDM based on the specified target dialect and CDM version.

Writes a SQL file with the indices for the OMOP CDM based on the specified target dialect and CDM version.

Functions

• writePrimaryKeys(): writePrimaryKeys Write the SQL code that creates the primary keys to a file.

• writeForeignKeys(): writeForeignKeys Write the SQL code that creates the foreign keys to a file.

• writeIndex(): writeIndex Write the rendered and translated sql that creates recommended indexes to a file.