createCharacterizationTables: Create the results tables to store characterization results into a database

Description

This function executes a large set of SQL statements to create tables that can store results

Usage

createCharacterizationTables(
  connectionDetails,
  resultSchema,
  targetDialect = "postgresql",
  deleteExistingTables = TRUE,
  createTables = TRUE,
  tablePrefix = "c_",
  tempEmulationSchema = getOption("sqlRenderTempEmulationSchema")
)

Value

Returns NULL but creates the required tables into the specified database schema.

Arguments

connectionDetails: The connectionDetails to a database created by using the function createConnectDetails in the DatabaseConnector package.
resultSchema: The name of the database schema that the result tables will be created.
targetDialect: The database management system being used
deleteExistingTables: If true any existing tables matching the Characterization result tables names will be deleted
createTables: If true the Characterization result tables will be created
tablePrefix: A string appended to the Characterization result tables
tempEmulationSchema: The temp schema used when the database management system is oracle

Details

This function can be used to create (or delete) Characterization result tables

Examples

Run this code

# create sqlite database
charResultDbCD <- createSqliteDatabase()

# create database results tables
createCharacterizationTables(
   connectionDetails = charResultDbCD,
   resultSchema = 'main'
 )