Provide way to check referential integrity

[krlmlr]

After b23b969, we need an easy way to check integrity of all pk and fk constraints, with an option to show where integrity is violated:

• one function that returns a data frame with results of the integrity check
• one function that throws an error if integrity is violated, calls the first function

What's a good name?

[krlmlr]

Code snippet:

cdm_check_constraints <- function(dm) {
  pks <- cdm_get_all_pks()
  pk_results <- pmap(pks, ~ is_unique_key(...))
  fks <- cdm_get_all_fks()
  fk_results <- pmap(fks, ~ is_subset(...))

  list(
    pk = pk_results,
    fk = fk_results
  )
}

Needs #24 for consistent output.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.