Check for Control Existence — check_control

This function checks for unmatched rows based on the control IDs in a specified table when compared to the study_subject table. It returns an error data if there are unmatched rows.

Usage

check_control_exists(
  con,
  table_name,
  row_number_col,
  control_col,
  batch_col,
  error_if_exists = FALSE
)

Arguments

con: A database connection.
table_name: The name of the table to check.
row_number_col: The name of the row number column.
control_col: The name of the control column.
batch_col: The name of the batch column.
error_if_exists: If TRUE, returns an error if the control ID exists. If FALSE, returns an error if the control ID does not exist.

Value

NULL if there is no error, otherwise an ErrorData object with appropriate description and data frame.