read_SQL_data_model: Read a data model from an SQL file from the MySQL Workbench

In patzaw/ReDaMoR: Relational Data Modeler

Read a data model from an SQL file from the MySQL Workbench

Description

Read a data model from an SQL file from the MySQL Workbench

Usage

read_SQL_data_model(f, typeRef = "MySQLWB", mysqlcomments = TRUE)

readSQLDataModel(...)

Arguments

f	the SQL file to read
typeRef	the reference for type conversion (Default: "MySQLWB"; see list_type_ref())
mysqlcomments	if MySQL comments (starting with #) should be removed (Default: TRUE)
...	params for read_SQL_data_model

Details

Database, table and field names should be surrounded by "'".

Value

A RelDataModel object

Functions

• readSQLDataModel(): Deprecated version of read_SQL_data_model

Examples

## Read the model ----
hpo_from_sql <- read_SQL_data_model(
   system.file("examples/HPO-model.sql", package="ReDaMoR")
)
## Confront to data ----
confrontation_report <- confront_data(
   hpo_from_sql,
   path=list.files(
      system.file("examples/HPO-subset", package="ReDaMoR"),
      full.names=TRUE
   ),
   returnData=TRUE
)

patzaw/ReDaMoR documentation built on Feb. 23, 2025, 12:54 a.m.