Skip to contents

Validation information for a database tbl, result of a confront.tbl_sql().

Value

tbl_validation object. See details.

Details

The tbl_validation object contains all information needed for the confrontation of validation rules with the data in the database table. It contains:

  • $query: a dbplyr::tbl_dbi object with the query to be executed on the database

  • $tbl: the dbplyr::tbl_dbi pointing to the table in the database

  • $key: Whether there is a key column, and if so, what it is.

  • $record_based: logical with which rules are record based.

  • $exprs: list of validation rule expressions

  • $working: logical, which of the rules work on the database. (whether the database supports this expression)

  • $errors: list of validation rules that did not execute on the database.

  • $sparse: If TRUE the query default presented as a sparse validation object.

  • $subqueries: list of sparse queries for each of the rules.

See also

Other validation: confront.tbl_sql(), values,tbl_validation-method

Other tbl_validation: compute.tbl_validation()