confront_tbl: create a table with per record if it abides to the rule.

In validatedb: Validate Data in a Database using 'validate'

Description

create a table with per record if it abides to the rule.

Usage

confront_tbl(tbl, x, key = NULL)

Arguments

tbl	dbplyr::tbl_dbi() table in a database, retrieved with tbl()
x	validate::validator() object with validation rules.
key	character with key column name.

Details

The return value of the function is a list with:

• $query: A dbplyr::tbl_dbi() object that refers to the confrontation query.

• $errors: The validation rules that are not working on the database

• $working: A logical with which expression are working on the database.

• $exprs: All validation expressions.

• $nexprs: Number of working expression.

Value

a list with needed information, see details.

validatedb documentation built on Oct. 6, 2021, 5:17 p.m.