Validate study references (Database Version) — validate_study_reference

This function checks if the study reference provided in the dataset exists in the database. Note: This function assumes that the data is already present in the database.

Usage

validate_study_reference_db(
  con,
  table_name,
  row_number_col,
  study_short_code_col,
  controls = FALSE,
  error_if_exists = FALSE
)

Arguments

con: A database connection object.
table_name: The name of the formatted CSV table in the database.
row_number_col: The name of the row number column.
study_short_code_col: The name of the study short code column.
controls: Whether are not we are validating controls. Controls have 'Batches' instead of studies.
error_if_exists: Whether to indicate an error if a study / batch is already in the database.

Value

ErrorData object indicating any studies not found.