Exports all tables in the result database to csv files

This function extracts the database tables into csv files

exportDatabaseToCsv(
  connectionDetails,
  resultSchema,
  targetDialect = NULL,
  tablePrefix = "c_",
  filePrefix = NULL,
  tempEmulationSchema = getOption("sqlRenderTempEmulationSchema"),
  saveDirectory,
  minMeanCovariateValue = 0.001
)

Arguments

connectionDetails

The connection details to input into the function connect in the DatabaseConnector package.

resultSchema

The name of the database schema that the result tables will be created.

targetDialect

DEPRECATED: derived from connectionDetails.

tablePrefix

The table prefix to apply to the characterization result tables

filePrefix

The prefix to apply to the files

tempEmulationSchema

The temp schema used when the database management system is oracle

saveDirectory

The directory to save the csv results

minMeanCovariateValue

The minimum mean covariate value (i.e. the minimum proportion for binary covariates) for a covariate to be included in covariate table. Other covariates are removed to save space.

Value

csv file per table into the saveDirectory

Details

This function extracts the database tables into csv files