guess_constraints: Guess RelDataModel constraints based on the provided or...

In ReDaMoR: Relational Data Modeler

Guess RelDataModel constraints based on the provided or existing tables

Description

Guess RelDataModel constraints based on the provided or existing tables

Usage

guess_constraints(
  x,
  data = NULL,
  env = parent.frame(n = 1),
  constraints = c("unique", "not nullable", "foreign keys")
)

Arguments

x	a RelDataModel
data	a named list of tables. All names of x should exist in data. If NULL, the data are taken from env.
env	the R environment in which to find the tables
constraints	the type of constraints to guess

Details

The guessed constraints should be carefully review, especially the foreign keys.

Complex foreign keys involving multiple fields are not guessed.

Value

A RelDataModel

Examples

## Read data files ----
to_read <- list.files(
   system.file("examples/HPO-subset", package="ReDaMoR"),
   full.names=TRUE
)
hpo_tables <- list()
for(f in to_read){
   hpo_tables[[sub("[.]txt$", "", basename(f))]] <- readr::read_tsv(f)
}
## Build the model from a list of data frames ----
new_model <- df_to_model(
   list=names(hpo_tables), envir=as.environment(hpo_tables)
)
## Guess constraints and auto layout ----
new_model <- guess_constraints(new_model, data = hpo_tables) %>%
   auto_layout(lengthMultiplier=250)

## Plot the model ----
new_model %>%
   plot()

ReDaMoR documentation built on April 4, 2025, 2:39 a.m.