Create the results data model tables on a database server.

Create the results data model tables on a database server.

createResultsDataModel(
  connectionDetails = NULL,
  databaseSchema,
  tablePrefix = ""
)

Arguments

connectionDetails

DatabaseConnector connectionDetails instance @seealso[DatabaseConnector::createConnectionDetails]

databaseSchema

The schema on the server where the tables will be created.

tablePrefix

(Optional) string to insert before table names for database table names

Value

Invisibly returns NULL. Creates database tables for results storage as a side effect.

Details

Only PostgreSQL and SQLite servers are supported.

Examples

if (FALSE) { # \dontrun{
connectionDetails <- DatabaseConnector::createConnectionDetails(
  dbms = "postgresql",
  server = "localhost/ohdsi",
  user = "joe",
  password = "secret"
)

createResultsDataModel(
  connectionDetails = connectionDetails,
  databaseSchema = "results"
)
} # }